stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
GoogleSheets Review Flashcards | StudBud
Explore
/
GoogleSheets Review
GoogleSheets Review
52 terms
·
StudBud Administration
·
32 plays
Imported from external platform
Flashcards
52 cards
F
Practice quiz
P
Host live
L
Questions
52
Answers
1
What is the space above row 1 and to the left of column A that is the same as pressing Ctrl+A?
Sum
PEMDAS
Formula bar
Select All
2
What is this Google Sheets tool used for?
Sort
Function
Formula
Filter
3
What is a side section of a chart that gives a small text description of each series?
X Axis
Legend
Column Chart
Y Axis
4
True or False:
=SUM(B2:H2) is an example of a formula.
False
True
5
What is the keyboard key you press to calculate a formula or function?
Space
Esc
Enter
Sum
6
What does this sheet tool allow you to do?
Format as percent
Merge cells
Add borders
Rotate text
7
True or False: The function (SUM) adds up all the values of the cells in the argument.
True
False
8
What sort is A-Z or 1-10?
Ascending
Function
Descending
Absolute Reference
9
What is this Google Sheets tool?
Filter
Select All
Fill Handle
Functions
10
What is this Google Sheets tool?
Wrap
Borders
Merge
Slant Text
11
What is the small square at the bottom right corner of the active cell that lets you copy or continue a series?
Merge
Legend
Range
Fill handle
12
What are 2 or more adjacent cells on a sheet?
Merge
Range
Average
Legend
13
What is located above the worksheet and allows you to edit the formula.
Formula Bar
Worksheet Tabs
Select All
Toolbar
14
When there's more than one operation in a formula, the ____ tells Google Sheets which operation to calculate first.
Fill Handle
Absolute Reference
Orders of Operations
Filter
15
When writing functions your cell references must be enclosed in these.
" "
( )
$ $
[ ]
16
What is a horizontal section of a worksheet identified by numbers and you adjust the height?
Sort
Column
Axis
Row
17
What is the default name of a sheet?
1
Page 1
New Sheet
Sheet 1
18
What is the Y axis of a chart?
Horizontal Axis
Series
Legend
Vertical Axis
19
True or False: Click and drag the border down to increase the row height
False
True
20
True or False: A2 is defined as an absolute cell reference.
True
False
21
What is combining cells?
Slanting
Wrapping
Sorting
Merging
22
What is this Google Sheets tool?
Sort
Freeze
Currency
More Formats
23
What is this type of chart?
Pie
Area
Column
Line
24
What is the function that will calculate the average of the values in the cell range B1:B9?
=AVERAGE(B1:B9)
AVERAGE(B1:B9)
=AVERAGE(B1:B9)/9
AVE(B1,B9)
25
True or False: Google Sheets will not always tell you if your formula contains an error, so it's up to you to check.
True
False
26
What is the purpose of this symbol?
Rotate text
Align text
Change the size of text
To add arrows with the text
27
True or False: The correct order of operations is (Parenthesis, Exponents, AdditionSubtraction, MultiplicationDivision).
False
True
28
True or False: Column width cannot be adjusted
True
False
29
What is the function that determines the highest cell value included in the argument?
SUM
MAXIMUM
MINIMUM
AVERAGE
30
What is this type of chart?
Line
Column
Area
Pie
31
True or False: You should freeze the header row so the header labels will not be included in the sort.
False
True
32
What temporarily hides any content that doesn't match the criteria?
Filter
Delete
Function
Sort
33
True or False: One purpose of the fill handle is to continue a series.
False
True
34
What consists of the column letter and row number surrounded by dollar signs ($)?
Relative Reference
Sort
Maximum
Absolute Reference
35
What is this Google Sheets tool?
Insert Chart
Borders
Sort
Filter
36
What is the X axis of a chart?
Series
Horizontal Axis
Vertical Axis
Legend
37
What is the order of operations?
Addition and subtraction
Filtering
Selecting All
PEMDAS
38
Formulas should always begin with a(n) ________.
=
*
SUM
Hashtag
39
What sign is used to keep a row and/or column constant in the formula no matter where they are copied?
$
:
( )
,
40
True or False: When writing functions your cell references must be enclosed in dollar signs.
False
True
41
What is this Google Sheets tool?
Decrease Decimal
Decrease Indent
Increase Decimal
Increase Indent
42
What tab in Google Sheets allows you to insert a chart?
Edit
Chart
Insert
File
43
What is this Google Sheets tool?
Merge
Wrap
Slant Text
Borders
44
What is a predefined formula that performs calculations like SUM or AVERAGE using specific values in a particular order?
PEMDAS
Sort
Function
Formula
45
What is identified by letters and the width can be changed in Google Sheets?
Trend Lines
Columns
Rows
Gridlines
46
True or False: You can unmerge cells in Google Sheets.
True
False
47
True or False: You are unable to zoom in Google Sheets.
True
False
48
What can you do with your data in Sheets that gives you a better view and organizes the contents of your spreadsheet?
Sort
Absolute Reference
AutoFill
Filter
49
What is this type of chart?
Column
Area
Pie
Line
50
Which of the following symbols is NOT recognized as mathematical operators within Google Sheets?
X
+
/
*
51
What does this sheet tool allow you to do?
Decrease decimal places
Format as currency
Format as percent
Format as decimal
52
True or False: You can create charts from the data in Google Sheets.
False
True
