30 questions
Using the correct order of operations, what does this formula equal? =(4-2)*6/2.
6
8
2
4
Which of the following is a valid formula?
=E10
=B5/10
A2/F2
(C2-D16)
Which formula contains a cell reference?
=10+3
=F6/3
=21-6
=G10
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
Which keyboard shortcut would you use to copy cells that are selected?
Ctrl+C
Ctrl+Z
Ctrl+X
Ctrl+V
What does Ctrl+Z do?
Paste
Copy
Cut
Undo
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.
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.
Clicking on a cell will show its content in the Formula Bar.
True
False
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
Define the following operator: /
Division
Multiplication
Addition
Subtraction
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
What are the pieces of information that describe the appearance of a cell's content?
Format attributes
Paste attributes
Edit attributes
Active attributes
The order of operations defines which parts of a complex formula are calculated first.
True
False
In this formula, which calculation would be performed first? 12*27+(71-54)
It is unknown
12*27
71-54
27+(71-54)
Define the following operator: *
Division
Multiplication
Addition
Subtraction
Using the correct order of operations, what does this formula equal? 4/(5-3)*2
3
2
1
4
Using the correct order of operations, what does this formula equal? =5+3*2
11
10
15
20
Define the following operator: +
Addition
Subtraction
Multiplication
Division
In the formula =F3+5, what part of the formula is the "+"?
Operand
Operator
Which keyboard shortcut underlines text in a cell?
Ctrl+B
Ctrl+X
Ctrl+I
Ctrl+U
In the formula D10+15, what part of the formula is the "15"?
The operator
The operand
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
If you wanted to clear the type of font in a cell, which clear command would you use?
Clear All
Clear Content
Clear Format
What is the address of the currently selected cell?
D1
B4
1D
B5
Which key should you press to select the cells shown in the image?
Del
Enter
Shift
Ctrl
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.
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)
In a spreadsheet, what is the currently selected cell called?
The chosen cell
The active cell
The outlined cell
The green cell
What tab group would you use to change the format of cell A2 to match cell A3?
Cells
Number
Styles
Font