[go: up one dir, main page]
Scribd
Upload
6 views1 page

INSTRUCTION: Go To The Wikisite, Select Grade 8 and Scroll To The Bottom of The Page and Download The Spreadsheet doc:"GRADED CLASSWORK"

Uploaded by

duhnees

This document provides instructions for editing a spreadsheet document with sales data. It instructs the user to insert rows and labels, calculate totals for branches and months, format cells as currency, use functions to count and average values, and fill cells with color. The edited spreadsheet should then be saved and emailed to the provided department email address, with the assigned name and subject line.

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt

INSTRUCTION: Go To The Wikisite, Select Grade 8 and Scroll To The Bottom of The Page and Download The Spreadsheet doc:"GRADED CLASSWORK"

Uploaded by

duhnees
6 views1 page
This document provides instructions for editing a spreadsheet document with sales data. It instructs the user to insert rows and labels, calculate totals for branches and months, format cells as currency, use functions to count and average values, and fill cells with color. The edited spreadsheet should then be saved and emailed to the provided department email address, with the assigned name and subject line.

Original Description:

excel

Original Title

Bonus Ass2

Copyright

© © All Rights Reserved

Available Formats

DOCX, PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

This document provides instructions for editing a spreadsheet document with sales data. It instructs the user to insert rows and labels, calculate totals for branches and months, format cells as currency, use functions to count and average values, and fill cells with color. The edited spreadsheet should then be saved and emailed to the provided department email address, with the assigned name and subject line.

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
6 views1 page

INSTRUCTION: Go To The Wikisite, Select Grade 8 and Scroll To The Bottom of The Page and Download The Spreadsheet doc:"GRADED CLASSWORK"

Uploaded by

duhnees
This document provides instructions for editing a spreadsheet document with sales data. It instructs the user to insert rows and labels, calculate totals for branches and months, format cells as currency, use functions to count and average values, and fill cells with color. The edited spreadsheet should then be saved and emailed to the provided department email address, with the assigned name and subject line.

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
You are on page 1/ 1

INSTRUCTION: Go to the wikisite, select grade 8 and scroll to the bottom of the page and

download the spreadsheet doc:GRADED CLASSWORK


1. Insert a row between row 1 and row 2 and insert the label First Quarter Sales. (2 marks)
2. Insert the label Total in cell E3. (1 mark)
3. Find the total sales for each branch for each month. (3 marks)
4. Find the corporate total for each month for all branches. (3 marks)
5. Centres align the labels January, February and March. (1 mark)
6. Format the range B4:E8 as currency. (2 marks).
7. Use the appropriate functions to determine the Count for column C and the Average for in
column E. (2 marks)
8. Fill column A range of data with the colour blue (1 mark)
NB: Save the spreadsheet as HOME MAKERS (YOURNAME). Send the document to the
department email address: sahsitdept@gmail.com, subject: Classwork Ms.Hall

END OF CLASSWORK

(35 MARKS)
GOODLUCK!

You might also like