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