Cis Chapter 7 Procedures

Front 1

To split the Balance Sheet worksheet into two panes:

Back 1

a.) Move the pointer over the split box at the top of the vertical scroll bar until the point changes.
b.) Click and then drag the pointer down. As you drag the pointer down a thick gray bar appears across the worksheet.
c.) Release the must button to separate the worksheet into 2 panes.
d.) Click any cell in the top pane, and then, using the scroll bar for that pane, scroll down until row 21 is the last row displayed in the pane.
e.) Press the F6 key to make the bottom pane the active pane.

Front 2

To remove the split in the Balance Sheet worksheet:

Back 2

Double-click any part of the split bar that divides the panes. The split bar is removed.

Front 3

To display the Formula Auditing toolbar:

Back 3

a.) Click Tools
b.) Formula Auditing
c.) Show Formula Auditing Toolbar

Front 4

Tracing Precedent and Dependent Cells:

Back 4

a.) Select cell that contains the formula that you want to trace.
b.) Click Trace Precedents to display tracer arrows pointing to the formula’s precedent cells.
c.) Click the Trace Dependents to display tracer arrows pointing to cells dependent on the formula’s value.

Front 5

Tracing Errors:

Back 5

a.) Click cell displaying an error value.
b.) Click the Trace Error button on the Formula Auditing toolbar.
c.) Follow the tracer arrows back to the source of the error.
d.) Correct the source of the error.

Front 6

Locating Suspect Formulas:

Back 6

a.) Switch to the worksheet that you want to search for suspect formulas.
b.) Click the Error Checking button on the Formula Auditing toolbar.
c.) Use the options presented in the Error Checking dialog box to correct the suspect formula, or click the Next button to move on to the next suspect formula.
d.) Click the OK button

Front 7

Inserting a Comment:

Back 7

a.) Click the cell to which you want to attach a comment.
b.) Right-click the cell and then click Insert Comment on the shortcut menu (or click Insert and then click Comment).
c.) Type your comment into the comment box.

Front 8

Sharing a Workbook:

Back 8

a.) Click Tools on the menu bar, and then click Share Workbook.
b.) Click the Allow changes by more than one user at the same time check box.
c.) Click the OK button.

Front 9

Tracking Changes to Cells:

Back 9

a.) Open a shared workbook.
b.) Click Tools, point to Track Changes, and then click Highlight Changes.
c.) Click the list arrow for the When check box, and select the timeframe of the changes that you want to track.
d.) Click the list arrow for the Who check box, and then select whose changes you want to view.
e.) Click the Where reference box and specify where in the workbook you want to review the changes.
f.) Click the Highlight changes on screen check box to display changed cells in the worksheet.
g.) Click the List changes on a new sheet check box to display a list of changed cells on a separate worksheet.
h.) Click the OK button.

Front 10

Accepting and Rejecting Changes to Cells:

Back 10

a.) Open a shared workbook.
b.) Click Tools, point to Track Changes, and then click Accept or Reject Changes.
c.) Click the list arrow for When check box, and then select the timeframe of the changes that you want to review.
d.) Click the list arrow for the Who check box, and then select the person whose changes you want to review.
e.) Click the Where reference box and specify where in the workbook you want to review the changes.
f.) Click the OK button.

Front 11

Merging workbooks:

Back 11

a.) Open the workbook into which you want to merge the files.
b.) Click Tools, and then click Compare and Merge Workbooks.
c.) Select the workbooks that you want to merge into the active file.
d.) Click the OK button.

Front 12

Saving a Workbook as a Web Page:

Back 12

a.) Click File, and then click Save as Web Page.
b.) Click the Add interactivity check box to create an interactive Web page. Leave unchecked for noninteractive.
c.) Click the Publish button.
d.) Click the Choose list box, and select which portions of the workbook you want to publish as a Web page.
e.) Click the Change button to change the title of the Web page.
f.) Click the Browse button to specify a filename and location for the Web page.
g.) Click the AutoRepublish every time this workbook is saved check box to automatically republish the Web page each time you save the workbook.
h.) Click the Open published web page in browser check box to automatically open the Web page in your Web browser.
i.) Click the Publish button.

Front 13

Inserting a Hyperlink:

Back 13

a.) Select the text, graphic, or cell in which you want to insert the hyperlink.
b.) Click Insert on the menu bar, and then click Hyperlink.
c.) To link to a file or Web page, click Existing File or Web Page in the Link to list, and then select the file or Web page from the Look in list box.
d.) To link to a location in the current workbook, click Place in This Document in the Link to list, and then select the worksheet, cell, or range in the current workbook.
e.) To link to a new document, click Create New Document in the Link to list, and then specify the filename and path of the new document.
f.) To link to an e-mail address, click E-mail Address in the Link to list, and then enter the e-mail address of the recipient and a subject line for the e-mail message.