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