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