Spreadsheets: Year 7 Term 2B Assessment

Instructions

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

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)

Required

1

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

Required

1

What is the name of the area in the red box

Required

1

What is the name of the area in the red box

Required

1

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

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.

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.

Required

1

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)

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

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?

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?

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

Required

1

What type of mission was the least expensive?

Required

1

Required

1

Required

1

Required

1

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

Required

1

Spreadsheets: Year 7 Term 2B Assessment

What is the default file extension for an Excel spreadsheet?

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

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 where you control the spreadsheet

What is the name of the area in the red box

What is the name of the area in the red box

What is the name of the area in the red box

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

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

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: The AVERAGE function in Excel gives the mean of a range of cells.

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

Which of the following spreadsheet formulae is written incorrectly

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 "Total" of the "Total Cost" Column, in Cell D10?

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

What type of mission was the least expensive?

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

Which of the following are examples of Spreadsheet software?

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

What is the default file extension for an Excel spreadsheet?

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

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 where you control the spreadsheet

What is the name of the area in the red box

What is the name of the area in the red box

What is the name of the area in the red box

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

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

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: The AVERAGE function in Excel gives the mean of a range of cells.

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

Which of the following spreadsheet formulae is written incorrectly

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 "Total" of the "Total Cost" Column, in Cell D10?

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

What type of mission was the least expensive?

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

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 arrange the missions in ascending order of cost, which column would you sort by?

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

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

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 arrange the missions in ascending order of cost, which column would you sort by?

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

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 "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 sales amount in Cell D4?

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?