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...
-
The interest rate is 7 percent. Use the concept of present value to compare $200 to be received in 10 years and $300 to be received in 20 years.
-
(a) If the demand function of a good is given by P = 80 3Q find the price when Q = 10, and deduce the total revenue. (b) If fixed costs are 100 and variable costs are 5 per unit, find the total cost...
-
Explain the issues involved in establishing ROI for T&D initiatives. What role do HRIS T&D applications play in establishing ROI?
-
Carolinas Golf School, Inc., completed the following transactions during October, 2012: Oct 1 Prepaid insurance for October through December, $900. 4 Performed services (gave golf lessons) on...
-
4.4. Solve the problem Ju + uu = 0 (u(x, 0) = g(x) where g(x) = 1 0 TER, t> 0 TER x <0 0 1.
-
Multi Enterprises Ltd. is a Canadian-controlled private corporation whose fiscal period coincides with the calendar year. For the year 2020, the company's taxable income was calculated as follows:...
-
The management of Devin Corporation is testing two of its reporting units for impairment of goodwill. Information about results of these tests are shown below. Segment carrying amount (including...
-
Which of the following are types of block storage? A. NVMe SSD B. Boot volumes C. Block volumes D. Object storage
-
Stressors that affect a single person and produce an immediate major reaction are known as a. Personal stressors b. Psychic stressors C. d. Daily stressors Cataclysmic stressors
-
How do schemas help people process information during encoding, storage, and retrieval? In what ways are they helpful? How can they contribute to inaccurate autobiographical memories?
-
What principles underlie our organization of the visual world and allow us to make sense of our environment?
-
Before sophisticated brain-scanning techniques were developed, behavioral neuroscientists understanding of the brain was based largely on the brains of people who had died. What limitations would...
-
A property produces an income of $10,000 per year. Management expenses are$700 annually. Monthly heating costs are $92. If the property is valued at$80,000, what is the owner's approximate overall...
-
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 positively charged particle creates the electric field shown in Figure 30. 20. When the kinks in the electric field lines reach the rod, what is the direction of the current induced in the rod?...
-
Suppose the current shown in Figure 30. 19 discharges the capacitor. What are the directions of \(\vec{E}\), \(\Delta \vec{E}\), and \(\vec{B}\) between the plates of the discharging capacitor? Data...
-
For the oscillating dipole of Figure 30. 14, sketch the electric field pattern at \(t=\frac{5}{4} T\). Data from Figure 30.14 0=1 t = T t=T 1=T O O D
Study smarter with the SolutionInn App