stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Google Sheets Flashcards | StudBud
Explore
/
Google Sheets
Google Sheets
27 terms
·
StudBud Administration
·
201 plays
A #computers #googlesheets
Flashcards
27 cards
F
Practice quiz
P
Host live
L
Questions
27
Answers
1
Which function would you use to
add
the values of several cells?
SUM
AVERAGE
MAX
MIN
2
Oops, need to add a row to the top of your sheet. What menu option should you use?
Edit-Delete Row
File-Save As
Format-Wrap text
Insert-Row Above
3
In which cell do you see the number 41?
E5
G6
F6
A5
4
A _______ is the intersection of a row and a column. (Hint: The box outlined in blue)
coordinate
cell
form
box
5
A function is like a math ______.
formula
operation sign
equal sign
word problem
6
What number is in cell D3?
39
3
18
32
7
What is this cell called (its address)?
B2
A4
A1
1A
8
What can be modified with this drop-down menu?
font
cell borders
cell color
text alignment
9
What can be modified with this drop-down menu?
cell borders
cell color
font
text alignment
10
The cursor will turn into a
double arrow
when you ....
add data (text) to a cell.
modify the height of a row.
drag and drop a range from one column to the next.
modify the width of a column.
11
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
12
The numbers 1, 8, 15, 22, 29, and 36 are all in....
Column A
Row A
Column 1
Row 1
13
What symbol do you start every spreadsheet function with?
=
>
+
&
14
In the picture shown, what do each of the different colored dotted lines represent?
math operations
parts of argument
ranges
functions
15
A function....
sorts info using specific values in a particular order.
prints data from a range of cells
is a predefined formula that performs calculations.
16
This picture shows...
how to rename a Google Sheet.
how to start a new spreadsheet (Google Sheet).
how to save a Google Sheet.
17
In a spreadsheet, letters stand for _____ while numbers stand for_____.
circles, tables
tables, circles
rows, columns
columns, rows
18
How do you
Freeze
a row or column?
Data-Filter
Edit - Column Right/Left
Insert-Row Above/Below
View-Freeze
19
In the function shown,
SUM
is the____.
Function Name
Equation
Filter
Argument
20
When you highlight multiple cells that is called a ______.
group
range
column
sort
21
What menu item is highlighted?
merge
undo
copy
fill
22
Is it important to follow the
order of operations
when creating a formula?
No, Sheets will automatically put it in order.
Yes, or Sheets will not calculate the results accurately.
IDK?????
Yes, or Docs will not calculate the results correctly.
23
What would be the result of the function =SUM(A1:A3)?
1
36
15
24
24
_______ allows you to customize the
look
of your spreadsheet, making it easier to understand.
Text
Formatting
Functions
Margins
25
Which of the following are recognized as mathematical operators within Google Sheets?
-
+
/
*
26
What can be modified with this drop-down menu?
text alignment
cell color
font size
cell borders
27
What does
sort
do?
Organizes all of the data from least to greatest.
Organizes the data in all columns into alphabetical order.
Organizes all of the data in your spreadsheet by one column.
Organizes the data by date it was typed.
