MS OFFICE Excel – Module 2

Read Module 2 of Excel.

There are no data files needed for this chapter.

Complete and SUBMIT the following:

· Complete the exercise that is found throughout the module as a tutorial. Olivia’s Art Supply

· SAVE your file as: yourname – EX2-1

· Complete: In the Lab #2 exercise for this module on page EX110

· If it says “If requested by instructor”, it IS REQUESTED

· DO NOT print if it asks you to

· IGNORE step #18

· SAVE your file as: yourname – EX2-2

Due Date: Sunday, August 8, 2021- Midnight.

If formulas are not included, the assignment will be returned.

NOTE: It has come to my attention that some of you may be using a different version of the book (EX67). T here are some errors in the formulas for Linda Fox Budget. Here are the correct formulas.

Federal Tax (cell G4) = 0.22 * (Gross Pay – Dependents * 24.32)

Tax % (cell I4) = (Federal Tax + State Tax) / Gross Pay

Net Pay (cell J4) = Gross Pay – (Federal Tax + State Tax)