Font size
WorksheetsGoogle Sheets
Total questions: 16
Worksheet time: 9mins
Which Menu tab would you use to access the command to clear a cell's format?
File
Edit
View
Format
Data
Where would you click to select a column?
A
B
C
D
Which letter on the image is a column?
A
B
C
D
Which letter on the image is a Cell?
A
B
C
D
What is the address of the indicated cell?
B4
4B
C4
B5
Which keyboard shortcut would you press to cancel a command?
Backspace
Escape
Tab
Delete
To select a very large group of cells, you can click on the first cell in the group, hold down the (a) key, and then click on the last cell in the group.
Which of the following statements is TRUE?
The content and format of a cell are the same.
The content and format of a cell are independent.
Changing the format of a cell also affects its content.
Which method is best for selecting the cells highlighted in red?
Press the Shift key and click on the cells.
Click and drag the mouse to select the cells.
Press the Ctrl key and click on the cells.
Press the Alt key and click on the cells.
Which method is best for selecting the cells highlighted in red?
Press the Ctrl key and click on the cells.
Click and drag the mouse to select the cells
Press the Shift key and click on the cells.
Press the Alt key and click on the cells.
Which sequence of keyboard shortcuts would you use to COPY information from one cell to another?
Ctrl+X then Ctrl+Z
Ctrl+C then Ctrl+V
Ctrl+V then Ctrl+Z
Ctrl+X then Ctrl+V
What does the keyboard shortcut "Ctrl+Z" do?
Paste
Cut
Copy
Undo
What symbol is used to designate an absolute cell reference?
!
%
@
$
In a spreadsheet all formulas must begin with what symbol?
#
$
!
=
What function should be entered into B7 to calculate the total budget?
=SUM(B3:B6)
=CALCULATE(B3:B6
=SUM(B3-B6)
=AVERAGE(B3:B6)
Where is the formula bar?
A
B
C
D
