WorksheetsYear 5-Spreadsheets
Total questions: 15
Worksheet time: 9mins
The rectangular boxes in a spreadsheet is known as --------------
(a)
Columns are --------------
lettered
numbered
Rows are --------------
lettered
numbered
A formula begins with an EQUAL SIGN.
true
false
Identify the arithmetic operator by looking at the image
plus +
multiply *
minus -
________________________ are graphical representation of data in EXCEL.
conditional formatting
charts
cells
worksheet
Each sheet has a name displayed on a __________________ tab at the bottom of the worksheet.
sheet
chart
column
progress bar
Which of the following formulas show the correct use of the SUM function?
-SUM(H3-H10)
=SUM(H3:H10)
=SUM(H3...H10)
+SUM(H3:H10)
The intersection of a row and a column is called this.
Active Cell
Chart
Column
Row
The bar where information appears as you input data is called ______________.
file bar
help bar
window bar
formula bar
A cell's location is expressed by its column letter and row number such as A1.
name box
formula bar
cell address
What is an example of a RANGE in MS Excel.
B2-F5
F5:B2
B2:5F
(B2:F5)
What is the symbol for division when using MS EXCEL.
/
+
*
-
What is a multiplication formula for MS Excel using the picture ?
=1Ax1B
=B1*G1
=C3xD3
=B4*C4
__________ is composed of rows and columns.
Spreadsheet
Worksheet
Tracking Sheet
Transaction Sheet
