stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Google Sheets Review Flashcards | StudBud
Explore
/
Google Sheets Review
Google Sheets Review
21 terms
·
StudBud Administration
A #computers #googlesheets
Flashcards
21 cards
F
Practice quiz
P
Host live
L
Questions
21
Answers
1
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
2
In a spreadsheet, letters stand for _____ while numbers stand for_____.
columns, rows
rows, columns
3
A function is like a math ______.
formula
operation sign
word problem
equal sign
4
The name of a cell (for example, A1) is its cell ________.
content
location
heading
address
5
How do you
Freeze
a row or column?
View-Freeze
Insert-Row Above/Below
Data-Filter
Edit - Column Right/Left
6
What is this cell called (its address)?
A1
A4
B2
1A
7
What is a function?
Sorts info using specific values in a particular order.
predefined formula that performs calculations.
8
In the function shown,
(B2:B8)
is the____.
Argument
Filter
Equation
Function Name
9
In the function shown,
SUM
is the____.
Argument
Equation
Function Name
Filter
10
To move a range of data from one column to another you might use.
drag and drop
handle
11
Which function would you use to
add
the values of several cells?
SUM
AVERAGE
MAX
MIN
12
A _______ is the intersection of a row and a column. (Hint: The box outlined in blue)
form
coordinate
box
cell
13
The fill ______ can be used to continue a
series
by guessing what should come next .
drag and drop
handle
14
When you highlight multiple cells that is called a ______.
column
sort
range
group
15
Which of the following are recognized as mathematical operators within Google Sheets?
^
+
/
*
16
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?????
17
Is it important to follow the
order of operations
when creating a formula?
Yes, or Docs will not calculate the results correctly.
Yes, or Sheets will not calculate the results accurately.
IDK?????
No, Sheets will automatically put it in order.
18
The cursor will turn into a
double arrow
when you ....
modify the width of a column.
drag and drop a range from one column to the next.
add data (text) to a cell.
modify the height of a row.
19
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
20
What menu item is highlighted?
undo
fill
merge
copy
21
In the picture shown, what do each of the different colored dotted lines represent?
math operations
ranges
parts of argument
functions
