Have an account?
Skip to Content
Build your own quiz
29 questions
Show Answers
See Preview
- 1. Multiple Choice
Using the correct order of operations, what does this formula equal? =(4-2)*6/2
4
8
6
2
- 2. Multiple Choice
A cell has a very long formula that you must edit. What would be the best way to edit the formula.
Double-click on the cell and edit the formula in the cell
Select the cell and edit the formula in the Formula Bar
- 3. Multiple Choice
How are a cell's content and format related?
They are independent and not related
Changing the format affects the content
The content and format are the same
- 4. Multiple Choice
Which letter on the image is a Column?
A
B
C
D
- 5. Multiple Choice
What tab group would you use to change the format of cell A2 to match cell A3?
Styles
Numbers
Cells
Alignment
Font
- 6. Multiple Choice
What number would the formula "=COUNT(A2:A7)" return?
3
4
5
6
- 7. Multiple Choice
Which keyboard shortcut would you press to copy cells that are selected in a spreadsheet?
Ctrl+X
Ctrl+C
Ctrl+V
Ctrl+Z
- 8. Multiple Choice
Using the correct order of operations, what does this formula equal? =16/4*2
2
4
8
16
- 9. Multiple Choice
What are the pieces of information that describe the appearance of a cell's content?
Edit attributes
Paste attributes
Active attributes
Format attributes
- 10. Multiple Choice
Define the following operator: /
Multiplication
Division
Addition
Subtraction
- 11. Multiple Choice
You accidentally delete a large portion of your spreadsheet. How do you get the information back?
Press Ctrl+Z
Press Ctrl+V
Press Ctrl+C
You cannot
- 12. Multiple Choice
In the formula "=F3+5", what part of the formula is the "+"?
An operator
An operand
- 13. Multiple Choice
Which command would you use if you wanted to move row 6 in between rows 3 and 4 without overwriting any data.
Merge
Insert Copied Cells
Insert
Paste
- 14. Multiple Choice
Which key should you press to select the cells shown in the image?
Del
Ctrl
Enter
Shift
- 15. Multiple Choice
How can you force a certain order of operations in a formula?
By using simple formulas
They cannot be forced
By using parentheses
By positioning the operations from left to right
- 16. Multiple Choice
Which formula contains a cell reference?
=21-6
=F6/3
=10+13
- 17. Multiple Choice
Which formula is a complex formula?
=10-(A3-D13)
=C3+10+E3
=5+A1*B1
=D6/5
- 18. Multiple Choice
Which of the following is NOT a way to change the column width in Excel?
Double-click the column's boundary line.
Double-click the column header and then click Delete.
All of the above
Right-click the column header and then click Column Width.
Click and drag the column's boundary line to the desired width.
- 19. Multiple Choice
Cell C2 contains the formula "=10+D3". If you copied C2 to A1, what would be the formula in A1?
=10+B4
=10+F2
=10+F4
=10+B2
- 20. Multiple Choice
What is the argument in this formula? =COUNT(B11:H14)
H14
COUNT
B11:H14
B11
- 21. Multiple Choice
Which of these statements about cell references is NOT true?
You can enter a cell reference in a formula by typing in the reference
Cell references make it easy to use values from other cells in a formula
You can enter a cell reference in a formula by clicking the cell location on the spreadsheet
Cell references can only be entered in a formula by using the Formula Bar
- 22. Multiple Choice
Which sequence of keyboard shortcuts would you use to MOVE information from one cell to another?
Ctrl+V then Ctrl+Z
Ctrl+X then Ctrl+Z
Ctrl+X then Ctrl+V
Ctrl+C then Ctrl+V
- 23. Multiple Choice
Which formula would you enter to return the number 45.1?
=AVERAGE(A2:B5)
=MAX(A2:B5)
=SUM(A2:B5)
=MIN(A2:B5)
- 24. Multiple Choice
In the formula "=D10+15", what part of the formula is the "15"?
An operator
An operand
- 25. Multiple Choice
Which keyboard shortcut underlines text in a cell?
Ctrl+X
Ctrl+I
Ctrl+B
Ctrl+U
- 26. Multiple Choice
Which letter on the image is a Cell?
A
B
C
D
- 27. Multiple Choice
Which Clear command would you use to make cell A2 look like cell B3?
Clear Contents
Clear Formats
Clear All
- 28. Multiple Choice
Where is the Formula Bar?
A
B
C
D
E
- 29. Multiple Choice
What is the best formula for finding the total value for cells B2 through B5?
=13.5+6.08+7.53+45.1
=B1++B5
=B2+B3+B4+B5
=SUM(B2:B5)
- Answer choicesTagsAnswer choicesTags