stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Google Sheets Review Flashcards | StudBud
Explore
/
Google Sheets Review
Google Sheets Review
50 terms
·
StudBud Administration
·
75 plays
A #computers #googlesheets
Flashcards
50 cards
F
Practice quiz
P
Host live
L
Questions
50
Answers
1
Charts on google sheets are reliant on what
They are reliant on nothing
They are reliant on what ever data is on the sheet
They are reliant on the data that you selected to create the graph
Math stuff
2
What would you use to create a spreadsheet?
Google Docs
Google Sheets
Google Presentations
Google Drawing
3
Which of the following should I click to format data as currency in Google Sheets?
%
Σ
$
4
In a spreadsheet, letters stand for _____ while numbers stand for_____.
columns, rows
rows, columns
5
What is this cell called (its address)?
B2
A1
A4
1A
6
What menu item is highlighted?
fill
merge
copy
undo
7
What is the small square that appears in the lower-right corner of the active cell or range, and is used to fill cells
4 Square
Square peg
Math Square
Fill Handle
8
What can be modified with this drop-down menu?
cell color
text alignment
cell borders
font
9
This picture shows...
how to start a new Spreadsheet (Google Sheet).
how to save a Google Sheet.
Did we learn this?????
how to rename a Google Sheet.
10
Sorting a range will not affect other content on the worksheet.
True
False
11
If you have too much cell content to be displayed in a single cell, you may...
unmerge cells
wrap text
modify a cell's row height
protect the cells
12
What would be the best type of graph to make for the data shown?
Map Chart
Line Chart
Pie Chart
Bar Chart
13
The name of a cell (for example, A1) is its cell ________.
content
heading
location
address
14
Which symbol is used to subtract in a spreadsheet?
-
;
+
"
15
What does
sort
do?
Organizes the selected data by number or letter
Organizes the data in all columns into alphabetical order.
Organizes all of the data from least to greatest.
Organizes the selected data by date it was typed.
16
Which symbol is used to multiply in a spreadsheet?
/
*
#
x
17
In the picture shown, what do each of the different colored dotted lines represent?
ranges
math operations
functions
selected cells
18
What else can you use spreadsheets for?
Making music
Editing photos
Creating charts
Writing a story
19
In the function shown,
SUM
is the____.
Argument
Function Name
Filter
Equation
20
Who Created Google?
Larry Page
Booby " Google" Jones
Bill Gates
Steve Jobs
21
A spreadsheet is a....
horizontal space going across
Verticle space that goes up and down
A digital sheet of paper
A grid made up of rows and columns
22
To move a range of data from one column to another you might use.
handle
drag and drop
23
Which of the following are recognized as mathematical operators in Google Sheets?
/
-
*
+
24
The fill ______ can be used to continue a
series
by guessing what should come next .
handle
drag and drop
25
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.
Copy and paste
26
How do you edit a chart in google sheets?
Double click on the data table
Select the chart and go on edit, then click "edit chart"
Double click on the chart
Delete it and try again
27
Min, Max Average and Sum are examples of _________ found in spreadsheets.
Math Terms
Math Words
Math Functions
Spell Checkers
28
Can you filter for more than one thing?
Yes
No
29
Spreadsheets are really good at
Using slides to present information
Writing and organizing text
Organizing numeric data
Digital animations
30
Which of the following features allows you to narrow down the data in your worksheet?
cells
functions
filters
data
31
Several spreadsheets make up a ?
workbook
mathbook
sheetbook
librarybook
32
Which microsoft is used to make spreadsheets
Microsoft Publisher
Microsoft Excel
Microsoft Word
Microsoft PowerPoint
33
A _______ is the intersection of a row and a column. (Hint: The box outlined in blue)
form
cell
coordinate
box
34
What can be modified with this drop-down menu?
font properties
text alignment
cell color
cell borders
35
Oops, need to add a row to the top of your sheet. What menu option should you use?
Insert-Row Above
Insert - Row Below
File-Save As
Edit-Delete Row
36
To move a range of data from one column to another you might use.
Delete and retype everything
command +x and command +V
Handle Copy
cut and paste
37
A function is like a math ______.
word problem
formula
operation sign
equal sign
38
A file which contains one or more spreadsheets.
Document
File Cabinet
Folder
Workbook
39
By ____, you are able to combine 2 or more cells into one larger cell
freezing rows or columns in place
merging rows or columns
Overlapping cells
Deleting Cells
40
What can be modified with this drop-down menu?
cell color
font
cell borders
text alignment
41
How do you
type the math equation 2+2 into a cell
?
Sum 2+2
copy and paste
2+2
=2+2
42
Google sheets calls a graph a
bar graph
pie
chart
graph
43
Is it important to follow the
order of operations
when creating a formula?
Yes, or Docs will not calculate the results correctly.
No, Sheets will automatically put it in order.
IDK?????
Yes, or Sheets will not calculate the results accurately.
44
In the function shown,
(B2:B8)
is the____.
Filter
Equation
Function Name
the Range
45
Which of the following is NOT recognized as a mathematical operator in Google Sheets?
\
%
_
*
46
Which function would you use to
add
the values of several cells?
MAX
AVERAGE
SUM
MIN
47
When you highlight multiple cells that is called a ______.
column
group
sort
range
48
What is a function?
predefined formula that performs calculations.
How the spreadsheet works
Sorts info using specific values in a particular order.
49
_______ allows you to customize the
look
of your spreadsheet, making it easier to understand.
Text
Margins
Functions
Formatting
50
Which function would you choose to display the largest value in a range of several cells?
MIN
SUM
AVERAGE
MAX
