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