stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
BTT Google Sheets #2 Flashcards | StudBud
Explore
/
BTT Google Sheets #2
BTT Google Sheets #2
22 terms
·
StudBud Administration
·
484 plays
#googlesheets
Flashcards
22 cards
F
Practice quiz
P
Host live
L
Questions
22
Answers
1
What can be modified with this drop-down menu?
cell color
text alignment
font
cell borders
2
What can be modified with this drop-down menu?
cell color
font
text alignment
cell borders
3
This picture shows...
how to save a Google Sheet.
Did we learn this?????
how to rename a Google Sheet.
how to start a new Spreadsheet (Google Sheet).
4
What menu item is highlighted?
copy
merge
undo
fill
5
Which function would you use to
add
the values of several cells?
MIN
AVERAGE
MAX
SUM
6
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 from least to greatest.
Organizes all of the data in your spreadsheet by one column.
7
When you highlight multiple cells that is called a ______.
column
sort
range
group
8
Sorting a range will not affect other content on the worksheet.
False
True
9
What is a function?
predefined formula that performs calculations.
Sorts info using specific values in a particular order.
10
Can you filter for more than one thing?
Yes
No
11
Which of the following are recognized as mathematical operators within Google Sheets?
/
*
^
+
12
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 Above
Insert - Row Below
13
In the function shown,
SUM
is the____.
Argument
Filter
Equation
Function Name
14
_______ allows you to customize the
look
of your spreadsheet, making it easier to understand.
Margins
Formatting
Functions
Text
15
A function is like a math ______.
word problem
operation sign
equal sign
formula
16
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
17
In a spreadsheet, letters stand for _____ while numbers stand for_____.
columns, rows
rows, columns
18
How do you
Freeze
a row or column?
View-Freeze
Edit - Column Right/Left
Insert-Row Above/Below
Data-Filter
19
The cursor will turn into a
double arrow
when you ....
add data (text) to a cell.
drag and drop a range from one column to the next.
modify the width of a column.
modify the height of a row.
20
If you have too much cell content to be displayed in a single cell, you may...
protect the cells
wrap text
unmerge cells
modify a cell's row height
21
What can be modified with this drop-down menu?
text alignment
cell color
cell borders
font
22
Is it important to follow the
order of operations
when creating a formula?
No, Sheets will automatically put it in order.
IDK?????
Yes, or Docs will not calculate the results correctly.
Yes, or Sheets will not calculate the results accurately.
