NEW
Font size
Worksheetsgrade 7- spreadsheet model- review-week 25,26
Total questions: 24
Worksheet time: 18mins
Identify the spreadsheet program.
Word
Microtype
Notepad
Excel
A worksheet in EXCEL contains data in cells. A cell is the intersection of a column and a row.
True
False
This is formed where a column and a row cross.
Cell
Worksheet
Something Else
Choose the correct statement.
Columns are identified by letters that run horizontally (up & down) & rows are identified by numbers that run vertically.
Rows are identified by letters that run horizontally (up & down) & columns are identified by numbers that run vertically.
These are equations that perform calculations in a worksheet.
Cells
Charts
Formulas
This is a graphical representation of data in a worksheet.
Cell
Chart
Formula
Which formula was used in column I to add up the numbers in column I?
SUM
AVERAGE
MINIMUM
MAXIMUM
Which formula was used on row 14 to calculate the numbers 3.8, 1.9, 2.3, 4.1, 1.6, & 3.15?
SUM
AVERAGE
MINIMUM
MAXIMUM
What type of chart is in the picture?
Line
Pie
Bar
What type of chart is in the picture?
Line
Pie
Bar
What type of chart is in the picture?
Line
Pie
Bar
Data in a worksheet can be sorted.
If names are sorted in ascending order, this means that the names will be sorted this way...
A to Z
Z to A
To insert a chart on a worksheet, the user must first do this...
Select the data which will be in the chart, select Insert & then just choose the chart you want.
Nothing. Just select Insert & then just choose the chart you want.
How is the data arranged below?
100, 90, 80, 70, 60, 50
Ascending Order
Descending Order
When a person creates a chart in EXCEL, the data in the chart can appear in different colors.
True
False
When we write formulas, which sign do we start with?
Subtraction sign
Equal Sign
Addition sign
Division sign
How are we sorting the data in this clip?
