stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Google Sheets Flashcards | StudBud
Explore
/
Google Sheets
Google Sheets
30 terms
·
StudBud Administration
·
43 plays
A #computers #googlesheets
Flashcards
30 cards
F
Practice quiz
P
Host live
L
Questions
30
Answers
1
A _______ is the intersection of a row and a column. (Hint: The box outlined in blue)
cell
box
coordinate
form
2
What can be modified with this drop-down menu?
cell color
cell borders
text alignment
font
3
When you highlight multiple cells that is called a ______.
range
column
sort
group
4
The name of a cell (for example, A1) is its cell ________.
address
location
content
heading
5
By ____, you are able to scroll through a spreadsheet while continuing to see the header cells.
freezing rows or columns in place
merging rows or columns
6
This picture shows...
how to start a new Spreadsheet (Google Sheet).
how to save a Google Sheet.
how to rename a Google Sheet.
Did we learn this?????
7
The cursor will turn into a
double arrow
when you ....
modify the width of a column.
modify the height of a row.
drag and drop a range from one column to the next.
add data (text) to a cell.
8
Sorting a range will not affect other content on the worksheet.
False
True
9
What menu item is highlighted?
copy
merge
undo
fill
10
What is a function?
Sorts info using specific values in a particular order.
predefined formula that performs calculations.
11
Which function would you use to
add
the values of several cells?
SUM
MIN
AVERAGE
MAX
12
Which of the following features allows you to narrow down the data in your worksheet?
filters
cells
functions
data
13
What can be modified with this drop-down menu?
cell borders
text alignment
font
cell color
14
_______ allows you to customize the
look
of your spreadsheet, making it easier to understand.
Functions
Text
Formatting
Margins
15
In a spreadsheet, letters stand for _____ while numbers stand for_____.
rows, columns
columns, rows
16
The fill ______ can be used to continue a
series
by guessing what should come next .
drag and drop
handle
17
In the function shown,
(B2:B8)
is the____.
Function Name
Filter
Argument
Equation
18
A function is like a math ______.
formula
operation sign
word problem
equal sign
19
Oops, need to add a row to the top of your sheet. What menu option should you use?
Edit-Delete Row
File-Save As
Insert - Row Below
Insert-Row Above
20
If you have too much cell content to be displayed in a single cell, you may...
protect the cells
wrap text
unmerge cells
modify a cell's row height
21
Which of the following are recognized as mathematical operators within Google Sheets?
/
^
+
*
22
What can be modified with this drop-down menu?
text alignment
font
cell color
cell borders
23
To move a range of data from one column to another you might use.
handle
drag and drop
24
How do you
Freeze
a row or column?
Insert-Row Above/Below
Edit - Column Right/Left
View-Freeze
Data-Filter
25
Is it important to follow the
order of operations
when creating a formula?
Yes, or Docs will not calculate the results correctly.
No, Sheets will automatically put it in order.
IDK?????
Yes, or Sheets will not calculate the results accurately.
26
In the picture shown, what do each of the different colored dotted lines represent?
parts of argument
ranges
math operations
functions
27
Can you filter for more than one thing?
No
Yes
28
What is this cell called (its address)?
1A
A1
A4
B2
29
In the function shown,
SUM
is the____.
Argument
Filter
Function Name
Equation
30
What does
sort
do?
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.
Organizes all of the data in your spreadsheet by one column.
