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