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