a. Select cell A4. Type Bennett, Joanne and then press the right arrow key two times to enter the employee name and make cell C4 the active cell.

b. Type 2 in cell C4 and then press the right arrow key.

c. Type 64.25 in cell D4 and then press the right arrow key.

d. Type 19.75 in cell E4.

e. Click cell K4 and then type 4/5/12.

Transcribed Image Text:

AutoSave OFF OF Home Insert. Draw Page Layout Formulas Data Review View ď TA 13 ✓ 1 2 3 4 5 7 9 10 11 12 13 Totals 18 19 20 21 22 D Proximity Bus Service Vehicle Cost Analysis Cost Maintenance Mileage per Mile Miles Driven Cost 2.01 19964 283.22 1.88 16660 393.8 1.87 14949 323.2 mī 1.91 14905 476.61 1.7 11242 232.79 1.65 14662 497.23 1.79 16061 275.32 1.88 14777 281.62 1.69 18484 465.94 23 24 25 26 Poste 27 28 29 30 31 32 33 34 35 36 37 38 A 39 40 BusID 701 702 703 14 Average 15 Highest 16 Lowest 17 704 705 + x ✓ fx 706 707 708 709 Calibri (Body) В 1 P C ✓11 G Vehicle Cost Analysis + Enter Accessibility: Good to go ✓ A A E Cost Total Cost 6 Total Cost per Mile Tell me Wrap Text v Apply 2-1 Proximity Bus (1) Merge & Center v H I J General $ % K 9 L fo v $0 M D. D.D. Conditional Format Cell Formatting as Table Styles N 0 P SH V Insert Delete R HH. H-H Format 5 Iv 6 T 回円 V Share Sort & Filter U a Fin Selec V Comments Keyboard UNTH + 100% T X AutoSave OFF OF Home Insert. Draw Page Layout Formulas Data Review View ď TA 13 ✓ 1 2 3 4 5 7 9 10 11 12 13 Totals 18 19 20 21 22 D Proximity Bus Service Vehicle Cost Analysis Cost Maintenance Mileage per Mile Miles Driven Cost 2.01 19964 283.22 1.88 16660 393.8 1.87 14949 323.2 mī 1.91 14905 476.61 1.7 11242 232.79 1.65 14662 497.23 1.79 16061 275.32 1.88 14777 281.62 1.69 18484 465.94 23 24 25 26 Poste 27 28 29 30 31 32 33 34 35 36 37 38 A 39 40 BusID 701 702 703 14 Average 15 Highest 16 Lowest 17 704 705 + x ✓ fx 706 707 708 709 Calibri (Body) В 1 P C ✓11 G Vehicle Cost Analysis + Enter Accessibility: Good to go ✓ A A E Cost Total Cost 6 Total Cost per Mile Tell me Wrap Text v Apply 2-1 Proximity Bus (1) Merge & Center v H I J General $ % K 9 L fo v $0 M D. D.D. Conditional Format Cell Formatting as Table Styles N 0 P SH V Insert Delete R HH. H-H Format 5 Iv 6 T 回円 V Share Sort & Filter U a Fin Selec V Comments Keyboard UNTH + 100% T X