Match between columns Premises: Determines the value of a cell on which the formula depends.

The Answer of Fill Series and absolute cell referencing and is...

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

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the _____ error message.

(Multiple Choice)

4.9/5

(39)

Question 21

The path to the Format Painter button is _____.

(Multiple Choice)

4.7/5

(31)

Question 22

A(n)_____ is a separate sheet in a workbook that contains only a chart.

(Multiple Choice)

4.8/5

(42)

Question 23

With a three-dimensional chart, you can change the view to better show the section of the chart you are trying to emphasize.

(True/False)

4.9/5

(31)

Question 24

When you first enter text, its angle is zero degrees (0), and it reads from left to right in a cell.Text in a cell can be rotated counterclockwise by entering a number between _ and _ in the Alignment sheet in the Format Cells dialog box.

(Multiple Choice)

4.8/5

(41)

Question 25

When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip containing the name of the item.

(True/False)

4.8/5

(38)

Question 26

Which of the following is not a valid format symbol?

(Multiple Choice)

4.9/5

(32)

Question 27

Identify the letter of the choice that best matches the phrase or definition.

Premises:

Keeps a cell reference constant when copying a formula or function.

Responses:

Keep Source Formatting

Fill Formatting Only

NOW function

Correct Answer:

Verified

Keeps a cell reference constant when copying a formula or function.

(Matching)

4.8/5

(29)

Question 28

Bea is the best pie baker around.She has decided to go into business and takes a survey in her town to find out what types of pies are favorites.She decides to record her data in a worksheet she can present to the bank when she seeks a loan for her business startup costs.Bea wants to add a 3-D Pie chart to her workbook in which each slice represents the popularity of different types of pies she plans to sell.Bea finished adding the results of her survey to a worksheet in her new workbook, including the number of people who voted for each type of pie.In a Pie chart that indicates the popularity of each type of pie, which statement is true about the number of votes for each type of pie, called the data series?

(Multiple Choice)

4.7/5

(34)

Question 29

When Excel draws a(n)_________________________ chart, it always positions the chart so that one of the dividing lines between two slices is a straight line pointing to 12 o'clock (or 0 degrees).

(Short Answer)

4.9/5

(32)

Question 30

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

(Short Answer)

4.9/5

(38)

Question 31

Excel includes four types of Sparkline charts: Line, Column, Win/Lose, and Stock.

(True/False)

4.9/5

(43)

Question 32

Which comparison operator means "not equal to"?

(Multiple Choice)

4.8/5

(34)

Question 33

Which of the following patterns extends the fill series to 575, 550, 525?

(Multiple Choice)

5.0/5

(42)

Question 34

If worksheet, column, and row titles are frozen above and to the left of cell B13, B13 can be selected by pressing CTRL+HOME.

(True/False)

4.8/5

(38)

Question 35

You can select nonadjacent ranges using the SHIFT key.

(True/False)

4.8/5

(31)

Question 36

A date stamp shows the date a workbook, report, or other document was created or the period it represents.

(True/False)

4.8/5

(40)

Question 37

Identify the letter of the choice that best matches the phrase or definition.

Premises:

Determines the value of a cell on which the formula depends.

Responses:

Fill Series

absolute cell referencing

NOW function

Correct Answer:

Verified

Determines the value of a cell on which the formula depends.

(Matching)

4.9/5

(32)

Question 38

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

(Short Answer)

4.8/5

(49)

Question 39

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

(True/False)

4.7/5

(29)

Question 40

Showing 21 - 40 of 112

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the _____ error message.

The path to the Format Painter button is _____.

A(n)_____ is a separate sheet in a workbook that contains only a chart.

With a three-dimensional chart, you can change the view to better show the section of the chart you are trying to emphasize.

When you first enter text, its angle is zero degrees (0), and it reads from left to right in a cell.Text in a cell can be rotated counterclockwise by entering a number between _ and _ in the Alignment sheet in the Format Cells dialog box.

When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip containing the name of the item.

Which of the following is not a valid format symbol?

When Excel draws a(n)_________________________ chart, it always positions the chart so that one of the dividing lines between two slices is a straight line pointing to 12 o'clock (or 0 degrees).

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

Excel includes four types of Sparkline charts: Line, Column, Win/Lose, and Stock.

Which comparison operator means "not equal to"?

Which of the following patterns extends the fill series to 575, 550, 525?

If worksheet, column, and row titles are frozen above and to the left of cell B13, B13 can be selected by pressing CTRL+HOME.

You can select nonadjacent ranges using the SHIFT key.

A date stamp shows the date a workbook, report, or other document was created or the period it represents.

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

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

Microsoft Windows Internet Explorer 8 : Introduction to Internet Explorer

Office 2010 and Windows 7 : essential concepts and skills

Access : Databases and Database Objects : an Introduction

Access: Querying a Database

Discovering Computers: Introduction to Computers

Discovering Computers: the Internet and World Wide Web

Discovering Computers: Application Software

Discovering Computers: Operating Systems and Utility Programs

Discovering Computers: Computer Security and Safety, Ethics, and Privacy

Excel : Creating a Worksheet and an Embedded Chart

Excel : Formulas, Functions, and Formatting

Powerpoint : Creating and Editing a Presentation With Clip Art

Powerpoint : Enhancing a Presentation With Pictures, Shapes and Wordart

Powerpoint : Reusing a Presentation With Adding Media

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

Word: Creating a Research Paper With Citations and References

Word: Creating a Business Letter With a Letterhead and Table

Filters

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

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the _____ error message.

The path to the Format Painter button is _____.

A(n)_____ is a separate sheet in a workbook that contains only a chart.

With a three-dimensional chart, you can change the view to better show the section of the chart you are trying to emphasize.

When you first enter text, its angle is zero degrees (0), and it reads from left to right in a cell.Text in a cell can be rotated counterclockwise by entering a number between _____ and _____ in the Alignment sheet in the Format Cells dialog box.

When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip containing the name of the item.

Which of the following is not a valid format symbol?

When Excel draws a(n)_________________________ chart, it always positions the chart so that one of the dividing lines between two slices is a straight line pointing to 12 o'clock (or 0 degrees).

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

Excel includes four types of Sparkline charts: Line, Column, Win/Lose, and Stock.

Which comparison operator means "not equal to"?

Which of the following patterns extends the fill series to 575, 550, 525?

If worksheet, column, and row titles are frozen above and to the left of cell B13, B13 can be selected by pressing CTRL+HOME.

You can select nonadjacent ranges using the SHIFT key.

A date stamp shows the date a workbook, report, or other document was created or the period it represents.

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

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

Microsoft Windows Internet Explorer 8 : Introduction to Internet Explorer

Office 2010 and Windows 7 : essential concepts and skills

Access : Databases and Database Objects : an Introduction

Access: Querying a Database

Discovering Computers: Introduction to Computers

Discovering Computers: the Internet and World Wide Web

Discovering Computers: Application Software

Discovering Computers: Operating Systems and Utility Programs

Discovering Computers: Computer Security and Safety, Ethics, and Privacy

Excel : Creating a Worksheet and an Embedded Chart

Excel : Formulas, Functions, and Formatting

Powerpoint : Creating and Editing a Presentation With Clip Art

Powerpoint : Enhancing a Presentation With Pictures, Shapes and Wordart

Powerpoint : Reusing a Presentation With Adding Media

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

Word: Creating a Research Paper With Citations and References

Word: Creating a Business Letter With a Letterhead and Table

Filters

When you first enter text, its angle is zero degrees (0), and it reads from left to right in a cell.Text in a cell can be rotated counterclockwise by entering a number between _ and _ in the Alignment sheet in the Format Cells dialog box.