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.
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?
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
All formulae start with the
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 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)
The
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
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
(Options: sum, formula, filter, chart)
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 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.)