Spreadsheets: Year 7 Term 2B Assessment

Last updated 6 months ago

31 questions

Note from the author:

Instructions

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

Library

Spreadsheets: Year 7 Term 2B Assessment

Last updated 6 months ago

31 questions

Note from the author:

A Year 7 Spreadsheet assessment for Year 7 UK Curriculum students in ICT

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

Required

1

Required

1

Required

1

Required

1

Required

1

Required

1

Required

1

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

Required

1

Required

1

Required

1

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

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

Required

1

Required

1

Required

1

Required

1

Required

1

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

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?

.txt

.xlsx

.docx

.pptx

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

True

False

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

workplace

worksheet

column

cell

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

toolkit

control strip

toolbar

control kit

What is the name of the area in the red box

longitude bar

column

cell

row

What is the name of the area in the red box

cell

row

lateral bar

column

What is the name of the area in the red box

row

column

cell

box

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

C4

4C

All formulae start with the _______ symbol. (write in the symbol)

The formula for adding together the following numbers to equal 15 is, _______ .

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

True

False

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

False

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

True

False

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

the first cell reference in a formula

a collection of selected cells.

the amount of data you can enter into a row

the amount of data you can enter into a column

The _______ symbol is used inside the brackets when writing cells in a range.
Choose one of the following and type it below   ;   /  ,  |  :  ?

The symbol used for the division operator is _______ 

The symbol used for the multiplication operator is the _______ 

Which of the following spreadsheet formulae is written incorrectly

F2+F3+H4+H5=

=(A3*A4)/3

=A1-A2

=MAX(G6:L6)

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

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?

"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

Which of the following are examples of Spreadsheet software?

PowerPoint

Excel

Numbers

Forms

Word

Notebook

Sheets

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

Accessing email

Data analysis

Writing code / Programming software

Performing calculations

Writing novels

Creating charts

What is the default file extension for an Excel spreadsheet?

.txt

.xlsx

.docx

.pptx

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

True

False

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

workplace

worksheet

column

cell

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

toolkit

control strip

toolbar

control kit

What is the name of the area in the red box

longitude bar

column

cell

row

What is the name of the area in the red box

cell

row

lateral bar

column

What is the name of the area in the red box

row

column

cell

box

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

C4

4C

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

True

False

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

False

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

True

False

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

the first cell reference in a formula

a collection of selected cells.

the amount of data you can enter into a row

the amount of data you can enter into a column

Which of the following spreadsheet formulae is written incorrectly

F2+F3+H4+H5=

=(A3*A4)/3

=A1-A2

=MAX(G6:L6)

What type of mission was the least expensive?

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

Code Breaking

Theft

Espionage

Surveillance

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

SUM function

Sorting

Filtering

Conditional Formatting

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

Location

Mission Type

Agent

Cost

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

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

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

Code Breaking

Theft

Espionage

Surveillance

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

SUM function

Sorting

Filtering

Conditional Formatting

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

Location

Mission Type

Agent

Cost

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

Ella Sanders

Elizabeth Smith

Margaret Sánchez

Jennifer Hall

Daniel Evans

James Black

Spreadsheets: Year 7 Term 2B Assessment

Spreadsheets: Year 7 Term 2B Assessment

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

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?

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

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 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?