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