Week 1 Quiz Flashcards

1
Q

Which two tabs on the Excel ribbon are used to view and format the workbook in order to print?

A

Page layout
View

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is the correct F4 locking function for a full lock (both row and column)?

A

=$A$2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the formula for summing?

A

=SUM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How do you spellcheck in Excel?

A

Review

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is the correct designation for letters and rows?

A

Letters= columns
Numbers= rows

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What does a blue number mean?

A

Hard (manual) input

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What does a green number mean?

A

Linked

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What does a black number mean?

A

Formula

How well did you know this?
1
Not at all
2
3
4
5
Perfectly