Question 1

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

Accepted Answer

A) True 
 B)False

Question 2

Match between columns
                        Premises: Shows the relationship or proportion of parts to a whole.

Accepted Answer

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

Question 3

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

Accepted Answer

A) IF 
B) NOW 
C) AND 
D) OR 
A) IF 
B) NOW 
C) AND 
D) OR

Question 4

You can ensure correctness in your ____________________ by carefully checking them using Range Finder.

Accepted Answer

The answer of You can ensure correctness in your ____________________...

Question 5

A(n)____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

Accepted Answer

A) included 
B) other 
C) nested 
D) duplicate 
A) included 
B) other 
C) nested 
D) duplicate

Question 6

Match between columns
                        Premises: Assigns a value to a cell based on a logical test.

Accepted Answer

The Answer of #NAME? and Keep Source Formatting and absolute is...

Question 7

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 8

____ refers to cells not wide enough to display the entire entry.

Accepted Answer

A) ##### 
B) &&&&& 
C) $$$$$ 
D) +++++ 
A) ##### 
B) &&&&& 
C) $$$$$ 
D) +++++

Question 9

In the accompanying figure, the split double arrow mouse pointer ____.

Accepted Answer

A) indicates a hidden column 
B) allows text to be entered at that location 
C) is the result of moving the mouse pointer to the boundary between column heading A and column heading B 
D) indicates the proposed width of column A 
A) indicates a hidden column 
B) allows text to be entered at that location 
C) is the result of moving the mouse pointer to the boundary between column heading A and column heading B 
D) indicates the proposed width of column A

Question 10

In the accompanying figure, the formula in cell B14 contains an absolute reference.

Accepted Answer

A) True 
 B)False

Question 11

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

Accepted Answer

A) Click 
B) Press 
C) Double-click 
D) Triple-click 
A) Click 
B) Press 
C) Double-click 
D) Triple-click

Question 12

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 
A) 650, 600 
B) 625, 600 
C) 560, 580 
D) 500, 475

Question 13

George runs a mid-size accounting practice and recently upgraded to Excel 2011.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.If sales reach a certain amount by the end of April, George will purchase a desk, chair, computer, and software upgrade for the receptionist.Otherwise, George will just purchase the desk and chair.How can George determine the best action to take using a Sales Data worksheet?

Accepted Answer

A) Copy and paste all his Sales data formulas with relative references 
B) Add an IF function formula to his Sales data worksheet 
C) Add the NOW function formula to his Sales data worksheet 
D) Copy and paste all his Sales data formulas with absolute references 
A) Copy and paste all his Sales data formulas with relative references 
B) Add an IF function formula to his Sales data worksheet 
C) Add the NOW function formula to his Sales data worksheet 
D) Copy and paste all his Sales data formulas with absolute references

Question 14

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

Accepted Answer

A) Goal 
B) Formula 
C) Option 
D) Function 
A) Goal 
B) Formula 
C) Option 
D) Function

Question 15

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

Accepted Answer

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

Question 16

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

Accepted Answer

A) SYSDATE 
B) NOW 
C) DATETIME 
D) CURRENT 
A) SYSDATE 
B) NOW 
C) DATETIME 
D) CURRENT

Question 17

Panes created using the vertical split bar scroll together horizontally .

Accepted Answer

A) True 
 B)False

Question 18

A(n)____________________ table should be diminished in its formatting so that it does not distract from the main calculations and data in the worksheet.

Accepted Answer

The answer of A(n)____________________ table should be diminished in its...

Question 19

The arguments in an IF function are ____.

Accepted Answer

A) logical_test 
B) value_if_true 
C) value_if_true_false 
D) value_if_false 
A) logical_test 
B) value_if_true 
C) value_if_true_false 
D) value_if_false

Question 20

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

Accepted Answer

A) Copy Cells 
B) Fill Formatting Only 
C) Fill Without Formatting 
D) none of the above 
A) Copy Cells 
B) Fill Formatting Only 
C) Fill Without Formatting 
D) none of the above

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

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

You can ensure correctness in your ____________________ by carefully checking them using Range Finder.

A(n)____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

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

____ refers to cells not wide enough to display the entire entry.

In the accompanying figure, the split double arrow mouse pointer ____.

In the accompanying figure, the formula in cell B14 contains an absolute reference.

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

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

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

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

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

Panes created using the vertical split bar scroll together horizontally .

A(n)____________________ table should be diminished in its formatting so that it does not distract from the main calculations and data in the worksheet.

The arguments in an IF function are ____.

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

Introduction to Computers

Microsoft Office 2011 and Mac Os X Lion

Excel: Creating a Worksheet and an Embedded Chart

Excel: Formulas, Functions, and Formatting

Outlook: Managing E-Mail Messages With Outlook

Outlook: Managing Calendars

Powerpoint: Creating and Editing a Presentation With Clip Art

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

Powerpoint: Reusing a Presentation and Adding Media

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

Word: Creating a Research Paper With Citations and References

Filters

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

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

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

You can ensure correctness in your ____________________ by carefully checking them using Range Finder.

A(n)____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

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

____ refers to cells not wide enough to display the entire entry.

In the accompanying figure, the split double arrow mouse pointer ____.

In the accompanying figure, the formula in cell B14 contains an absolute reference.

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

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

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

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

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

Panes created using the vertical split bar scroll together horizontally .

A(n)____________________ table should be diminished in its formatting so that it does not distract from the main calculations and data in the worksheet.

The arguments in an IF function are ____.

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

Introduction to Computers

Microsoft Office 2011 and Mac Os X Lion

Excel: Creating a Worksheet and an Embedded Chart

Excel: Formulas, Functions, and Formatting

Outlook: Managing E-Mail Messages With Outlook

Outlook: Managing Calendars

Powerpoint: Creating and Editing a Presentation With Clip Art

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

Powerpoint: Reusing a Presentation and Adding Media

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

Word: Creating a Research Paper With Citations and References

Filters