NEW
Font size
WorksheetsS2 - Spreadsheets
Total questions: 28
Worksheet time: 14mins
What is the name of the spreadsheet package we have been using?
Google Slides
Microsoft Word
Microsoft Excel
Microsoft Access
What is the term used for each box in a spreadsheet?
Cell
Box
Field
Record
What is the term used for cells which appear going across the spreadsheet?
Column
Record
Field
Row
What is the term used for cells which appear going up and down the spreadsheet?
Field
Row
Column
Record
A cell can contain text, values and what else?
Currency
Percentages
Formulae
Dates
What symbol is used to multiply?
/
-
+
*
What symbol is used to divide?
*
+
/
-
How must a cell containing a formula start?
SUM
=
+
( )
What function is used to add more than 2 cells?
+
=
SUM
( )
What term describes how a formula can be inserted into adjacent cells without keying it in again?
Copy
Paste
Replication
Insert
Which of the following will add 2 cells together?
A1+B1
=A1+B1
=A1-B1
If we wanted to add more than 2 cells together what formula should we use?
=A1+B1+C1+D1+E1+F1
=SUM(A1:F1)
What formula would you use to find out the highest number within a range of cells?
Max
Min
High
We can merge cells together when using excel
True
False
Columns are identified using _______?
Numbers
Letters
Numbers & Letters
Cells
Rows are identified using ________?
Numbers
Letters
Numbers & Letters
Cells
In what format should a cell with a money value entered into be in?
Currency
Text
Numbers
Formulas and functions must always start with which symbol?
Brackets
Add
Equals
Which of the following tasks would a spreadsheet be best used for?
Present information about a new television channel
Manage the details of members at a gym
Keep track of money raised at a charity event
How is the information in spreadsheets laid out?
In a circle
In a spider diagram
In rows and columns
What is the main function of a spreadsheet?
To organise information and automatically make calculations from the data in the cells
To spread data over a large surface area
To make data transparent so that the user can see the binary code
Which of the following is a valid function?
=sum(A1:A6)
sum=(A1:A6)
=sum[A1:A6]
=sum(A1,A6)
Which career(s) or places of employment involve the use of a spreadsheet at work?
Accountant
Hospital
All Choices
Shop Keeper
If we wanted to add more than 2 cells together what formula should we use?
=A1+B1+C1+D1+E1+F1
=SUM(A1:F1)
What is the main function of a spreadsheet?
To organise information and automatically make calculations from the data in the cells
To spread data over a large surface area
To make data transparent so that the user can see the binary code
Which is the correct formula to divide?
B6/C6
=B6/C6
/B6C6
B6C6/
