Excel 5

The process of summarizing data included on multiple worksheets on one worksheet is called _____.

_____ format codes allow you to specify how a cell entry assigned a format will appear.

Which of the following keyboard shortcuts allows you to select a range of cells with entires surrounded by blank cells?

You should create good ___ to ensure your worksheets are free of errors.

The following sequence, Jan, Feb, Mar, etc. is an example of a _____ series.

The following sequence, 1, 1, 1, etc., is an example of a _____ series.

The following sequence 2, 4, 6, etc. is an example of a ____ series.

The following sequence 1, 2, 3, etc. is an example of a ____ series.

Which of the following is the path to the fill button?

It is recommended that you use the _____ function on formulas that potentially can result in more decimal places than the applied format displays.

The path to the Sum button is ____

to copy the content of a cell to the cell directly below it, click the target cell and press ____.

You should hold down the ____ key to select the nonadjacent cells.

Which of the following format codes insures that Excel will display a decimal point in the number?

Which of the following format symbols displays text along with numbers entered in a cell?

You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format code.

Which of the following format codes shows percent values with two decimal places and shows negative percent in blue with parentheses?

The path to the Comma Style button is ____.

The ____ style is the format style that Excel initially assigns to all cells in a workbook.

A workbook contains _____ worksheets by default.

You can drill all of the following down through a workbook EXCEPT ____.

A range that spans two or more worksheets in a workbook is called a ___ range.

A ____ reference is a formula that depends on its own value.

Headers, footers, and margins are all ____ options.

You can display the ____ tab to specify page setup options.

You can switch to Page Layout view by clicking the Page Layout button _____.

The code ____ instructs Excel to insert the page number in the header or footer section.

To select adjacent sheets, select the first sheet by clicking its tab then hold down the ____ key and lick the sheet tab at the other end of the list of adjacent sheet tabs.

To select nonadjacent sheets, select the first sheet by clicking its tab and then hold down the _____ key and lick the sheet tabs of the remaining sheet you want to select.

If multiple sheets are selected and you want to select the active sheet, if you are using a touch screen, press and hold and select ____ from the shortcut menu.

A ____ is a reference to a cell or range of cells in another workbook.

which of the following is the path to the Switch Windows button?

As you link workbooks, the cell reference inserted by Excel each time you tap or click a cell in a workbook results in a(n) ____ cell reference.

You can customize a format code in a cell entry to specify how ____ are displayed in a cell.

Which of the following fill actions can you preform by dragging the fill handle?

Which of the following are true about the ROUND function?

Which of the following is a method of electronic document distribution?