Basic Spreadsheet Concepts-Exercise 4 1. Type in all text and numbers shown in t

Question

Basic Spreadsheet Concepts-Exercise 4 1. Type in all text and numbers shown in the spreadsheet below. 2. Create formula to display a total for each item in the Furniture Store. 3. Create a formula to calculate the total sales for the Furniture Store. 4. Format all numbers with appropriate formats. 5. Center the spreadsheet heading "Mike's Furniture Store' across the spreadsheet. 6. Format all text as displayed in the sample below. 7. Apply all borders and shading (color) shown in the sample below, feel free to experiment with your own color schemes. Mike's Furniture Store em Lounge Dinning Bar Lazy Lamp Single Double Bedroom Scotch Cofee Suite Room Chair Boyd Bed Bed Dressers Dressers Table Chairs 12 15 3 January 4 February 2 5 921 10 5 March 7 May 9 July 8 6 185 4 15 12 812 16 211 8 15180 14 10 15 13 11 16 10 15 6 9 15 15 20 1 12 10 7 15 18 6 1418 11 12 15 18 23 26 13 15 15 11 10 152 715 21 19 20 1 10 10 12 78 9 8 5 155 11 September 1 12 October 13 November 14 15 8 14 15 13 14 18 4 13 13 12 16 24 30 24 18 30 16 12 1523To 20 16 216158 14 December 15 Totals

Explanation / Answer

The following spreadsheet is an example of how your spreadsheet should look, you can feel free to try different colour combinations.

The following spreadsheet shows the formulas you need to complete the spreadsheet.

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.