NEW
Font size
WorksheetsSpreadsheets/Charts
Total questions: 19
Worksheet time: 10mins
Which programs are used to calculate spreadsheets?
Microsoft publisher & Google templates
Microsoft excel & Google sheets
Microsoft powerpoint & Google slides
Microsoft word & Office 365
What symbol does a formula have to start with in order for it to work?
#
$
=
@
Which is NOT a type of chart?
pie
column
bar
axis
What does autosum do?
subtracts totals
adds totals
multiplies totals
divides totals
What are the Letters in a spreadsheet called?
rows
alphabets
numbers
columns
Which chart would I use to show how Team Teachers beat Team Students in the bowling tournament?
column
xy scatter
pie
line
Which type of chart would you create to compare groups of data?
pie
line
bar
column
Why are charts/graphs used in spreadsheets?
to show a visual of the data in a spreadsheet
to make the spreadsheet look cool
to backup the data you input into the spreadsheet
all of these are reasons
Which is NOT a formula?
b2+b3+b4
=b1+b2+b3
=b4*c4
=b5/b7
Which icon represents currency?
*
&
$
@
What is the first thing you have to do in a spreadsheet before you can create a chart/graph?
click insert charts/graphs
go to file, print
highlight the data with your mouse
bold all the information
Which chart would you use to show trends or changes over time?
stacked bar chart
pie chart
bar chart
line chart
A pie chart is used to do what?
show trends over time
represent only one series of data
show the correlation of two or more sets of data
show how many pieces you can eat
Is a column vertical or horizontal?
vertical
horizontal
Which is NOT an alignment icon?
center
align left
align right
tab
The x axis is the same as the
horizontal axis
vertical axis
Chart titles should be
to the left of the chart
to the right of the chart
centered over the chart
at the bottom of the chart
What does a chart's legend show
data points in the chart
the title of the chart
the x axis
the y axis
What is the next step after highlighting your data in the spreadsheet?
choose chart editor
insert chart
customize your chart
click file, insert
