Question: Hands - On Exercise 1 7 9 Watch the Video HOE 1 Trainingfor this Hands - On Hands - On ExercisesExercise! 1 Introduction to SpreadsheetsAs

Hands-On Exercise 179Watch the Video HOE1 Trainingfor this Hands-On Hands-On ExercisesExercise!1Introduction 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 25% 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 e01h1Markup and save it as e01h1Markup_LastFirst.When you save files, use your last and first names. For example, as the Excel author, I would save my workbook as e01h1Markup_MulberyKeith.TROUBLESHOOTING:If you make any major mistakes in this exercise, you can close the file, open e01h1Markup again, and then start this exercise over.b.Click cell A5, type Computer System, and then press Enter.When you press Enter, the next cell downcell A6 in this casebecomes the active cell. The text does not completely fit in cell A5, and some of the text appears in cell B5. If you make cell B5 the active cell, the Formula Bar is empty, indicating that nothing is stored in that cell.c.Type Color Laser Printer in cell A6 and press Enter.When you start typing C in cell A6, AutoComplete displays a ScreenTip suggesting a previous text entry starting with CComputer Systembut keep typing to enter Color Laser Printer instead.d.Continue typing the rest of the text in cells A7 through A10 as shown in Figure 1.8. Text in column A appears to flow into column B.You just entered the product labels to describe the data in each row.Step 1ENTER 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 1.8

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 Databases Questions!