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