Scribd
Upload
40 views2 pages

Academic Year 2020-2021: Dollars To 2 Decimal Places

The document provides instructions for creating a spreadsheet to track costs and revenue from horse riding trips over four quarters of a year. It includes steps to format cells, enter functions to calculate values like totals and averages, and update the spreadsheet with additional data.

Uploaded by

Angeline Anggito
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
40 views2 pages

Academic Year 2020-2021: Dollars To 2 Decimal Places

The document provides instructions for creating a spreadsheet to track costs and revenue from horse riding trips over four quarters of a year. It includes steps to format cells, enter functions to calculate values like totals and averages, and update the spreadsheet with additional data.

Uploaded by

Angeline Anggito
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Academic Year 2020-2021

Name: Angie Score

Level: Sec 1 Date: 1/20/2021

Subject: ICT Topic: Data Analysis

Instructions:

You are going to prepare a spreadsheet for Back Horse Riding. You will use the spreadsheet
to create a chart and calculate the costs of horse riding trips. Display all currency values in
dollars to 2 decimal places.
1 Using a suitable software package, load the file BHRSHEET.CSV

Save this file with your Name and Class


Insert a new row above row 1.
[1]
2 In cell A1 enter the title Back Horse Riding Trips 2017–18

[2]
3 Merge cells:
 B2 to E2
 F2 to I2
 J2 to M2
 N2 to Q2
Format these cells so that:
 text is centre aligned with a black, 18 point, sans-serif font
 each has a grey background colour and a thin black border.
[5]

4 Format cells A2 and R2 so that they appear the same as those formatted in step 3.
[2]

5In cell E4 use a function to calculate the number of trips in April, May and June.
[1]
6 In cell E5 use a function to calculate the total income from April, May and June.
[1]
7 In cell E6 use a function to calculate the total expenditure from April, May and June.
[1]
8 Replicate the formulae entered in steps 5, 6 and 7 to calculate and display the data
for
quarters 2, 3 and 4.
[1]
9 Calculate the profit for each month and each quarter. [Profit = Income – Expenditure]
[2]
10 Calculate the total number of trips, income, expenditure and profit for the year.
[2]
11 On the left in the footer add your Name and Class.
[1]
14 In cell B11 use a function to display the average monthly profit.
[1]
15 Apply appropriate formatting to all cells except row 2.
[3]
16 Save and print the spreadsheet showing formulae. Make sure:
 it is in landscape orientation
 the row and column headings are displayed
 the contents of all cells are fully visible.
[3]
17 Update the spreadsheet with the following data for December:
 The income was $45 000
 The expenditure was $42 000
[2]
18 Print the spreadsheet showing the values. Make sure:
 the printout fits on a single page
 the contents of all cells are fully visible.
[2]

You might also like