Create an excel project using the following step by step instructions > Save your files on...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create an excel project using the following step by step instructions > Save your files on the desktop and ensure you give the right name from the following instructions. > 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 • • • Row 1: Row 2: Row 4: 2. Merge the cell ranges A1:G1 and A2:G2 3. Enter the following data under the proper column: (Leave the total & Rate column blank for future calculations) January February 1543 1343 1265 1654 March April May June : Acme Publishing, Inc. : Employee Expense Report : Month, Hotel, Meals, Travel, Misc., Total, and Rate (In Columns) 1187 1766 1723 2044 1400 1546 1250 1545 1545 1352 1546 1542 1230 1620 1109 1877 1800 1258 1820 1450 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 G5 that enters the value of "High" if the total expense is greater than $6,000 and "Regular" if it is less than $ 6,000 8. Copy the Formula to the cell range G6:G10 9. Rename the Sheet 2 as Employee Expense Table Create an excel project using the following step by step instructions > Save your files on the desktop and ensure you give the right name from the following instructions. > 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 • • • Row 1: Row 2: Row 4: 2. Merge the cell ranges A1:G1 and A2:G2 3. Enter the following data under the proper column: (Leave the total & Rate column blank for future calculations) January February 1543 1343 1265 1654 March April May June : Acme Publishing, Inc. : Employee Expense Report : Month, Hotel, Meals, Travel, Misc., Total, and Rate (In Columns) 1187 1766 1723 2044 1400 1546 1250 1545 1545 1352 1546 1542 1230 1620 1109 1877 1800 1258 1820 1450 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 G5 that enters the value of "High" if the total expense is greater than $6,000 and "Regular" if it is less than $ 6,000 8. Copy the Formula to the cell range G6:G10 9. Rename the Sheet 2 as Employee Expense Table
Expert Answer:
Answer rating: 100% (QA)
1 2 3 4 Month 5 January 6 February 7 March 8 April 9 May 10 June 11 12 13 14 15 16 17 18 19 20 21 2... View the full answer
Related Book For
Integrated Accounting
ISBN: 978-1285462721
8th edition
Authors: Dale A. Klooster, Warren Allen, Glenn Owen
Posted Date:
Students also viewed these accounting questions
-
Your instructor will show you how to create data files using the software for your course. Use it to create the data file you constructed by hand in Exercise 1.17 or 1.18.
-
Create an accounting workbook and accompanying informational report to taxpayers. Governments are unique in that most of their revenue comes from taxes and fees imposed upon the citizens. It is the...
-
Enter the following column headings across the top of a sheet of paper: Enter the transaction letter in the first column and show the effect (if any) of each of the following transactions on each...
-
A chemical is spilled into a lake of pure water and the concentration of chemicals in this lake is 4 If 20 of the water in the lake is replaced with clean in one month then. What will be the...
-
Define IP spoofing.
-
A worker produced 200 units in a week's time. The guaranteed weekly wage payment for 45 hours is Rs. 81. The expected time to produced one unit is 15 minutes which is raised further by 20% under the...
-
Table 2-2 on page 45 is a frequency distribution summarizing the IQ scores of a group of children with low lead exposure. Is it possible to identify the original list of the 78 individual IQ scores...
-
Prepare journal entries to record the following transactions for a nongovernment ONPO. 1. Unrestricted cash gifts that were received last year but restricted for use in the current year totaled...
-
Solve 27. f(x) = x1/3 9(x) = 8x f(g(x)) = 28. f(x) = x5 g(x) = x 4/5 g(f(x)) = f(g(2)) =
-
On Monday, a certain stock closed at $10 per share. On Tuesday, you expect the stock to close at $9, $10, or $11 per share, with respective probabilities 0.3, 0.3, and 0.4. On Wednesday, you expect...
-
Financial Statement Analysis ProjectA Comparative Analysis of Oracle Corporation and Microsoft Corporation Here is the link for the financial statements for Oracle Corporation for the fiscal year...
-
Why does CRA provide individuals with three alternative installment payment methods?
-
Hailey Denison, CPA, has recently accepted a position as a financial analyst with Machine Design and Factory Automation (MDFA) Ltd. Reporting to Dexter Reid, P. Eng., Vice-President of New Product...
-
a long jumper leaves the ground with an initial velocity of 8m/s at an angle of 35 degrees above the horizontal. a. draw the projectile path of the jumper incliding 3 sets of vectors anywhere along...
-
Explain briefly taxable profit and also the split rate system? Define and explain the corporate income tax? Who are the shareholders? CR is resident in Country X. CR makes a taxable profit of...
-
What is the market price of a firm that pays $20 dividend every two years forever (with the first payment one year from today) given that the market premium is 10%, the market expected return is 15%...
-
Prove the following identities. (a) (a + b) x (a - b) = -2(a x b). ab b.c a.d b.d (b) (axb). (cx d) = =
-
I frequently use NY Times and CNN and am aware of Fox News but I never use it. I visit these sites, NY Times and CNN, a few times a week whenever I have to research something or see something on...
-
How can a company improve its current ratio?
-
How does the computer know what check numbers to assign to current payroll checks?
-
Write the answers to the following questions in the space provided. 1. What is the original cost of asset number 350 (office desk) as shown on the fixed assets list? 2. What is the salvage value of...
-
A radar with a phased array antenna conducts a search using a 1500-beam search raster. That is, it steps through 1500 beam positions that span a certain angular area. It transmits one pulse per beam....
-
A certain circularly scanning radar with a fan beam has a rotation rate of 3 seconds per revolution. The azimuth beam width is \(3^{\circ}\), and the radar uses a PRI of 600 microseconds. The radar...
-
A certain radar employs a noncoherent integrator that integrates 25 pulses. What are the integrator gains, in dB, for a SW0, a SW1, a SW2, a SW3, and a SW4 target? Briefly discuss how you arrived at...
Study smarter with the SolutionInn App