Font size
WorksheetsCourse Work 1 FORM 3 MSS
Total questions: 26
Worksheet time: 18mins
What is the purpose of spreadsheet software?
To type letters
for the manipulation of numeric data.
To prepare articles
Choose which of the following are true about columns in a spreadsheet. This question has more than one answer.
They run from left to right
They run up and down
They are identified by letters
They are identified by numbers
Choose which of the following are true about rows in a spreadsheet. This question has more than one answer.
They run from left to right
They run up and down
They are identified by letters
They are identified by numbers
Click on the image to enlargen it, then read and answer the following question. In the spreadsheet above which column would you find the surnames of the persons?
Column A
Column B
Column C
Click and enlargen the image then answer the following question. In the spreadsheet above which row contained the results shown for Tony Brotman?
Row A
Row 2
Row 5
Click on the image to enlargen, then answer the following question. In the spreadsheet shown which cell contains the results for March for Michael Bringson?
A1
A2
E4
Zia wants to save his spreadsheet file on a flash drive. Select the correct order of the steps he should take to complete this task.
STEP 2 Choose the location of the flash drive from the drop down window and name the file
STEP 1.Click Ok or Save
STEP 3. Click on File then Save as
STEPS: 3, 2, 1
STEPS: 1,2, 3
STEPS: 2, 3,1
Which of the following jobs may most likely use spreadsheets?
This question has more than one answer.
Teachers
scientists
Bankers
Grocery Managers
The intersection of a row and a column is called:
data
a cell
a field
an equation
Which of the following are other examples of spreadsheet software? This question contains more than one answer.
Microsoft Excel
Open Office Calc
Google Sheets
Apple Number
1. What is a computer spreadsheet package? Be careful, this question contains more than one answer.
an application package that enables you to carry out numerical work easily
a way of showing how numerical data items relate to each other
a piece of software designed to help you work with numbers
Click on the image to enlargen it, then answer the question below.
John is entering data in a spreadsheet. When he clicks on a cell its address, or cell name, appears in the circled area seen in the image. What is the name of this area?
(a)
Click on the image to enlargen it, then answer the question that follows. Josiah just opened a blank workbook and wants to rename the sheet. What is the area called, at the bottom of the spreadsheet, where he can rename his worksheet? ( Letter K in the diagram is pointing to the area)
(a)
Click on the image to enlargen it, then read and answer the question that follows. The diagram shows an area of the spreadsheet used to select different tabs. What are these tabs called in Spreadsheets?
(a)
Numbers in a spreadsheet are called (a) .
______________ are used to do calculations automatically.
Presentations
Columns
Rows
Formulae
Words that are entered in a spreadsheet, such as titles or headings are called (a) .
Type an equal sign = to begin a (a) .
Microsoft Excel is a commonly used .......................... program.
Rows
Spreadsheet
Scroll bars
Columns
The ......................... move the worksheet up, down, left and right.
Rows
Spreadsheet
Scroll bars
Columns
Click the picture to enlargen. What is the name of the bar that is circled in the picture?
Menu Bar
Standard Bar
Formula Bar
Title Bar
Which of the following is always used to begin a formula or function?
+
=
÷
>
Click on the image to enlargen. Which student's information is in row 3? Hint: Please type the name of the student.
(a)
Click on the image to enlargen. Which formula will most likely give the answer of Total Mark for Ben Thom?
B3+C3+D3+E3+F3
=B7+C7+D7+E7+F7
=SUM(D7:F7)
=SUM(B6:F6)
Click the image to enlargen. All the data entered in row 1 is considered ________________.
labels
values
formulae
A group of continuous cells that form a square or a rectangle is called a (a) .
