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