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