EX2 MS OFFICE Excel
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’a 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 #13 SAVE your file as: yourname – EX2-2 Due Date: Sunday, August 9, 2020- 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)