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

Explore all topics

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?

(Multiple Choice)

4.8/5

(78)

Question 41

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.

(True/False)

4.8/5

(81)

Question 42

AND,OR,and NOT are called ____________________ operators.

(Essay)

5.0/5

(87)

Question 43

____ text often provides a strong visual appeal.

(Multiple Choice)

4.7/5

(79)

Question 44

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

(Multiple Choice)

4.9/5

(87)

Question 45

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

(Essay)

4.7/5

(72)

Question 46

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

(True/False)

4.8/5

(89)

Question 47

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

(Essay)

4.9/5

(87)

Question 48

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

(Multiple Choice)

4.9/5

(84)

Question 49

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

(True/False)

4.8/5

(83)

Question 50

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

(True/False)

4.9/5

(73)

Question 51

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

(Multiple Choice)

4.9/5

(86)

Question 52

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

(True/False)

4.9/5

(68)

Question 53

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

(True/False)

4.9/5

(81)

Question 54

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.

(Essay)

4.8/5

(86)

Question 55

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

(Multiple Choice)

4.9/5

(73)

Question 56

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

(True/False)

4.8/5

(83)

Question 57

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

(Multiple Choice)

4.8/5

(93)

Question 58

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

(Multiple Choice)

4.9/5

(75)

Question 59

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

(True/False)

4.8/5

(74)

Question 60

Showing 41 - 60 of 105

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?

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.

AND,OR,and NOT are called ____________________ operators.

____ text often provides a strong visual appeal.

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

Introduction to Technology

Office 365 Essentials

Office 2013 and Windows 8 Essential Concepts and Skills

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Filters