Define...
Workbook
A collection of sheets in a single file
how can you move to the right on a sheet
What is an absolute cell reference?
A formula that doesnt change even when its copied to another cell. You would use the $ to make the cell absolute ex. E$1$
What do you use to symbolize multiplication on google sheet?
a star (*)
You can insert photos into your google sheet
True
Column
A vertical set of cells (up and down)
What does ctrl + enter do?
moves the cursor up.
Row
A horizontal set of cells. (right to left)
Which function would you use to add a set of numbers
SUM
Merging cells automatically centers the text within the merged cells.
False. You would still need to change the alignment of the cell.
A group of cells is called a ____________.
Range
What does ctrl + TAB do?
moves the cursor to the left.
Function
tells the computer what to do
Select ______ from the functions menu to find the smallest value in a group.
MIN
You can not give an exact size for a row height or column.
False. You can adjust the minimum row/column height in the settings.
formula
the combination of rows, cells, ranges and functions to get a certain outcome.
Does google sheets automatically save?
yes
cell reference
the cells address or location
What do you use to narrow down your search for data on a google sheet?
You can have multiple sheets within the same workbook.
True.
cell
a single data point on a google sheet
Formulas should always start with?
an equal sign (=)
value
anything entered in a cell.
What would this do...
=B11*8%
multiply the value of whats in cell B11 by 8%
Text wrapping in sheets means the text will be on more than 1 line within the cell.
True