WorksheetsAES Excel Essentials Unit 1 & 2 Module Review
Total questions: 31
Worksheet time: 12mins
You accidentally delete a large portion of your spreadsheet. How do you get the information back?
Press Ctrl+C
Press Ctrl+Z
Press Ctrl+V
Press Backspace
You cannot
Which sequence of keyboard 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
How are a cell's content and format related?
The content and format are the same.
They are independent and not related.
Changing the format affects the content.
Which of the following is NOT a way to change the column width in Excel?
Click and drag the column's boundary line to the desired width.
Double-click the column's boundary line.
Right-click the column header and then click Column Width.
Double-click the column header and then click Delete.
All of the above
What are the pieces of information that describe the appearance of a cell's content?
Format attributes
Edit attributes
Paste attributes
Active attributes
Which keyboard shortcut underlines text in a cell?
Ctrl+I
Ctrl+U
Ctrl+X
Ctrl+B
Which keyboard shortcut would you press to copy cells that are selected in a spreadsheet?
Ctrl+C
Ctrl+V
Ctrl+X
Ctrl+Z
How can you force a certain order of operations in a formula?
They cannot be forced
By using simple formulas
By using parentheses
By positioning the operations from left to right
Which FORMULA contains a cell reference?
=21-6
=G10
=10+13
=F6/3
Using the correct order of operations, what does this formula equal? =(4-2)*6/2
6
2
8
4
What is the argument in this formula? =COUNT(B11:H14)
B11
B11:H14
COUNT
H14
Using the correct order of operations, what does this formula equal? =16/4*2
4
2
8
16
A cell has a very long formula that you must edit. What would be the best way to edit the formula.
Select the cell and edit the formula in the Formula Bar
Double-click on the cell and edit the formula in the cell.
In the formula "=D10+15", what part of the formula is the "15"?
An operator
An operand
In the formula "=F3+5", what part of the formula is the "+"?
An operand
An operator
Which formula is a complex formula?
=10-(A3-D13)
=C3+10+E3
=D6/5
=5+A1*B1
Which of these statements about cell references is NOT true?
Cell references can only be entered in a formula by using the Formula Bar.
You can enter a cell reference in a formula by clicking the cell location on the spreadsheet.
Cell references make it easy to use values from other cells in a formula.
You can enter a cell reference in a formula by typing in the reference.
Define the following operator: /
Addition
Division
Subtraction
Multiplication
Which command would you use if you wanted to move row 6 in between rows 3 and 4 without overwriting any data.
Insert copied cells
Merge
Insert
Paste
Which key should you press to select the cells shown in the image?
Ctrl
Del
Enter
Shift
Which letter on the image is a Cell?
A
B
C
D
Which letter on the image is a Column?
A
B
C
D
Which Clear command would you use to make cell A2 look like cell B3?
Clear All
Clear Contents
Clear Formats
What number would the formula "=COUNT(A2:A7)" return?
4
6
5
3
Which formula would you enter to return the number 45.1?
=MAX(A2:B5)
=MIN(A2:B5)
=SUM(A2:B5)
=AVERAGE(A2:B5)
What is the best formula for finding the total value for cells B2 through B5?
=SUM(B2:B5)
=B1++B5
=13.5+6.08+7.53+45.1
=B2+B3+B4+B5
Where is the Formula Bar?
A
B
C
D
E
What tab group would you use to change the format of cell A2 to match cell A3?
Alignment
Cells
Number
Font
Styles
Define the following operator: *
Addition
Division
Subtraction
Multiplication
Define the following operator: +
Addition
Division
Subtraction
Multiplication
Define the following operator: -
Addition
Division
Subtraction
Multiplication
