Exp19_Excel_Ch01_HOEAssessment_OKOS #exp19_excel_ch01_hoeassessment #exp19 #ch01_hoeassessment
If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,
Whatsapp Contact Link:
api.whatsapp.com/message/4B6N...
Whatsapp Number:
+919116641093
+918005564456
Gmail Id:
assignmentstutorial@gmail.com
We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English.
Steps to Perform:
Step
Instructions Points Possible
1 Start Excel. Download and open the file named Exp19_Excel_Ch01_HOEAssessment_OKOS.xlsx. Grader has automatically added your last name to the beginning of the filename. 0
2 Find all occurrences of Amount and replace them with Price. 2
3 You want to use Auto Fill to enter a series of codes representing the year (2021), the month (09), and a number.
Enter 2021-09-100 in cell B6 and use Auto Fill to complete the sequence for the range B7:B11.
Hint: Use the fill handle and the Auto Fill Options to fill the series. 3
4 The OKOS workbook contains spelling errors that need to be corrected.
Use Excel to check and correct the spelling errors in the worksheet. Hint: The Review tab contains the Spelling tool. 4
5 The worksheet contains the cost and retail prices. You want to calculate the amount of markup.
In cell D6, enter a formula to calculate the markup amount, which is the difference between the retail price and cost. Copy the formula to the range D7:D11.
Hint: The formula is =Retail Price - Cost. 5
6 Each item is on sale this week. The sale price is X percent off the retail price. You need to calculate the sale price.
In cell G6, calculate the sale price. Copy the formula down the range G7:G11.
Hint: The formula is either =Retail Price - (Percent Off * Retail Price) or
=Retail Price * (1- Percent Off). 5
7 The profit margin is the ratio of the net profit as a percentage of 5
Step
Instructions Points Possible
revenue. The formula first calculates the net profit between the sale price and the cost and divides that by the sale price.
In cell H6, enter a formula to calculate the profit margin. Copy the formula to the range H7:H11.
Hint: The formula is =(Sale Price - Cost) / Sale Price
8 The filing cabinets are out of stock; therefore, you should remove that product from the list of products on sale.
Delete row 8 that contains the filing cabinet data. Hint: Delete is on the Home tab. 2
9 You want to insert a row to display the heading Furniture above the furniture products.
Insert a new row 8 and type Furniture in cell A8. Bold the word
Furniture in cell A8.
Hint: Insert is on the Home tab or on the shortcut menu. 4
10 Column A is too narrow for the product names. You want to increase the width.
Increase the width of column A to 28.00.
Hint: Format is on the Home tab or you can drag the column border. 4
11 The 32" Curved Monitor product is below the Furniture heading. This product belongs in the Equipment area. You will move the monitor product row to be above the Furniture heading.
Insert a row above the Furniture heading, cut the 32" Curved Monitor
row, and paste it in the range A8:H8.
Hint: Insert, Cut, and Paste are on the Home tab. 6
12 The worksheet title should stand out prominently on the worksheet.
Merge and center the title over the range A1:H1, apply the Accent 1 cell style, and change the font size to 14.
Hint: Merge, Cell Style, and Font Size are on the Home tab. 5
13 The column headings on row 4 should be formatted to improve the appearance of the worksheet.
exp19_excel_ch01_hoeassessment,#exp19_excel_ch01_hoeassessment,exp19_excel_ch01_hoeassessment_okos,#exp19_excel_ch01_hoeassessment_okos,#exp19_excel_ch01_hoeassessment_okos #,#exp19_excel_ch01_hoeassessment_okos op,exp19_excel_ch01_capassessment_training,#exp19_excel_ch01_hoeassessment_okos.xl,exp19_excel_ch01_hoeassessment_okos.xlsx,#exp19_excel_ch01_capassessment_training,#exp_19_excel_ch01_hoeassessment_okos,#exp19_excel_hoeassessment,#excel_ch01_hoeassessment_