Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

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.

Accepted Answer

freeze

Question 3

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! D

Question 4

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.

Accepted Answer

A) True 
 B)False

Question 5

Match between columns
                        Premises: Returns a number that corresponds to the system date and time beginning with December 31, 1899.

Accepted Answer

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

Question 6

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

Accepted Answer

The answer of ____________________ are values in cells that can...

Question 7

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 8

If you drag the fill handle to the left or up, Excel will increment the series rather than decrement the series.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is a valid rotation (counterclockwise)value for text in a cell in the Alignment sheet in the Format Cells dialog?

Accepted Answer

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

Question 10

If you click a 3-D Pie chart so that all of the slices are selected, you can drag one of the slices to explode it, leaving the remaining slices unexploded.

Accepted Answer

A) True 
 B)False

Question 11

Error messages in Excel always begin with a(n)& character.

Accepted Answer

A) True 
 B)False

Question 12

Cell references in a formula are called ____.

Accepted Answer

A)  assumptions
B)  values
C)  numbers
D)  content

Question 13

To assign a Currency style with a floating dollar sign, use the ____________________ dialog rather than the Accounting Style button in the Number group on the Home tab, which assigns a fixed dollar sign.

Accepted Answer

The answer of To assign a Currency style with a...

Question 14

When you change a value on which a chart is dependent, Excel immediately ____________________ the chart.

Accepted Answer

The answer of When you change a value on which...

Question 15

Which of the following are formatting symbols?

Accepted Answer

A)  dollar sign ($) 
B)  comma (,) 
C)  pound sign (#) 
D)  percent sign (%)

Question 16

The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

Accepted Answer

A) True 
 B)False

Question 17

You should use a ____ chart to show the relationship or proportion of parts to a whole.

Accepted Answer

A)  column
B)  bar
C)  line
D)  pie

Question 18

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

Accepted Answer

A)  Format Same As Above
B)  Undo Formatting
C)  Format Same As Below
D)  Clear Formatting

Question 19

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

Question 20

Match between columns
                        Premises: Fills a destination area using the format of the source area; no content is copied.

Accepted Answer

The Answer of #NAME? and IF function and Fill Series is...

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

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

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.

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.

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.

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

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

If you drag the fill handle to the left or up, Excel will increment the series rather than decrement the series.

Which of the following is a valid rotation (counterclockwise) value for text in a cell in the Alignment sheet in the Format Cells dialog?

If you click a 3-D Pie chart so that all of the slices are selected, you can drag one of the slices to explode it, leaving the remaining slices unexploded.

Error messages in Excel always begin with a(n)& character.

Cell references in a formula are called ____.

To assign a Currency style with a floating dollar sign, use the ____________________ dialog rather than the Accounting Style button in the Number group on the Home tab, which assigns a fixed dollar sign.

When you change a value on which a chart is dependent, Excel immediately ____________________ the chart.

Which of the following are formatting symbols?

The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

You should use a ____ chart to show the relationship or proportion of parts to a whole.

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

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

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