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