Introduction
________________ go from the top to bottom of the spreadsheet
Column
True or false: You can use the arrow keys on your keyboard to move between cells.
True
__________________ are numerical facts about a group of data.
Statistics
Formatting is applied to the______________ cell
Active Cell
What is the shortcut for paste?
Ctrl V
_________________ go from the the left to the right
Rows
Click ____________________ a cell to select it.
inside
When you select two or more cells, statistics for the cells will appear at the _________________ of the spreadsheet.
bottom
True or False: Format attributes include Font, Font Style, and Increase Indent
False,
Format attributes include font, font style, and font color.
Name one math operator.
Examples: Addition +
Subtraction -, Multiplication *, Division/
A __________________ is where a column and row intersect
Cell address
Which method has the following steps:
1. Click and hold on the first cell.
2. Drag the mouse to select all the cells
3. Release the mouse button when done.
Click and Drag method
the cell reference is the ____________ cell, and the _________________ cell
first, last
How many alignments are located in Google Sheets?
6
What tells the spreadsheet that you are starting a formula?
Equal Sign
Each rectangle in a spreadsheet is a ____________
cell
Which method has the following steps:
1. Click on the first cell in the group.
2. Hold down the Shift key.
3. Scroll to and click on the last cell in the group.
4. Release the Shift key.
Shift (Key) Method
When you select a group of cells, the cell reference is the first cell, and the last cell, of the selected block, separated by a ________________.
colon
What should you enter before a number to tell Google Sheets to format the number as a currency.
Dollar sign
How many ways can you enter a formula?
2
The default name for the first sheet is ________________
Sheet 1
Which method has the following steps:
1. Click on the first cell you want to select.
2. Hold down the Ctrl key.
3. Click the remaining cells.
4. Release the Ctrl key.
CTRL Key Method
True or False:
If you select cells that do not have a numerical value, those cells are not included in the statistics.
True
Entering a month, day and year separated by ________________ tells Excel to format the number as a date.
slashes
A ________________ indicates the type of calculation to be done.
operator