Complete the invoice using the following information:
a. Key the current date in G6 October 5,2005
b. Each custom costume fee is $2,500.00. Enter this value in F15:F19
c. Total the costume fees in F20
d. A transportation and storage container for each of the five costumes
is $75.00.
Enter the appropriate formula in F22 that will calculate the fee
for five
Containers.
e. Enter in F23 the delivery for all five costumes as $112.50
f. Enter the formula in F24 that will add the total for the costume fees
with the
additional charges.
Enter the formula in F25 that will calculate 7% GST (Goods and Services
Tax) on the total including additional charges.
Enter the formula to total the invoice in F26 as the sum of F24 and F25
Forma the worksheet to improve the appearance of the invoice.
Computer Science Homework Solutions
#55689
Excel S2-P3
1. Complete the invoice using the following information:
a. Key the current date in G6 October 5,2005
b. Each custom costume fee is $2,500.00. Enter this value in F15:F19
c. Total the costume fees in F20
d. A transportation and storage container for each of the five costumes is $75.00.
Enter the appropriate formula in F22 that will calculate the fee for five
Containers.
e. Enter in F23 the delivery for all five costumes as $112.50
f. Enter the formula in F24 that will add the total for the costume fees with the
additional charges.
g. Enter the formula in F25 that will calculate 7% GST (Goods and Services Tax) on the total including additional charges.
h. Enter the formula to total the invoice in F26 as the sum of F24 and F25
i. Forma the worksheet to improve the appearance of the invoice.
What is this?
By OTA - Overall OTA Rating
Maddu Shankar, MSc - 4.6/5
Purchase Cost Now
$2.19 CAD (was ~$3.99)
Included in Download
- Plain text response
- Attached file(s):
- Excel S2-P3_Solution.xls
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- A workbook can contain more than one worksheet. - A workbook can contain more than one worksheet. Can you give an example of a spreadsheet application where it would be necessary to have more than one worksheet, can you explain how that works?
- Excel S3-P5 - 1. Melissa Gehring, manager of the Los Angeles office for First Choice Travel, has prepared a worksheet listing European destinations and the current package pricing options. Melissa has requested tha ...
- Microsoft Excel S1-P1 - 1. You have received a message from Melissa Gehring of First Choice Travel with quoatations for return airfare, hotel, and airport transfers for the film crew to travel to Toronto for the location sho ...
- What is the difference between a workbook and a worksheet? - What is the difference between a workbook and a worksheet? Why would you want to use separate worksheets when using Excel? Please give two general examples. Please research and find the method for ...
- Excel S4-R1 - Excel S4-R1
