3. Click the tab named Sheet2 in the workbook you used for exercise 2. a. Place the...

Question:

3. Click the tab named Sheet2 in the workbook you used for exercise 2.

a. Place the labels Part Description, Quantity on Hand, Cost, and Total Value in cells A2, A3, A4, and A5, respectively. Center each label in its cell and make the labels bold. (Do this by highlighting the labels and clicking the bold B in the Font section of the Home tab.) Make each column large enough to show the entire label after formatting.

b.
Workbook 369 Worksheet 369 In cells B3, B4, B5, B6, and B7, respectively, enter the following values:
This is where one would type the description of Part 1 This is where one would type the description of Part 2 This is where one would type the description of Part 3 This is where one would type the description of Part 4 This is where one would type the description of Part 5 Enter these values using the fewest possible keystrokes.
C. Enter the quantity-on-hand values 100, 150, 100, 175, and 200 in cells C3 through C7, respectively.
Enter these values using the fewest possible keystrokes.
Enter the values $100, $178, $87, $195, and $117 in cells D3 through D7, respectively. Do not enter the dollar signs. Instead, enter only the numbers and then reformat the cells so that Excel will place them.
In cell E3, enter a formula that will multiply the quantity on hand (C3) by the cost (D3).
Create the same formula in cells E4 through E7.
Use select and copy operations.
Explain what is magic about the operation in step f.
Print the result of your activities in steps a-f. Print your document in landscape mode, showing cell boundaries and row and column names.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Experiencing MIS

ISBN: 9780136078685

2nd Edition

Authors: David Kroenke

Question Posted: