WorksheetsGoogle Sheets
Total questions: 35
Worksheet time: 29mins
B1 is a?
row
column
cell
sheet
You can adjust the size of columns in Sheets.
True
False
You are able to change the colors shown in a chart.
True
False
What is the name of the selected cell?
You can only apply a border to the bottom of cells in Google Sheets
True
False
Which letter on the image is a column?
A
B
C
D
Which letter on the image is a Cell?
A
B
C
D
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 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 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
Which picture represents Google Sheets?
What are the rectangles used to hold data in a spreadsheet called?
Cells
Data Holders
Grids
Data Locators
What is the title of this Google Spreadsheet Document?
Hurricanes vs. Year
Hurricanes
Year
Unnamed
What is the name of the spreadsheet?
Hurricanes
Sheet 1
Unnamed
Hurricanes vs. Year
How would you format a large amount of text to fit in a single cell?
Overflow
Wrap
Clip
It's not possible.
Oops, you forgot to add a row to the top of your spreadsheet, you should click on ...?
Edit then delete row
File then Save As
Insert then Row Above
Insert then Row Below
Oops, you need to delete an entire row, you should select the row then ...?
Press backspace
Press delete
Press "ctrl" and "x" at the same time
Right click, then select "delete row"
To create a simple chart, you would click on Insert, then...?
Chart
Image
Drawing
Form
If I want to add a Chart, one way is to select the ____________ tab.
Home
Insert
Page
Data
