NEW
Font size
WorksheetsGoogle Sheets
Total questions: 50
Worksheet time: 25mins
You can only adjust the size of columns. The size of rows cannot be adjusted.
True
False
The position of the legend will always appear to the right of of the chart.
True
False
When you change the data in the spreadsheet, the chart automatically updates?
True
False
Conditional formatted only appears under certain circumstances.
True
False
A template already has some calculations done for you.
True
False
It is possible to only paste a value when a formula is copied.
True
False
Narrow margins leave you more white space between the text and edge of the page.
True
False
The "Edit" tab/menu allows you to add a chart to your worksheet.
True
False
The "viewer" permission allows you the same access as the owner of the worksheet?
True
False
The following formula uses cell referencing.
=12.5*7
True
False
What type of border is this table using?
all cells
outside borders
bottom boarder
right border
A ______________ is being used in the following calculation. =Max(B2:B7)
cell
range
complex formula
label
What is the following button?
borders
merge
shading
font
What is the following button?
borders
merge
shading
font
What tab/menu would you go to in order to add a header or footer in Google Sheets?
file
edit
view
insert
The following picture is a _____________.
fill handle
copy cross
format painter
addition sign
What type of cell referencing is being used:
=SUM(B9:E9)
relative
absolute
mixed
Which of the following does NOT help you read a graph?
gridlines
axis titles
chart title
data in the spreadsheet
What does the following button allow you to do?
format text
format data
change labels
transpose data
What is the following button?
explore button
new sheet button
all sheets button
comment button
Google Sheets refers to the picture below as a __________________.
legend
key
map
diagram
The first step to adding a chart is __________________.
right click
go to the insert tab
select data
change the title of the chart
What is the first step to inserting a row.
select a row
right click
click insert
double click
When you add text to a chart to point out what you would like the recipient to notice, you are ______________ the chart.
editing
formatting
annotating
analyzing
When scrolling through a spreadsheet, you would like the first two rows to remain visible. What should you do?
merge the rows 1-2
freeze the rows 1-2
freeze all the other rows
merge all other rows
When changing the background color of a chart, you should be cautious of:
The font style of the titles and labels
The font color of the titles and labels
The font size of the titles and labels
The formatting of the titles and labels
What is the following button?
borders
merge
shading
font
What is the most important thing to consider when making changes to a template.
changing the color scheme
editing cells with a formula
replacing labels
naming the template
Which type of chart is best used to each categories part relative to the whole chart?
column
bar
line
pie
How would you open up the options to edit your chart?
double click the chart
press ctrl and click you chart
press shift and click you chart
click and drag your chart
Which type of chart is best used to compare several items in a specific value range?
column
bar
line
pie
The way text looks can also be called ____________.
font
text spacing
form
borders
What should you do if you want to keep a row visible?
freeze it
merge cells
scroll
make it permanent
When text appears in the middle of a cell, it is _____________.
centered
italicized
left aligned
underlined
How many decimal places is the following command rounding to? =Round(B5*C7,0)
5
7
0
1
What is the following button?
borders
merge
shading
font
What type of orientation is shown.
portrait
landscape
A pre-designed worksheet is called a _______________.
spreadsheet
workbook
template
formatted worksheet
Worksheets are found in a _____________.
spreadsheets
workbooks
templates
websites
What type of cell referencing is being used?
=(F7*$H$2)+F7
relative
absolute
mixed
none
What is the shortcut to copy?
ctrl+c
ctrl+v
ctrl+p
ctrl+x
What is the shortcut to paste?
ctrl+c
ctrl+v
ctrl+p
ctrl+x
Which type of cell referencing changes based on location?
relative
absolute
none
The following button would help you:
insert a formula
insert a comment
insert a chart
sort data
The following button would help you:
insert a formula
insert a comment
insert a chart
sort data
What is the correct way to multiply these numbers using excel?
=12.50*6
=A2*B2
=A2*6
=12.50*B2
Why are charts useful?
help identify relationships between data
helps transpose data
to do calculations
for editing purposes
Gridlines are useful for ______________.
estimating values on a graph
labeling axis on a graph
adding a title to a graph
moving a graph
Name the active cell.
A1
B6
C10
B10
Why is it important to use cell referencing?
to keep data organized
to recalculate data that has been changed
to create a chart
to compare numbers
