Scribd
Upload
96 views1 page

Clait Unit 4 Spreadsheets Exercise 1: Costs June July August

This document provides instructions for creating an Excel spreadsheet to track school expenses. It instructs the user to enter a school name and year, title the spreadsheet "EXPENSES", add column headings for costs, months, and totals. It then has the user input labels and values for allowance, food, travel costs and totals for each month, as well as a formula to calculate total expenses. Finally, it instructs the user to add a header with their name and date and save and print the spreadsheet.

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
96 views1 page

Clait Unit 4 Spreadsheets Exercise 1: Costs June July August

This document provides instructions for creating an Excel spreadsheet to track school expenses. It instructs the user to enter a school name and year, title the spreadsheet "EXPENSES", add column headings for costs, months, and totals. It then has the user input labels and values for allowance, food, travel costs and totals for each month, as well as a formula to calculate total expenses. Finally, it instructs the user to add a header with their name and date and save and print the spreadsheet.

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/ 1

CLAIT

Unit 4 Spreadsheets

Exercise 1

1. Load Excel.
2. ENTER THE SCHOOL NAME, ADRRESS AND SCHOOL YEAR

3. Enter the title EXPENSES in cell A5.

4. On the row below the title enter the column headings:


Costs June July August

5. Under the column heading Costs enter the following row labels:

Allowance Food travel Totals

6. Enter the following numeric data:

Costs June July August


Allowance

Food

Travel

Totals

7. Enter a formula in the Totals row to calculate the Total expenses for
January.

8. Insert a header with your name centred and today’s date right aligned.

9. Save your spreadsheet as Expenses1.

10. Print one copy.

11. Print a copy displaying the formulae used.

CLAIT Unit 4 1 of 1
Exercise 4.1

You might also like