NEW
Font size
WorksheetsYear 5 Excel Assessment
Total questions: 17
Worksheet time: 8mins
Excel is what type of program
Spreadsheet
Word Processor
Search Engine
Database
What is the icon for Excel
What do all formulas start with?
=
( )
/
sum
What is missing from this formula?
=sum a1+a2
=
/
( )
How do we locate a cell in a spreadsheet?
based on guessing
based on coordinates
What is written in cell D4
Supplies
Number
Central
Pencil
What is the symbol for division in Excel?
/
*
+
-
What is the command to find the Average of a column of numbers?
Max
Average
Min
Count
What is the symbol for multiplication in Excel?
/
+
*
=
What is the command to find the largest number in a column of data?
Max
Min
Count
Countin
What are the cells that go across called?
Across
Column
Row
Sheet
What is it called when cells go from from top to bottom?
columns
rows
sides
top
What do I click to create a chart?
INSERT
DATA
VIEW
Formulas
What will clicking on the icon in the image do?
Make the text size bigger
Make the text colour red
Make the cell background colour red
Underline the text
What will clicking on the icon in the image do?
Make the text size bigger
Make the text colour red
Make the cell background colour red
Underline the text
Which format is best suited to display the price of an item?
Percentage
Number
General
Currency
