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