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