excel chapter 6 – Flashcards

a worksheeet____is a collection pf two or more selected worksheets.

To select adjacent worksheets, you use the ____key.

The ___caption indicates a worksheet group.

When a worksheet group is seleceted, the ____includes text to indicate this.

To remove a worksheet group, you can right-click the sheet tab of a sheet in the group and the click ___on the shortct menu.

When you reference a cell or range in a different worksheet, the ____separates the sheet reference from the cell reference.

The correct format for: The following formula forn a sheet names Sales Data...

The worksheet range____references the worksheets, "Sheet1," "Sheet2," "Sheet3," and "Sheet4"

If a sheet range includes jmore than on sheet, you specify the first and last sheet in the range separated by a _____.

If you need to use dat located in ne workbook in theother workbook, you have to create a(n)____ between the two workbooks.

If you want to create a cell reference to the B6 on the Summary Info worksheet of the Sales.xls workbook, you would use the following external reference:_____

The ____arrangement option layers the open workbooks on the screen.

You can create a(n)____reference by deleting te $ from the row reference in the cell reference $b$6.

If you receive a destination workbook but the source files are not included, click ____the Link button in the Edit Links dialog box to replace the external references with existing values.

When two workbooks are ___, it is important that the data in the destinatioln file accurately reflects the contents of the source file.

The ____dialog box lists all of the links in the current workbook.

In regard to open workbooks a workspace saves all of h following EXCEPT______.

If Excel successfully accessed the link and updated the values from the source document, the status in the Edit Links dialog box will be_____.

To manually update the link and see the new data values, click the Update Values button in the Edit Links dialog box.

In the Edit Links dialog box, Type identifies the type of each ____file.