Question 1

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.

Accepted Answer

A) #NULL! 
B) #DIV/0! 
C) #N/A 
D) #REF!

Question 2

The path to the Format Painter button is _____.

Accepted Answer

A) (Home tab | Number group) 
B) (Home tab | Clipboard group) 
C) (Home tab | Painting group) 
D) (Home tab | Font group)

Question 3

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

Accepted Answer

A) worksheet 
B) dialog box 
C) chart sheet 
D) range

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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.

Accepted Answer

A) 45 
B) 1 
C) 90 
D) 60

Question 6

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.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is not a valid format symbol?

Accepted Answer

A) semi-colon (;) 
B) percent sign (%) 
C) dollar sign ($) 
D) comma (,)

Question 8

Match between columns
                        Premises: Keeps a cell reference constant when copying a formula or function.

Accepted Answer

The Answer of Keep Source Formatting and Fill Formatting Only is...

Question 9

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?

Accepted Answer

A) The number of votes determines how many slices are in the pie 
B) The votes determine the color of each slice 
C) The number of votes determines the sizes of the slices 
D) The number of votes determines whether the chart is on a separate sheet

Question 10

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).

Accepted Answer

The answer of When Excel draws a(n)_________________________ chart, it always...

Question 11

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

Accepted Answer

The answer of The _________________________ function is useful when you...

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Which comparison operator means "not equal to"?

Accepted Answer

A)  
C) < 
D)  $ \neq $

Question 14

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

Accepted Answer

A) 650, 600 
B) 625, 600 
C) 560, 580 
D) 500, 475

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

You can select nonadjacent ranges using the SHIFT key.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

The answer of A sensitivity analysis is another name for...

Question 20

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

Accepted Answer

A) True 
 B)False

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?

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

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.

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

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.

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?

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

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.

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

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.

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.