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