KEMBAR78
Spreadsheet Assignment | PDF
Scribd
Upload
22 views2 pages

Spreadsheet Assignment

The document outlines a spreadsheet assignment involving cell referencing and chart creation. It explains the use of absolute referencing in a formula to ensure consistent division by a specific cell when copied. Additionally, it specifies the data ranges for creating a pie chart and provides functions for calculating the average and maximum of specified data ranges.

Uploaded by

Oumotia
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
22 views2 pages

Spreadsheet Assignment

The document outlines a spreadsheet assignment involving cell referencing and chart creation. It explains the use of absolute referencing in a formula to ensure consistent division by a specific cell when copied. Additionally, it specifies the data ranges for creating a pie chart and provides functions for calculating the average and maximum of specified data ranges.

Uploaded by

Oumotia
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

SPREADSHEET ASSIGNMENT

A. The formula = F3/ $F$9 was entered in cell G3


(i) What type of cell referencing was used $F$9 Answer = Absolute referencing
(ii) Explain why this type of cell referencing was used – Absolute Referencing is used so
that when the formula is copied down column (example G4, G5) the cell referencing
$F$9 does not change. This ensures that each formula always divides by the total
number of workers (116,300) in cell F9
B. A pie chart is to be created. Each Sector slice of the pie Chart will represent the total
number of workers in ten various age group and also indicate the name of the age
group.
State the data range and the category labels range to be used to create the pie chart.
Date Range: F3:F8 (Total number of workers for each sector)
Category labels Range: A3:A8 (Names of the sectors)

C. Write the function to find the following


(i) The average of the sector totals
Sector totals are in F3 to F8, so answer = AVERAGE (F3:F8)
(ii) The Maximum of the age group totals
Age group totals are in B9 to E9, so Answer = Max (B9:E9)

You might also like