Question: Hands - On Exercise 1 7 9 Watch the Video HOE 1 Trainingfor this Hands - On Hands - On ExercisesExercise! 1 Introduction to SpreadsheetsAs
HandsOn Exercise Watch the Video HOE Trainingfor this HandsOn HandsOn ExercisesExercise!Introduction to SpreadsheetsAs the assistant manager of OKOS, you will create a worksheet that shows the cost the amount OKOS pays its suppliers the markup percentage the amount by which the cost is increased and the retail selling price. You also will list the discount percentage such as off for each product, the sale price, and the profit margin percentage.Skills covered: Enter Text Use Auto Fill to Complete a Sequence Enter Values Enter a Date Clear Cell Contentsa.Open ehMarkup and save it as ehMarkupLastFirst.When you save files, use your last and first names. For example, as the Excel author, I would save my workbook as ehMarkupMulberyKeith.TROUBLESHOOTING:If you make any major mistakes in this exercise, you can close the file, open ehMarkup again, and then start this exercise over.bClick cell A type Computer System, and then press Enter.When you press Enter, the next cell downcell A in this casebecomes the active cell. The text does not completely fit in cell A and some of the text appears in cell B If you make cell B the active cell, the Formula Bar is empty, indicating that nothing is stored in that cell.cType Color Laser Printer in cell A and press Enter.When you start typing C in cell A AutoComplete displays a ScreenTip suggesting a previous text entry starting with CComputer Systembut keep typing to enter Color Laser Printer instead.dContinue typing the rest of the text in cells A through A as shown in Figure Text in column A appears to flow into column BYou just entered the product labels to describe the data in each row.Step ENTER TEXTNow that you have planned the OKOS worksheet, you are ready to enter labels for the product names in the first column. Refer to Figure
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
