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