Scribd
Upload
264 views2 pages

Clait Unit 4 Spreadsheets Exercise 8: Fruit

This document provides instructions for creating and formatting a spreadsheet to calculate department sales, totals, and profits. It involves entering sample sales data for different departments, adding formulas to calculate totals and profits, formatting numbers and cells, printing outputs, and making amendments to the data and calculations. The instructions are divided into 19 numbered steps to guide the process.

Uploaded by

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

Clait Unit 4 Spreadsheets Exercise 8: Fruit

This document provides instructions for creating and formatting a spreadsheet to calculate department sales, totals, and profits. It involves entering sample sales data for different departments, adding formulas to calculate totals and profits, formatting numbers and cells, printing outputs, and making amendments to the data and calculations. The instructions are divided into 19 numbered steps to guide the process.

Uploaded by

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

CLAIT

Unit 4 Spreadsheets

Exercise 8

1. Create a new spreadsheet.

2. Enter the following data, leaving the TOTAL column blank.

DEPT SALES

DEPT OVERHEADS MARK UP MON TUE WED TOTAL


FRUIT 6 0.17 44 68 22
VEG 4 0.15 55 88 21
FISH 10 0.12 52.5 16 28
CHILLED 7 0.1 12 72 14
DAIRY 6 0.13 65 32 43
DRINKS 2.5 0.25 19 31 41.5

3. Enter your name, college name and today’s date a few lines below the
data.

4. The TOTAL for each department is calculated by adding the figures


for MON, TUE and WED. Insert a formula to calculate the TOTAL for
FRUIT.

5. In the TOTAL column, replicate the formula in the FRUIT row to show
totals for all departments.

6. Save your spreadsheet report with the filename Dept Sales 1 and
print one copy. Make sure that all the data is displayed in full.

7. Print a copy showing the formula used. Make sure the formula is
displayed in full.

8. Insert a new column entitled PROFIT between the columns DEPT and
OVERHEADS.

9. PROFIT is calculated by multiplying the TOTAL figure by the MARK


UP and subtracting the OVERHEADS. Insert a formula to calculate
the PROFIT for FRUIT. Replicate this formula to show the PROFIT
for each department.

CLAIT Unit 4 1 of 2
431980697.doc
10. Delete the entire row for DAIRY.

11. Make the following amendments to the spreadsheet:

a. The MARK UP for FISH should be 0.10.

b. The OVERHEADS for VEG should be 2.5.

c. The WED sales for VEG should be 36.

d. CHILLED should be FROZEN.

Make sure the TOTAL and PROFIT have updated as a result of these
changes.

12. Save the spreadsheet as Dept Sales 2.

13. Print one copy showing the data and one copy showing the formulae
used. Ensure all data and formulae are showing in full on the
printouts.

14. Apply alignment as follows:

a. The column heading DEPT SALES and all row labels should be
left-aligned.

b. The other column headings should be right-aligned.

c. All numeric values should be right-aligned.

15. Format the data as follows:

a. The figures for MON, TUE and WED should be displayed in integer
format.

b. The figures for OVERHEADS, MARK UP and TOTAL should be


displayed to two decimal places.

c. The PROFIT data only should be displayed with a £ sign and to


two decimal places.

16. Save the spreadsheet using the filename Dept Sales 3.

17. Print one copy showing figures, not formulae. Make sure that all data
is displayed in full.

18. Print the spreadsheet with all the formulae showing. Make sure that
all formulae are displayed in full.

19. Close the spreadsheet.


CLAIT Unit 4 2 of 2
431980697.doc

You might also like