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