Spreadsheet Exam Questions - Bangor Grammar School



Spreadsheet Exam Questions

1. A spreadsheet is being designed to contain data about a tuck shop.

The data to be stored is the item name, cost price, selling price, profit and number sold for each item. Profit = Selling price – Cost price. The Total profit per item = Profit x Number Sold.

[pic]

(a) Write down one cell apart from those in row 1 which would store text.

     

(b) Write down one cell where the data would be numeric.

     

(c) Write down one cell which would contain a formula.

     

(d) Write down a formula to work out the total profit per item.

     

[4]

2. A Biology teacher uses a spreadsheet to record the test scores of his pupils. The spreadsheet below shows the test scores of some of those pupils.

[pic]

(a) Write down the formula which should go in cell E2.

     

[1]

(b) Write down the formula which should go in cell B6.

     

[1]

3. The table shows part of a spreadsheet file.

[pic]

(a) Write down the cell reference of one cell containing numeric data.

     

[1]

(b) State one cell reference that should include a formula and then write down this formula.

Cell reference:      

Formula:      

[2]

(c) How many rows are shown in the spreadsheet?

     

[1]

(d) Give a cell reference for a cell that should be formatted as currency.

     

[1]

(e) Give the cell reference that contains 124.

     

[1]

4. A deputy head in a school keeps a spreadsheet of pupil data on his laptop showing the progress of pupils in the three main subjects.

Below is a table which shows part of this spreadsheet.

[pic]

(a) Name the column which this spreadsheet has been sorted on.

     

[1]

(b) Write down the formula which is in cell G4.

     

[1]

(c) If all the data were now sorted on column G, in ascending order, write down the name of the student who would be at the top of the list.

     

[1]

(e) The deputy head wanted to compare the average exam score of the three subjects so he produced the following graph using the spreadsheet software. Describe the steps he had to go through to produce it.

[pic]

     .

[5]

5. Name three features of spreadsheets, other than being able to deal with text and numbers.

These features could refer to cell contents or to the spreadsheet structure.

1      .

2      .

3      .

[3]

6. A school has just received its IGCSE examination results which are better than the previous year. The results for the last three years are stored in this spreadsheet.

[pic]

Explain how the head teacher will present these figures in the form of a graph.

     .

[3]

7. One of the features which make spreadsheets suitable for this is the ability to handle both text and numbers. Name three other features which make them suitable for this purpose.

1      .

2      .

3      .

[3]

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download