stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Google Sheets Flashcards | StudBud
Explore
/
Google Sheets
Google Sheets
44 terms
·
StudBud Administration
·
232 plays
A #computers #googlesheets
Flashcards
44 cards
F
Practice quiz
P
Host live
L
Questions
44
Answers
1
It is not possible to insert a picture into google sheets.
True
False
2
Which function would you use to get the largest value?
MAX
SUM
AVERAGE
MIN
3
Which of the following is an example of a cell range.
A1-D6
=D2/B1
F34
G1:H17
4
Which of the following cell references is read as “cell A1 through D6?”
A1-D6
A1/D6
A1:D6
A1!D6
5
Which of the following charts shows the parts of a whole?
Column
Pie
Line
Bar
6
_______ allows you to customize the
look
of your spreadsheet, making it easier to understand.
Margins
Functions
Formatting
Text
7
In the function shown,
SUM
is the____.
Function Name
Equation
Argument
Filter
8
The name of a cell (for example, A1) is its cell ________.
content
location
heading
address
9
What tool is used to copy a similar formula and function down?
Fill
Copy/Paste
Merge
Paint Format
10
Rows are..
Vertical
Horizontal
Numbered
Slanted
11
What can be modified with this drop-down menu?
text alignment
cell borders
font
cell color
12
What does
sort
do?
Organizes all of the data in your spreadsheet by one column.
Organizes all of the data from least to greatest.
Organizes the data by date it was typed.
Organizes the data in all columns into alphabetical order.
13
Which of the following can be used to copy the formatting applied to a cell?
Format Painter
Format bar
Format handle
Format Cell
14
What is this cell called ?
A4
1A
B2
A1
15
The cursor will turn into a
double arrow
when you ....
drag and drop a range from one column to the next.
modify the width of a column.
modify the height of a row.
add data (text) to a cell.
16
To move a range of data from one column to another you might use.
drag and drop
handle
autofill
copy/paste
17
Which of the following are composed of a grid system of rows and columns which cross to make cells?
Worksheets
Table guides
Formulas
Graphs
18
Which of the following is not a type of graphic representation?
Bar Chart
Line Graph
Table
Pie Chart
19
Google Sheets is similar to
Microsoft Office
Micosoft Word
Microsoft Excel
Microsoft PowerPoint
20
Columns are..
Slanted
Horizontal
Vertical
Numbered
21
Which of the following features allows you to narrow down the data in your worksheet?
data
functions
filters
cells
22
When you highlight multiple cells that is called a ______.
column
range
sort
group
23
How do you
view formulas
?
View-Formulas
Edit - Add Formulas
Insert-Row Above/Below
Data-Filter Formulas
24
The space where you work is called a worksheet.
True
False
25
Can you filter for more than one thing?
Yes
No
26
A _______ is the intersection of a row and a column. (Hint: The box outlined in blue)
coordinate
cell
box
form
27
What begins a formula or a function?
=
+
/
-
28
David wants to key the numbers 1-1000 in column A of the spreadsheet. What command should he use to complete this task?
Autofill
Find and Replace
Filter
Sort
29
Is it important to follow the
order of operations
when creating a formula?
Yes, or Sheets will not calculate the results accurately.
No, Sheets will automatically put it in order.
30
In a spreadsheet, numbers stand for _____.
rows
references
columns
ranges
31
Which of the following are recognized as mathematical operators within Google Sheets?
^
+
/
*
32
What can be modified with this drop-down menu?
cell color
text alignment
font
cell borders
33
In a spreadsheet, letters stand for _____.
columns
ranges
rows
references
34
A function is like a math ______.
operation sign
word problem
equal sign
formula
35
Which function would you use to
add
the values of several cells?
MIN
AVERAGE
MAX
SUM
36
What finds the greatest value?
Countif
Max
Sum
Min
37
What can be modified with this drop-down menu?
cell borders
font
text alignment
cell color
38
What is a function?
Sorts info using specific values in a particular order.
a scientific expression
None of the above
predefined formula that performs calculations.
39
Which of the following tools allows you to combine multiple cells into one big cell?
undo
fill
merge
copy
40
You do not have to use PEMDAS rules in spreadsheets.
True
False
41
Which of the following is the correct formula to add cells A1 and B2?
=$A1,$B2
=A1+B2
A1+B2
SUM(A1:B2)
42
In the picture shown, what do each of the different colored dotted lines represent?
PEMDAS
functions
math operations
ranges
43
In the function shown,
(B2:B8)
is the____.
Filter
Function Name
Equation
Range
44
All equations start with an = sign in google sheets.
True
False
