stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Google Sheets Flashcards | StudBud
Explore
/
Google Sheets
Google Sheets
15 terms
·
StudBud Administration
·
36 plays
Google Sheets Review
Flashcards
15 cards
F
Practice quiz
P
Host live
L
Questions
15
Answers
1
A relative cell reference does NOT change when copied to another cell.
True
False
2
Which mathematical operator is used for multiplication?
+
/
*
x
3
What tool do you use to continue a series (like 123, Monday, Tuesday, Wednesday)?
Ctrl-C
Fill Handle
Hand icon
Drag and Drop
4
Which of the following shows a RANGE of cells?
D6
A6;A12
A1,A6
D2:D8
5
To keep parts of your sheet in the same place, while other parts scroll, you should:
Sort the sheet
Protect the sheet
Filter the sheet
Freeze rows or columns
6
Each of the boxes on a Google Sheet is called a
box
grid
cell
reference
7
When following the order of operations, which calculations comes first?
5+11
11-4
3/5
4^3
8
What do the numbers (1, 2, 3...) down the left side of the sheet represent?
Functions
Rows
Columns
Cells
9
What do the letters (A, B, C...) across the top of the sheet represent?
Rows
Columns
Cells
Functions
10
What is the best formula to calculate the average age of all the students?
=AVERAGE(B3:B7)
=(B3+B4+B5+B6+B7)/5
=(B3:B7)/5
=AVG(B3:B7)
11
The name for a cell (for example, A1) is its cell _______.
Heading
Content
Address
Range
12
Which function would you use to add the values of several cells.
SUM
ADD
AVE
TOTAL
13
What Microsoft program is Google Sheets similar to?
Spreadsheet
Word
Excel
Powerpoint
14
What symbol does every formula start with?
:
+
*
=
15
Choose which one is the correct formula to total the data in Column B?
=(B3:B7)
=SUM(B3;B7)
B3+B4+B5+B6+B7
=SUM(B3:B7)
