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