Click the tab named Sheet2 in the workbook you used for question.a. Place the labels Part...

Click the tab named Sheet2 in the workbook you used for question.

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. 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.

d. 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.

e. In cell E3, enter a formula that will multiply the quantity on hand (C3) by the cost (D3).

f. Create the same formula in cells E4 through E7. Use select and copy operations.

g. Explain what is magic about the operation in part f.

h. Print the result of your activities in parts a–f. Print your document in landscape mode, showing cell boundaries and row and column names.

Question

Create a new workbook and take the following actions:

a. Name and save your workbook using a name of your own choosing.

b. Enter the value This is the content of cell C7 into cell C7.

c. Use F2 to change the value in cell C7 to This is part of the content of cell C7.

d. Add the value January to cells B2 through B14. Key the data just once.

e. Add the value January to cell C2 and the value February to cell C3. Highlight both cells C2 and C3 and drag the small black box down to cell C14. Explain what happens.

f. Create a list of odd numbers from 1 to 11 in cells C3 through C8. Key only the values 1 and 3.

g. Enter the value MIS-1 in cell D2 and the value MIS-2 in cell D3. Highlight cells D2 and D3 and drag the small black box down to cell D14. Explain what happens.