Exam 10: Excel_Module_3

Which of the following Auto Fill Options menu options is the same as the Fill Series option?

You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow.

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

Excel includes four types of sparkline charts: line, column, win/loss, and stock.

A sensitivity analysis is another name for a(n) ____________________ analysis.

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

Which of the following formulas contains an absolute cell reference?

If the contents of a cell copied using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?

You can press the ____ keys to open the Format Cells dialog box.

The ____________________ function is useful when you want to assign a value to a cell based on a logical test.

When working with a large worksheet, you can split the window into ____ panes.

The range of entries that identifies the major groups for a clustered column chart are called the category names.

Following the insertion of a row, the Insert Options button lets you select from which of the following options?

In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.

The ____________________ option on the Auto Fill Options menu fills the destination area with a series of months using the format of the source area.

The ____________________ option on the Auto Fill Options menu fills the destination area using the format of the source area; no content is copied unless the fill is a series.

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.

Excel allows you to ____________________ the titles so that the titles remain on the screen no matter how far down or to the right you scroll.

The underline format underlines the entire cell, not just the characters in the cell.