FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Excel_Module_3

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

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

A) CTRL+1
B) CTRL+2
C) CTRL+3
D) CTRL+4

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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.

A) ENTER
B) ALT
C) CTRL
D) SHIFT

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

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

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

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

A cell reference with only one dollar sign before either the column or the row is called an absolute 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?

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

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

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

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.

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.

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

Which of the following formulas contains an absolute cell reference?

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

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

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

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.

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

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