FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 9: Excel: Working With Large Worksheets, Charting, and What-If Analysis

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Essay

Review LaterAdd Note

Review Later

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.

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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

A) IF
B) NOW
C) AND
D) OR

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

The incorrect use of copying,deleting,inserting,and moving ranges of cells has the potential to render a worksheet useless.

The ____ Auto Fill Option that fills the destination area using the format of the source area;no content is filled.

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

The Copy button copies the contents and format of the source area to the Office ____,a temporary storage area in the computer's memory.

____ text often provides a strong visual appeal.

The <= comparison operator means less than or equal to.

The path to the Logical button is (FORMULAS tab | Function Library group).

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

Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box.Which of the following are valid values for that number?

____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.

The syntax of the IF function is IF(logical_test),value_if_false,value_if_true).

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

AND,OR,and NOT are called ____________________ operators.

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

When you change a value on which a chart is dependent,Excel immediately redraws the chart based on the new value.

____________________ are values in cells that can be changed to determine new values for formulas.

Which of the following is an extension of the fill pattern Sunday,Tuesday?

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.