Question: Mark the steps as checked when you complete them. 1 . Open the WilsonHome - 0 5 start file. If the workbook opens in Protected

Mark the steps as checked when you complete them.
1.
Open the WilsonHome-05 start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
2. Group, edit, and format sheets.
a. Click the Rockford sheet tab, press Shift, and click the CashFlow tab. The Rockford sheet is visible so that you will be able to see format changes. The Vendors sheet is not part of the group.
b. Open the Page Setup dialog box and click the Margins tab.
c. Choose Horizontally from the Center on page list and click OK.
d. Edit the contents of cell A10 to read Cash paid for marketing.
3. Format values for negative number display.
a. Select Currency as the Category.
b.
c. Choose 0 decimal places.
d. Confirm or select $ as the Symbol.
e. Select the option to display negative numbers in red with parentheses.
f. Click OK.
4. Insert formulas on grouped sheets.
a. Select cell B13 and click the AutoSum button [Home tab, Editing group].
b. Reselect the range B4:B12 and press Enter.
c. Select cell B22 and sum cells B15:B21.
Mark the steps as checked when you complete them.

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