Question 1

Always take time to check the ____________________ of a worksheet before submitting it to your supervisor.

Accepted Answer

The answer of Always take time to check the ____________________...

Question 2

Match between columns
                        Premises: Copies a formula.

Accepted Answer

The Answer of = and COMMAND-1 and COMMAND-C and #REF! is...

Question 3

To use Range Finder to verify that a formula contains the intended cell references, click the cell with the formula you want to check.

Accepted Answer

A) True 
 B)False

Question 4

Formatting that appears only when the value in a cell meets conditions that you specify is called conditional formatting.

Accepted Answer

A) True 
 B)False

Question 5

Excel includes a(n)____________________ you can use to check a worksheet for spelling errors.

Accepted Answer

The answer of Excel includes a(n)____________________ you can use to...

Question 6

In the accompanying figure, the topmost numerical value in the column labeled Hourly Pay Rate is formatted with a ____ dollar sign.

Accepted Answer

A) fixed 
B) formatted 
C) floating 
D) none of the above 
A) fixed 
B) formatted 
C) floating 
D) none of the above

Question 7

A(n)____________________ is a dot on the screen that contains a color.

Accepted Answer

The answer of A(n)____________________ is a dot on the screen...

Question 8

A ____ cell in Excel has a numerical value of zero.

Accepted Answer

A) blank 
B) formatted 
C) copied 
D) filled 
A) blank 
B) formatted 
C) copied 
D) filled

Question 9

Briefly discuss displaying the formulas version of a worksheet.

Accepted Answer

The values version of the worksheet show

Question 10

The most popular background color is ____.

Accepted Answer

A) blue 
B) white 
C) red 
D) yellow 
A) blue 
B) white 
C) red 
D) yellow

Question 11

To copy cell contents, you can select the cell and then press the ____ keys.

Accepted Answer

A) COMMAND-V 
B) COMMAND-X 
C) COMMAND-B 
D) COMMAND-C 
A) COMMAND-V 
B) COMMAND-X 
C) COMMAND-B 
D) COMMAND-C

Question 12

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

Accepted Answer

A) True 
 B)False

Question 13

The arithmetic operator, ^, directs Excel to perform the division operation.

Accepted Answer

A) True 
 B)False

Question 14

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

Accepted Answer

A) 40 
B) 26 
C) 48 
D) 13 
A) 40 
B) 26 
C) 48 
D) 13

Question 15

Anna is a competitive runner.She wants to improve her performance and decides to keep track of data for six months to determine if the time of day or year she runs affects her performance.Her worksheet contains the following data: start and end time, total time, and distance.After three months, Anna wants to the know the average distance she runs.What should she do to calculate the average distance?

Accepted Answer

A) Enter the text =av in a cell at the end of the distance data; then select the AVERAGE function from the Formula AutoComplete list and then enter the function's argument. 
B) Enter the text =ms in a cell at the end of the distance data; then select the MAX function from the Formula AutoComplete list and then enter the function's argument. 
C) Enter the text =function in a cell at the end of the distance data; then select the AVERAGE function from the AutoFunction list and then enter the function's argument. 
D) Enter the text =su at the end of the data in the Distance column; then select the SUM function from the Select Function list and then enter the function's argument. 
A) Enter the text =av in a cell at the end of the distance data; then select the AVERAGE function from the Formula AutoComplete list and then enter the function's argument. 
B) Enter the text =ms in a cell at the end of the distance data; then select the MAX function from the Formula AutoComplete list and then enter the function's argument. 
C) Enter the text =function in a cell at the end of the distance data; then select the AVERAGE function from the AutoFunction list and then enter the function's argument. 
D) Enter the text =su at the end of the data in the Distance column; then select the SUM function from the Select Function list and then enter the function's argument.

Question 16

Point mode allows you to select cells for use in a formula by using the keyboard.

Accepted Answer

A) True 
 B)False

Question 17

Briefly discuss the order of operations.

Accepted Answer

When more than one arithmetic operator i

Question 18

Which of the following are valid formulas?

Accepted Answer

A) =3 ^ 4 
B) =H3/H11 
C) =11+9 
D) =22-F15 
A) =3 ^ 4 
B) =H3/H11 
C) =11+9 
D) =22-F15

Question 19

The use of a fill color in a cell or range of cells sets off the cell or range from other portions of the worksheet and provides visual impact to draw the user's eye toward the cell or range.

Accepted Answer

A) True 
 B)False

Question 20

Cooler colors tend to reach toward the reader.

Accepted Answer

A) True 
 B)False

Always take time to check the ____________________ of a worksheet before submitting it to your supervisor.

To use Range Finder to verify that a formula contains the intended cell references, click the cell with the formula you want to check.

Formatting that appears only when the value in a cell meets conditions that you specify is called conditional formatting.

Excel includes a(n)____________________ you can use to check a worksheet for spelling errors.

In the accompanying figure, the topmost numerical value in the column labeled Hourly Pay Rate is formatted with a ____ dollar sign.

A(n)____________________ is a dot on the screen that contains a color.

A ____ cell in Excel has a numerical value of zero.

Briefly discuss displaying the formulas version of a worksheet.

The most popular background color is ____.

To copy cell contents, you can select the cell and then press the ____ keys.

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

The arithmetic operator, ^, directs Excel to perform the division operation.

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

Point mode allows you to select cells for use in a formula by using the keyboard.

Briefly discuss the order of operations.

Which of the following are valid formulas?

The use of a fill color in a cell or range of cells sets off the cell or range from other portions of the worksheet and provides visual impact to draw the user's eye toward the cell or range.

Cooler colors tend to reach toward the reader.

Introduction to Computers

Microsoft Office 2011 and Mac Os X Lion

Excel: Creating a Worksheet and an Embedded Chart

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

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 4: Excel: Formulas, Functions, and Formatting

Always take time to check the ____________________ of a worksheet before submitting it to your supervisor.

To use Range Finder to verify that a formula contains the intended cell references, click the cell with the formula you want to check.

Formatting that appears only when the value in a cell meets conditions that you specify is called conditional formatting.

Excel includes a(n)____________________ you can use to check a worksheet for spelling errors.

In the accompanying figure, the topmost numerical value in the column labeled Hourly Pay Rate is formatted with a ____ dollar sign.

A(n)____________________ is a dot on the screen that contains a color.

A ____ cell in Excel has a numerical value of zero.

Briefly discuss displaying the formulas version of a worksheet.

The most popular background color is ____.

To copy cell contents, you can select the cell and then press the ____ keys.

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

The arithmetic operator, ^, directs Excel to perform the division operation.

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

Point mode allows you to select cells for use in a formula by using the keyboard.

Briefly discuss the order of operations.

Which of the following are valid formulas?

The use of a fill color in a cell or range of cells sets off the cell or range from other portions of the worksheet and provides visual impact to draw the user's eye toward the cell or range.

Cooler colors tend to reach toward the reader.

Introduction to Computers

Microsoft Office 2011 and Mac Os X Lion

Excel: Creating a Worksheet and an Embedded Chart

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

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