Have an account?
Skip to Content
Build your own quiz
30 questions
Show Answers
See Preview
- 1. Multiple Choice
Using the correct order of operations, what does this formula equal? =(4-2)*6/2.
6
8
2
4
- 2. Multiple Choice
Which of the following is a valid formula?
=E10
=B5/10
A2/F2
(C2-D16)
- 3. Multiple Choice
Which formula contains a cell reference?
=10+3
=F6/3
=21-6
=G10
- 4. 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
- 5. Multiple Choice
Which keyboard shortcut would you use to copy cells that are selected?
Ctrl+C
Ctrl+Z
Ctrl+X
Ctrl+V
- 6. Multiple Choice
What does Ctrl+Z do?
Paste
Copy
Cut
Undo
- 7. Multiple Choice
A cell has a very long formula that you must edit. What is 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.
- 8. Multiple Choice
How are a cell's content and format related?
Changing the format affects the content.
They are independent and not related.
The content and format are the same.
- 9. Multiple Choice
Clicking on a cell will show its content in the Formula Bar.
True
False
- 10. Multiple Choice
Which sequence of shortcuts would you use to MOVE information from one cell to another?
Ctrl+X then Ctrl+V
Ctrl+C then Ctrl+V
Ctrl+V then Ctrl+Z
Ctrl+X then Ctrl+Z
- 11. Multiple Choice
Define the following operator: /
Division
Multiplication
Addition
Subtraction
- 12. Multiple Choice
You accidentally delete a large portion of the worksheet. How do you get it back?
Press Ctrl+C
Press Ctrl+Z
Press Ctrl+V
You cannot
- 13. Multiple Choice
What are the pieces of information that describe the appearance of a cell's content?
Format attributes
Paste attributes
Edit attributes
Active attributes
- 14. Multiple Choice
The order of operations defines which parts of a complex formula are calculated first.
True
False
- 15. Multiple Choice
In this formula, which calculation would be performed first? 12*27+(71-54)
It is unknown
12*27
71-54
27+(71-54)
- 16. Multiple Choice
Define the following operator: *
Division
Multiplication
Addition
Subtraction
- 17. Multiple Choice
Using the correct order of operations, what does this formula equal? 4/(5-3)*2
3
2
1
4
- 18. Multiple Choice
Using the correct order of operations, what does this formula equal? =5+3*2
11
10
15
20
- 19. Multiple Choice
Define the following operator: +
Addition
Subtraction
Multiplication
Division
- 20. Multiple Choice
In the formula =F3+5, what part of the formula is the "+"?
Operand
Operator
- 21. Multiple Choice
Which keyboard shortcut underlines text in a cell?
Ctrl+B
Ctrl+X
Ctrl+I
Ctrl+U
- 22. Multiple Choice
In the formula D10+15, what part of the formula is the "15"?
The operator
The operand
- 23. Multiple Choice
Which method is the most common way to select multiple cells, as shown in the image?
Shift key method
Ctrl key method
Click and drag method
- 24. Multiple Choice
If you wanted to clear the type of font in a cell, which clear command would you use?
Clear All
Clear Content
Clear Format
- 25. Multiple Choice
What is the address of the currently selected cell?
D1
B4
1D
B5
- 26. Multiple Choice
Which key should you press to select the cells shown in the image?
Del
Enter
Shift
Ctrl
- 27. Multiple Choice
What is the difference between a row and a column?
Columns are vertical and labeled with letters and rows are horizontal and labeled with numbers.
Columns are horizontal and labeled with numbers and rows are vertical and labeled with letters.
- 28. Multiple Choice
What is the best formula for finding the total value for cells B2 through B5?
=B1++B5
=13.5+6.08+7.53+45.1
=B2+B3+B4+B5
=SUM(B2:B5)
- 29. Multiple Choice
In a spreadsheet, what is the currently selected cell called?
The chosen cell
The active cell
The outlined cell
The green cell
- 30. Multiple Choice
What tab group would you use to change the format of cell A2 to match cell A3?
Cells
Number
Styles
Font
- Answer choicesTagsAnswer choicesTags