NEW
Font size
WorksheetsDiagnostic Test on Spreadsheets
Total questions: 10
Worksheet time: 5mins
A spreadsheet is mainly used to:
Write long essays
Organize and analyze numerical data
Design posters and flyers
Create animations
Which of the following is a spreadsheet software?
MS Word
MS PowerPoint
MS Excel
Photoshop
The vertical set of cells in a spreadsheet is called a:
Row
Column
Range
Function
A group of cells identified as A1:B5 is called a:
Formula
Cell address
Range
Function
Which symbol is used at the beginning of every formula in Excel?
#
@
=
+
A worksheet is best described as:
A single page within a workbook
A collection of different files
A printed table of data
A formula used in Excel
In a spreadsheet, a label is usually:
Text used to describe data
A number that can be calculated
A type of formula
A chart
Which of the following is a real-world example of using spreadsheets in a school?
Writing essays in English class
Recording student grades
Drawing diagrams in Art class
Playing music in Music class
What is one advantage of using a spreadsheet instead of a notebook to store data?
It is harder to edit information
Data can be calculated automatically
It takes more time to update records
It cannot create charts
In the table below, what is the cell address of Sarah’s IT score (90)?
C2
D2
B2
A2
