Question: Please complete the assignment on time and submit it to the online portal. Also note that, late submissions will not be allowed. Time: 2 hrs.

 Please complete the assignment on time and submit it to the

Please complete the assignment on time and submit it to the online portal. Also note that, late submissions will not be allowed. Time: 2 hrs. Marks: 40 '2 Create an excel project using the following step by step instructions Jr Save your files on the desktop and ensure you give the right name from the following instructions. 'r Every cell reference is marked. So follow the column/ row headings instructions carefully. Instruction: Create a new workbook and save on the desktop as Employee Expense Report, for Acme Publishing Inc. 1. Design the presentation of your worksheet as follows: Name your first worksheet as Employee Expense I Row 1: :Acme Publishing, Inc. 0 Row 2: : Employee Expense Report - Row 4: : Month, Hotel, Meals, Travel, Misc., Total, and Rate (In Columns] 2. Merge the cell ranges A1:61 and A2:GZ 3. Enter the following data under the proper column: ( Leave the total 8. Rate column blank for future calculations) January 1343 1265 1187 1109 February 1543 1654 1766 1877 March 1723 2044 1400 1800 April 1546 1545 1352 1258 May 1250 1546 1542 1820 June 1545 1230 1620 1450 lof'2 MSOIEXI 4. Create a formula in F5 for January's total expense 5. Copy the formula to the cell range F6:F10 6. Format the cell range B5:F10 with currency and two decimal points 7. Using the IF function, create the formula in 65 that enters the value of "High" if the total expense is greater than $6,000 and "Regular\" if it is less than 5 6,000 8. Copy the Formula to the cell range 662610 9. Rename the Sheet 2 as Employee Expense Table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!