Spreadsheets: Year 7 Term 2B Assessment
star
star
star
star
star
Last updated about 1 month ago
31 questions
Note from the author:
A Year 7 Spreadsheet assessment for Year 7 UK Curriculum students in ICT
Complete all the questions and answers.
Once you have completed the assessment you should submit it
During the assessment you may not use the internet or Excel to look up answers, and you may not speak to another student.
You may not use the toilet until the assessment for every student is over.
Once you have submitted your assessment you must sit silently without speaking to anyone, you may read a book or complete homework/classwork
Required
3
Which of the following are examples of Spreadsheet software?
Which of the following are examples of Spreadsheet software?
Required
3
What are some common uses of spreadsheets? (Select all that apply.)
What are some common uses of spreadsheets? (Select all that apply.)
Required
1
What is the default file extension for an Excel spreadsheet?
What is the default file extension for an Excel spreadsheet?
Required
1
The Fill Handle is used to copy a formula down a column. (True/False)
The Fill Handle is used to copy a formula down a column. (True/False)
Required
1
What is the name of the area (in the red square) where you enter the data and work out the calculations.
What is the name of the area (in the red square) where you enter the data and work out the calculations.
Required
1
What is the name of the area where you control the spreadsheet
What is the name of the area where you control the spreadsheet
Required
1
What is the name of the area in the red box
What is the name of the area in the red box
Required
1
What is the name of the area in the red box
What is the name of the area in the red box
Required
1
What is the name of the area in the red box
What is the name of the area in the red box
Required
1
Which is the correct way to identify the coordinate marked by the red box
Which is the correct way to identify the coordinate marked by the red box
Required
1
All formulae start with the _______ symbol. (write in the symbol)
Required
1
The formula for adding together the following numbers to equal 15 is, _______ .
Required
1
True or False: The SUM function adds up a range of cells in Excel.
True or False: The SUM function adds up a range of cells in Excel.
Required
1
True or False: A cell reference is the address of a cell in Excel, and it consists of the column letter and row number.
True or False: A cell reference is the address of a cell in Excel, and it consists of the column letter and row number.
Required
1
True or False: The AVERAGE function in Excel gives the mean of a range of cells.
True or False: The AVERAGE function in Excel gives the mean of a range of cells.
Required
1
Which of the following best describes a 'range' (F7:K7)
Which of the following best describes a 'range' (F7:K7)
Required
1
The _______ symbol is used inside the brackets when writing cells in a range.
Choose one of the following and type it below ; / , | : ?
Required
1
The symbol used for the division operator is _______
Required
1
The symbol used for the multiplication operator is the _______
Required
1
Which of the following spreadsheet formulae is written incorrectly
Which of the following spreadsheet formulae is written incorrectly
Required
4
Write in the correct formulas/functions for working out the following - use the image below as reference:
Total: _______
Average: _______
Highest Number: _______
Lowest Number: _______
Required
1
Use the provided spreadsheet image to answer the following questions:What is the function used to calculate the sales amount in Cell D4?
Use the provided spreadsheet image to answer the following questions:
What is the function used to calculate the sales amount in Cell D4?
Required
1
Use the provided spreadsheet image to answer the following questions:What is the function used to calculate the "Total" of the "Total Cost" Column, in Cell D10?
Use the provided spreadsheet image to answer the following questions:
What is the function used to calculate the "Total" of the "Total Cost" Column, in Cell D10?
Required
1
"Complete the sentence below by filling in the missing word:
The best and most accurate way to sort the data in the image below would be to add a _______ to row 3."
(Options: sum, formula, filter, chart)
Required
1
What is the name of the Agent on the most expensive mission in London
What is the name of the Agent on the most expensive mission in London
Required
1
What type of mission was the least expensive?
What type of mission was the least expensive?
Required
1
Which of the following are valid mission types listed in the table? (Select all that apply.)
Which of the following are valid mission types listed in the table? (Select all that apply.)
Required
1
If you wanted to view only missions assigned to "Margaret Sánchez," which spreadsheet feature would be the best to use?
If you wanted to view only missions assigned to "Margaret Sánchez," which spreadsheet feature would be the best to use?
Required
1
If you wanted to arrange the missions in ascending order of cost, which column would you sort by?
If you wanted to arrange the missions in ascending order of cost, which column would you sort by?
Required
1
How many missions in the table were carried out in "New York"? Write the number only
How many missions in the table were carried out in "New York"? Write the number only
Required
1
Which agents completed "Code Breaking" missions? (Select all that apply.)
Which agents completed "Code Breaking" missions? (Select all that apply.)