Log in
Sign up for FREE
arrow_back
Library

Spreadsheets: Year 7 Term 2B Assessment

star
star
star
star
star
Last updated 4 months 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
Required
3
Required
1
Required
1
Required
1
Required
1
Required
1
Required
1
Required
1
Required
1
Required
1
Required
1
Required
1
Required
1
Required
1
Required
1
Required
1
Required
1
Required
1
Required
1
Required
4
Required
1
Required
1
Required
1
Question 1
1.

Which of the following are examples of Spreadsheet software?

Question 2
2.

What are some common uses of spreadsheets? (Select all that apply.)

Question 3
3.

What is the default file extension for an Excel spreadsheet?

Question 4
4.

The Fill Handle is used to copy a formula down a column. (True/False)

Question 5
5.

What is the name of the area (in the red square) where you enter the data and work out the calculations.

Question 6
6.

What is the name of the area where you control the spreadsheet

Question 7
7.

What is the name of the area in the red box

Question 8
8.

What is the name of the area in the red box

Question 9
9.

What is the name of the area in the red box

Question 10
10.

Which is the correct way to identify the coordinate marked by the red box

Question 11
11.
All formulae start with the _______ symbol. (write in the symbol)
Question 12
12.
The formula for adding together the following numbers to equal 15 is, _______ .

Question 13
13.

True or False: The SUM function adds up a range of cells in Excel.

Question 14
14.

True or False: A cell reference is the address of a cell in Excel, and it consists of the column letter and row number.

Question 15
15.

True or False: The AVERAGE function in Excel gives the mean of a range of cells.

Question 16
16.

Which of the following best describes a 'range' (F7:K7)

Question 17
17.
The _______ symbol is used inside the brackets when writing cells in a range.
Choose one of the following and type it below ; / , | : ?
Question 18
18.
The symbol used for the division operator is _______
Question 19
19.
The symbol used for the multiplication operator is the _______
Question 20
20.

Which of the following spreadsheet formulae is written incorrectly

Question 21
21.
Write in the correct formulas/functions for working out the following - use the image below as reference:
Total: _______
Average: _______
Highest Number: _______
Lowest Number: _______

Question 22
22.

Use the provided spreadsheet image to answer the following questions:
What is the function used to calculate the sales amount in Cell D4?

Question 23
23.

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?

Question 24
24.
"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
Question 25
25.

What is the name of the Agent on the most expensive mission in London

Required
1
Question 26
26.

What type of mission was the least expensive?

Required
1
Required
1
Required
1
Required
1
Question 30
30.

How many missions in the table were carried out in "New York"? Write the number only

Required
1
Question 27
27.

Which of the following are valid mission types listed in the table? (Select all that apply.)

Question 28
28.

If you wanted to view only missions assigned to "Margaret Sánchez," which spreadsheet feature would be the best to use?

Question 29
29.

If you wanted to arrange the missions in ascending order of cost, which column would you sort by?

Question 31
31.

Which agents completed "Code Breaking" missions? (Select all that apply.)