Question 1

____________________ means that the width of a column will be increased or decreased so the widest entry will fit in the column.

Accepted Answer

The answer of ____________________ means that the width of a...

Question 2

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.Now Anna wants to know the longest total time she has run.By looking at the total time values, she finds the longest total time to be 54 minutes.Instead of manually entering that value in a cell below the total time data, Anna decides to use the MAX function to determine the longest total time.Why did Anna prefer to use the MAX function?

Accepted Answer

A) She believes that 54 minutes is her best running time. 
B) The MAX function recalculates the highest value each time a new value is entered into the worksheet. 
C) She believes that 54 minutes is not her best running time. 
D) The MAX function provides a constant value that will not change for this cell when a new value is entered into the worksheet. 
A) She believes that 54 minutes is her best running time. 
B) The MAX function recalculates the highest value each time a new value is entered into the worksheet. 
C) She believes that 54 minutes is not her best running time. 
D) The MAX function provides a constant value that will not change for this cell when a new value is entered into the worksheet.

Question 3

To paste copied cell contents, you can press the ____ keys.

Accepted Answer

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

Question 4

____________________ view shows the worksheet divided into pages.

Accepted Answer

The answer of ____________________ view shows the worksheet divided into...

Question 5

Point mode allows you to ____, as shown in the accompanying figure.

Accepted Answer

A) select cells for use in a formula using the keyboard 
B) select a function from the Sum button list 
C) select cells for use in a formula using the mouse 
D) edit cell contents directly in the cell 
A) select cells for use in a formula using the keyboard 
B) select a function from the Sum button list 
C) select cells for use in a formula using the mouse 
D) edit cell contents directly in the cell

Question 6

The ____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.

Accepted Answer

A) Comma style format 
B) Accounting number format 
C) Percent style format 
D) Currency style format 
A) Comma style format 
B) Accounting number format 
C) Percent style format 
D) Currency style format

Question 7

Which of the following happens when you enter the formula =G15 into a cell?

Accepted Answer

A) Excel recalculates all formulas in the worksheet 
B) Excel assigns the sum of the values in the previous 15 cells to the active cell 
C) Excel assigns the value in cell G15 to the active cell 
D) Nothing; =G15 is an invalid formula 
A) Excel recalculates all formulas in the worksheet 
B) Excel assigns the sum of the values in the previous 15 cells to the active cell 
C) Excel assigns the value in cell G15 to the active cell 
D) Nothing; =G15 is an invalid formula

Question 8

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

Accepted Answer

A) True 
 B)False

Question 9

The Accounting number format assigns a(n)floating dollar sign.

Accepted Answer

A) True 
 B)False

Question 10

The ____ Options button lists error-checking options following the assignment of an invalid formula to a cell.

Accepted Answer

A) Find Error 
B) Explain Error 
C) Fix Error 
D) Trace Error 
A) Find Error 
B) Explain Error 
C) Fix Error 
D) Trace Error

Question 11

If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.

Accepted Answer

A) 7 
B) 8 
C) 9 
D) 10 
A) 7 
B) 8 
C) 9 
D) 10

Question 12

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

Accepted Answer

A) True 
 B)False

Question 13

A floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

Accepted Answer

A) True 
 B)False

Question 14

Cooler colors (red and orange)tend to pull away from the reader.

Accepted Answer

A) True 
 B)False

Question 15

In the order of operations, the last operation Excel performs is ____________________.

Accepted Answer

The answer of In the order of operations, the last...

Question 16

You can click the Page Layout View button in the lower left of the ____________________ to switch to Page Layout view.

Accepted Answer

The answer of You can click the Page Layout View...

Question 17

Match between columns
                        Premises: Starts a new line in a cell.

Accepted Answer

The Answer of COMMAND-1 and COMMAND-C and = and CONTROL-SHIFT-$ is...

Question 18

Match between columns
                        Premises: Opens the Format Cells dialog box.

Accepted Answer

The Answer of CONTROL-SHIFT-% and CONTROL-SHIFT-$ and COMMAND-= and #REF! is...

Question 19

The ____ function displays the highest value in a range.

Accepted Answer

A) MIN 
B) SUM 
C) MAX 
D) AVERAGE 
A) MIN 
B) SUM 
C) MAX 
D) AVERAGE

Question 20

To start a new line in a cell, press the ____ keys.

Accepted Answer

A) CONTROL-RETURN 
B) TAB-RETURN 
C) CONTROL-OPTION-RETURN 
D) SHIFT-RETURN 
A) CONTROL-RETURN 
B) TAB-RETURN 
C) CONTROL-OPTION-RETURN 
D) SHIFT-RETURN

____________________ means that the width of a column will be increased or decreased so the widest entry will fit in the column.

To paste copied cell contents, you can press the ____ keys.

____________________ view shows the worksheet divided into pages.

Point mode allows you to ____, as shown in the accompanying figure.

The ____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.

Which of the following happens when you enter the formula =G15 into a cell?

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

The Accounting number format assigns a(n)floating dollar sign.

The ____ Options button lists error-checking options following the assignment of an invalid formula to a cell.

If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

A floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

Cooler colors (red and orange)tend to pull away from the reader.

In the order of operations, the last operation Excel performs is ____________________.

You can click the Page Layout View button in the lower left of the ____________________ to switch to Page Layout view.

The ____ function displays the highest value in a range.

To start a new line in a cell, press the ____ keys.

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

____________________ means that the width of a column will be increased or decreased so the widest entry will fit in the column.

To paste copied cell contents, you can press the ____ keys.

____________________ view shows the worksheet divided into pages.

Point mode allows you to ____, as shown in the accompanying figure.

The ____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.

Which of the following happens when you enter the formula =G15 into a cell?

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

The Accounting number format assigns a(n)floating dollar sign.

The ____ Options button lists error-checking options following the assignment of an invalid formula to a cell.

If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

A floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

Cooler colors (red and orange)tend to pull away from the reader.

In the order of operations, the last operation Excel performs is ____________________.

You can click the Page Layout View button in the lower left of the ____________________ to switch to Page Layout view.

The ____ function displays the highest value in a range.

To start a new line in a cell, press the ____ keys.

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