stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Google Sheets Flashcards | StudBud
Explore
/
Google Sheets
Google Sheets
30 terms
·
StudBud Administration
·
27 plays
A #computers #googlesheets
Flashcards
30 cards
F
Practice quiz
P
Host live
L
Questions
30
Answers
1
A _______ is the intersection of a row and a column. (Hint: The box outlined in blue)
cell
coordinate
box
form
2
_______ allows you to customize the
look
of your spreadsheet, making it easier to understand.
Text
Margins
Formatting
Functions
3
When you highlight multiple cells that is called a ______.
group
sort
column
range
4
See the range of cells for average. Choose true statement.
range of cells is not correct
wrong function was applied
Highest value was calculated correctly
Sum function is used to calculate highest value.
5
Oops, need to add a row to the top of you sheet. What menu option should you use?
Insert - Row Below
Insert-Row Above
Format row above
Edit-Delete Row
6
To move a range of data from one column to another you might use.
handle
drag and drop
7
What can be modified with this drop-down menu?
cell borders
text alignment
cell color
font
8
In the function shown,
SUM
is the____.
Function Name
Equation
Filter
Argument
9
What is a function?
predefined formula that performs calculations.
Sorts info using specific values in a particular order.
format of number
manual formula you have to create
10
In function shown for total sales,
the result of $676
is the____.
Equation
Function Name
Filter
Argument
11
To begin calculation in Excel, start with + sign
False
True
12
The cells in Row 1 (title) were merged as one.
False
True
13
Service charge amounts were highlighted using ______________
special formatting
sort feature
conditional edit
conditional formatting
14
This picture shows...
Did we learn this?????
how to rename a Google Sheet.
how to save a Google Sheet.
how to start a new Spreadsheet (Google Sheet).
15
This is example of a _____________ chart.
column
row
pie
line
16
In a spreadsheet, letters stand for _____ while numbers stand for_____.
rows, columns
columns, rows
17
What is this cell called (its address)?
1A
B2
A4
A1
18
What can be modified with this drop-down menu?
font
cell color
text alignment
cell borders
19
The name of a cell (for example, A1) is its cell ________.
content
heading
location
address
20
How do you
Freeze
a row or column?
Insert-Row Above/Below
View-Freeze
Data-Filter
Edit - Column Right/Left
21
To add $ or decimals to numbers, click on ________ tab.
file
view
format
data
22
A function is like a math ______.
word problem
operation sign
equal sign
formula
23
The fill ______ can be used to continue a
series and fill remaining formulas.
handle
drag and drop
24
Which of the following are recognized as mathematical operators within Google Sheets?
Choose 2 answers.
?
@
/
+
25
What can be modified with this drop-down menu?
cell borders
cell color
text alignment
font
26
It is important to follow the ____________ when creating a formula.
order of operations
a path of mathematical genius
formula sequence
order of functions
27
Which function would you use to
add
the values of several cells?
MAX
AVERAGE
SUM
MIN
28
Google sheets is a word processing application.
True
False
29
If you have too much cell content to be displayed in a single cell, you may...
wrap text
protect the cells
unmerge cells
modify a cell's row height
30
_____________________ formatting allows you to apply specific
formatting
to cells that meet certain criteria.
graphical
functional
conditional
special