4d Worksheets, workbooks, ranges ***

Question 0

Give an example of the use of a range and a row in the spreadsheet used to simulate the relocation of the company.

Answer 0

1 mark for an example of each e.g:
Range used in function to add moving costs /used to create graph of lost
orders for each day (1)
Row: list of moving costs/titles for costs (1)

Question 1

The company uses a spreadsheet to store its accounts.
Describe the terms worksheets, cells and ranges and give an example of how each would be used in the accounts spreadsheet.

Answer 1

2 marks for each, description for 1 mark, example of use for 2nd:

Worksheets
Collection of sheets/holds data on similar topics (1) Collection of cells/rows and columns (1)
Example: different months put into separate worksheets – collection is the year (1)

Cells
Individual box/contains text, number, formula, function/intersection of row and column (1) Example: holds name of month (1)

Ranges
Collection of cells (1)
Example: All expenditure for a month (1)

Question 2

Using examples related to the landscape gardening business, describe how Miss Jones could make use of workbooks and ranges.

Answer 2

2 marks for each eg:

Workbooks:
Hold information on different months accounts (1) one on month on a
worksheet, all together in a workbook (1)

Range:
Add income (1) from all months (1)
Select data for a graph (1) showing income over time (1).