stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Google sheets Flashcards | StudBud
Explore
/
Google sheets
Google sheets
50 terms
·
StudBud Administration
·
64 plays
Imported from external platform
Flashcards
50 cards
F
Practice quiz
P
Host live
L
Questions
50
Answers
1
What does this icon do in Google Sheets?
Uploads data
Re-colors a chart
displays chart types
inserts a chart
2
Which function would you use to add the values of several cells?
MAX
SUM
TOTAL
AVERAGE
3
What is this icon used for?
adding decimal places
taking away decimal places
Moving your zeros
changing direction
4
Merging Cells automatically centers the text within the merged cells.
True
False
5
Which item is FALSE regarding charts in Google Sheets
You can change the Chart Title
You can create pie and line charts
Charts cannot be inserted on their own sheet
You can put a background color on your chart
6
What is the purpose of the following formula SUM(B2:B6)?
To divide the values of cells B2 by B6
To subtract the values of cells B2:B6
To add the values of cells B2:B6
To multiply the values of cells B2:B6
7
In what menu can you find a copy of your formulas?
Charts
Format
View
Formulas
8
All formulas in a spreadsheet begin with the following symbol.
+
=
-
%
9
Select _____________from the functions menu to find the smallest number.
MIN
MAX
AVERAGE
SUM
10
In creating a chart for a spreadsheet, you should only select data or only select totals, but not both together.
False
True
11
You can have multiple sheets within the same Google Sheet document.
True
False
12
Select ________from the functions drop-down menu to add a set of numbers.
average
sum
count
max
13
Rows are labeled by
letters
numbers
colors
symbols
14
Merging cells automatically centers the text within the merged cells.
True
False
15
It is possible to change the color of a cell border.
False
True
16
What is the sign for dividing values in a cell?
/
+
-
*
17
What should you do to your spreadsheet before you insert a chart?
Resize the columns
Select the cells (data) for the chart.
Add a fill color to the spreadsheet
Include all the data on the spreadsheet for the chart
18
A group of cells is called a ___________
cell cluster
Multi-cell
cell range
chart
19
What number should be in E1 based on the formula =A1*B1?
6
Error
2
4
20
What does this icon represent on the Google sheets toolbar?
Charts
Merge
Add
Functions
21
Which menu in Google sheets will change the rotation of text in a cell?
Format
Data
Edit
View
22
this cursor allows you to copy the formula of that cell to adjacent cells.
Hand
Skinny Plus sign
Arrow
Fat Plus Sign
23
You cannot adjust a row height or column width.
False
True
24
Accordingto the order of operations, which calculation comes first in the following formula? =3^2/5=(12-3)
3^2
2/5
12-3
5+12
25
What is the skinny plus sign called.
Fill Tool
Copy Handle
Fill Handle
Formula Copy
26
It is possible to insert images in Google Sheets.
True
False
27
B1 is a
row address
column address
sheet address
cell address
28
The correct formula to add cell B1 and B2 is
=B1+B2
=sum(B1-B2)
AddB1+B2
=sum(B1+C1)
29
A cell's name is based on its column letter and row number. What do you call a cel name?
cell location
cell bar
cell select
cell address
30
What do you use this icon for in Google Sheets?
Merge Cells
Create Chart
Decrease Column size
Resize chart
31
Google Sheets is a program that allows a user to
browse sites on the internet
write letters
create electronic slide shows
calculate numerical information
32
Text wrapping in Sheets means the text will be on more than 1 line within the cell.
False
True
33
What value would you get if you put in the formula =B1 +C1?
2
3
4
ERROR
34
Conditional formatting allows you to change the color of specific cells ify they meet a certain criteria.
False
True
35
What is the name of a vertical section of a spreadsheet?
column
format
row
cell
36
What is this icon used for?
Arangement
Justify
Center Alignment
left align
37
What is this icon used for
changing the format of a cell to accounting
Putting lines through all of your S's
changing the format of a cell to numerical
Changing the format of a cell to currency.
38
Google sheets saves your changes automatically.
False
True
39
What is the sign for adding values in a cell?
+
/
-
*
40
Which of the following symbols are recognized as mathematical operators in Google sheets? SElect all that apply.
-
/
+
x
41
Double-clicking between two columns will __________the column
resize or expand
copy
delete
fill
42
What is this icon used for?
changing direction
taking away decimal places
adding decimal places
Moving your zeros
43
What is this icon used for?
merge and center
Adjusting the border style of selected cells.
adding a table
4 square
44
What is the sign for subtracting values in a cell?
/
*
+
-
45
What is the correct formulat to add A1 to A5?
=SUM(A1:A4)
=SUM(A1:A5)
=SUM(A1+A5)
=A1+A2+A3
46
What is the sign for multiplying values in a cell?
-
+
/
*
47
What is the name of a horizontal section of a spreadsheet?
cell
column
format
row
48
In Google sheets you can format a column by clicking on the $ sign to format it as ______
Currency
Automatic
Numbers
Decimals
49
Columns are labeled by
symbols
numbers
letters
colors
50
What is this icon used for?
Making text blue
maling text italicized
Making text bold
Inserting a capital B
