Exercise 6: Computing Supplies and Invoice

 

Steps to complete this

spreadsheet: Customer

Invoice

1. Create the company Logo

and title.

2. Format as table- choose

your color.

3.

Format price per unity and

line total to currency : P or

Php

4. Compute : Line Total =

quantity'

* price and total

Supplies,

Total=sum(D4:d7)

Change= total - change

5.

Change the tab or sheet

name to Customer invoice

and change the tab color

6.

Print screen the final output

Steps to complete this
spreadsheet: Budget and
Format Supplies
1. Create the company Logo
and title.
2. Format as table- choose
your color.
3. Format price per unity
and line total to currency
: P or Php
4.
Compute : Line Total and
total Supplies, Total
Monthly bills and Total
5.
Change the tab or sheet
name and table color
6.
Print screen the final output