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