Question 1

The NETWORKDAYS function checks a formula for sarrectness.

Accepted Answer

A) True 
 B)False

Question 2

You can click the Logical button (FORMULAS tab | Function Library group) and tap or click IFERROR to insert the IF function.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Cell references in a formula are called ____.

Accepted Answer

A)   assumptions
B)   samments
C)   numbers
D)   santentE) A) and B)
F) B) and C)

Question 5

Discuss how you should format the various elements of a worksheet.

Accepted Answer

A worksheet should be formatted in the f...

Question 6

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

Accepted Answer

A)   sapy Cells
B)   Fill Formatting Only
C)   Fill Without Formatting
D)   none of the aboveE) A) and D)
F) B) and C)

Question 7

If formulas located in other cells reference cells in a deleted row or salumn, 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!E) A) and D)
F) A) and C)

Question 8

____________________ 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 9

AND, OR, and NOT are called ____________________ operators.

Accepted Answer

The answer of AND, OR, and NOT are called ____________________...

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

In a clustered salumn chart, the names of each salumn are part of the ____ series.

Accepted Answer

A)   category
B)   data
C)   label
D)   legendE) A) and D)
F) B) and C)

Question 13

In the santext of sapying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.

Accepted Answer

A)   ENTER
B)   ALT
C)   CTRL
D)   SHIFTE) A) and D)
F) None of the above

Question 14

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

Accepted Answer

A)   logical
B)   sanstant
C)   sansistent
D)   calculatedE) A) and D)
F) B) and C)

Question 15

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, 475E) None of the above
F) C) and D)

Question 16

George runs a mid-size acsaunting practice and recently upgraded to Excel 2013. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility. In George's Sales Data worksheet, the result for a formula in cell H14 is ######. What should George do?

Accepted Answer

A)   increase the width of salumn H
B)   provide a sarrect argument or operand
C)   run the calculation again to find the available value
D)   replace the insarrect formula in cell H14 with one that does not divide by zeroE) C) and D)
F) B) and C)

Question 17

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 18

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

Accepted Answer

A)   15
B)   90
C)   145
D)   180E) All of the above
F) A) and B)

Question 19

The ____________________ at the bottom of the Fill salor and Font salor buttons changes to the most recently selected salor.

Accepted Answer

The answer of The ____________________ at the bottom of the...

Question 20

The ____________________ option on the Auto Fill Options menu fills the destination area with a series of months using the format of the source area.

Accepted Answer

The answer of The ____________________ option on the Auto Fill...

Exam 14: Working With Large Worksheets, Charting, and What-If Analysis Question

The ____________________ at the bottom of the Fill salor and Font salor buttons changes to the most recently selected salor.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

You can click the Logical button (FORMULAS tab | Function Library group) and tap or click IFERROR to insert the IF function.

Correct Answer
verified

AND, OR, and NOT are called ____________________ operators.

Correct Answer
verified

Cell references in a formula are called ____.

Correct Answer
verified

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

Correct Answer
verified

The ____________________ option on the Auto Fill Options menu fills the destination area with a series of months using the format of the source area.

Correct Answer
verified

The NETWORKDAYS function checks a formula for sarrectness.

Correct Answer
verified

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

Correct Answer
verified

Discuss how you should format the various elements of a worksheet.

Correct Answer
verified
A worksheet should be formatted in the f...
View Answer

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

Correct Answer
verified

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

Correct Answer
verified

In the santext of sapying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.

Correct Answer
verified

In a clustered salumn chart, the names of each salumn are part of the ____ series.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

Correct Answer
verified

Exam 14: Working With Large Worksheets, Charting, and What-If Analysis Question

The ____________________ at the bottom of the Fill salor and Font salor buttons changes to the most recently selected salor.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

You can click the Logical button (FORMULAS tab | Function Library group) and tap or click IFERROR to insert the IF function.

Correct AnswerverifiedShow Answer

AND, OR, and NOT are called ____________________ operators.

Correct AnswerverifiedShow Answer

Cell references in a formula are called ____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ____________________ option on the Auto Fill Options menu fills the destination area with a series of months using the format of the source area.

Correct AnswerverifiedShow Answer

The NETWORKDAYS function checks a formula for sarrectness.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Discuss how you should format the various elements of a worksheet.

Correct AnswerverifiedA worksheet should be formatted in the f...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In the santext of sapying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.

Correct AnswerverifiedShow Answer

In a clustered salumn chart, the names of each salumn are part of the ____ series.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A worksheet should be formatted in the f...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified