Question 1

Match between columns
                        Premises: Finding and correcting errors in the worksheet.

Accepted Answer

The Answer of arguments and smart tag and spell checker is...

Question 2

The ____________________ of a worksheet is the version that shows the results of the formulas entered, rather than the actual formulas.

Accepted Answer

The answer of The ____________________ of a worksheet is the...

Question 3

Critical Thinking Questions Case 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 affects performance numbers. On a single worksheet, she labels the columns B through E as follows: (B)Start Time, (C)End Time, (D)Total Time, (E)Distance. The rows are labeled: (2)Date, (3)Maximum, (4)Average, (5)Minimum. After three months, Anna wants to know the longest total time she has run, as listed in the Total Time column. By looking at the values in the column, she finds the longest total time to be 54 minutes. Instead of manually entering that value in cell D3 (Maximum Total Time), Anna decides to use the MAX function to determine the value rather than manually entering the 54 minutes. Why did Anna prefer to use the MAX function?

Accepted Answer

Anna preferred to use the MAX function because it recalculates the highest value each time a new value is entered into the worksheet, ensuring that the maximum total time is always up to date without manually having to update the cell.

Question 4

Match between columns
                        Premises: Values that are used with a function.

Accepted Answer

The Answer of Web query and debugging and arguments and is...

Question 5

Critical Thinking Questions Case 1 Leo, owner of Leo's Bread Company, has recently acquired Excel 2007. He would like to set up a workbook to track sales of different types of breads to determine which types are the most popular among customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo uses the Accounting Number Format with the sales numbers he enters into the cells. After Leo enters the sales numbers into the cells, he decides he does not want the fixed dollar sign to appear on the far left of the cell, separated by white spaces from the actual value. He would prefer that the dollar sign appear immediately to the left of the first digit of the number. To format the location of the dollar sign, which category on the Number tab in the Format Cells dialog box would he select?

Accepted Answer

Leo should select the Currency category on the Number tab in the Format Cells dialog box to format the location of the dollar sign immediately to the left of the first digit of the number. This will remove the white space that appears with the Accounting Number Format.

Question 6

The TOTAL function sums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range.

Accepted Answer

The AVERAGE function divides the sum of numbers in the specified range by the number of nonzero cells in the range. The TOTAL function does not exist in Excel.

Question 7

Discuss the relationship of debugging and displaying or printing the formulas version of a worksheet. Also describe the difference between the formulas version and the values version.

Accepted Answer

The answer of Discuss the relationship of debugging and displaying...

Question 8

The HIGHVALUE function displays the highest value in a range.

Accepted Answer

The MAX function is used to display the highest value in a range, not HIGHVALUE.

Question 9

A fixed dollar sign appears to the far left in the cell, often with spaces between it and the first digit; whereas a moving dollar sign appears immediately to the left of the first digit with no spaces.

Accepted Answer

The answer of A fixed dollar sign appears to the...

Question 10

The AVERAGE function displays the lowest value in a range.

Accepted Answer

The AVERAGE function calculates the arithmetic mean of a range of values. It does not display the lowest value in the range.

Question 11

Critical Thinking Questions Case 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 affects performance numbers. On a single worksheet, she labels the columns B through E as follows: (B)Start Time, (C)End Time, (D)Total Time, (E)Distance. The rows are labeled: (2)Date, (3)Maximum, (4)Average, (5)Minimum. When she sets up the worksheet, Anna wants to the know the average distance she runs. What should she do in cell E4 to determine the average distance?

Accepted Answer

To determine the average distance, Anna should use the AVERAGE function in Excel. By entering "=av" in cell E4 and then selecting the AVERAGE function from the AutoComplete list, she can then enter the appropriate cell range that contains the distances she wants to average. This method correctly calculates the average distance run.

Question 12

Excel's strength lies in its handling of numbers and the presentation of them. Discuss some of the considerations to keep in mind when formatting numbers. In the discussion, include the terms fixed dollar sign, floating dollar sign, currency, and percent.

Accepted Answer

The answer of Excel's strength lies in its handling of...

Question 13

The ____________________ of a worksheet is the version that shows the actual formulas entered, rather than the resulting values.

Accepted Answer

The answer of The ____________________ of a worksheet is the...

Question 14

A theme is a predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook.

Accepted Answer

A theme is a predefined set of design elements that can be applied to an entire workbook in Microsoft Excel. These design elements include colors, fonts, and other visual effects that give the workbook a cohesive and professional appearance. By applying a theme, users can quickly customize the look and feel of their workbooks without having to manually adjust all of the design elements individually.

Question 15

____________________ is the process of finding and correcting errors in a worksheet.

Accepted Answer

The answer of ____________________ is the process of finding and...

Question 16

Discuss how to use conditional formatting, which is the feature of applying conditional operators to a cell, range, worksheet, or workbook.

Accepted Answer

The answer of Discuss how to use conditional formatting, which...

Question 17

Match between columns
                        Premises: Compares words on the worksheet to words contained in its standard dictionary.

Accepted Answer

The Answer of smart tag and pixel and order of is...

Question 18

Figure 2-4 Click the ____________________ in the Spelling dialog box shown in the accompanying figure to add a misspelled word and its correct spelling to the list of words that Excel automatically will change.

Accepted Answer

The answer of  Figure 2-4 Click the ____________________ in...

Question 19

Critical Thinking Questions Case 1 Leo, owner of Leo's Bread Company, has recently acquired Excel 2007. He would like to set up a workbook to track sales of different types of breads to determine which types are the most popular among customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo uses the Accounting Number Format with the sales numbers he enters into the cells. The worksheets still have the default names assigned to them automatically by Excel. How would Leo rename the worksheets to Rye Bread, Onion Rolls, and Bagels?

Accepted Answer

The best way to rename a worksheet in Excel is to double-click the worksheet tab, type the new name, and press the ENTER key. This will allow Leo to easily keep track of which worksheet corresponds to which bread type. Options A, C, and D will not allow him to rename the worksheet tab.

Question 20

Figure 2-4 To append words to the dictionary, click the ____________________ in the Spelling dialog box shown in the accompanying figure when Excel identifies the word as not in the dictionary.

Accepted Answer

The answer of  Figure 2-4 To append words to...

Quiz 9: Excel: Formulas, Functions, Formatting, and Web Queries

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

The ____________________ of a worksheet is the version that shows the results of the formulas entered, rather than the actual formulas.

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

The TOTAL function sums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range.

Discuss the relationship of debugging and displaying or printing the formulas version of a worksheet. Also describe the difference between the formulas version and the values version.

The HIGHVALUE function displays the highest value in a range.

A fixed dollar sign appears to the far left in the cell, often with spaces between it and the first digit; whereas a moving dollar sign appears immediately to the left of the first digit with no spaces.

The AVERAGE function displays the lowest value in a range.

Excel's strength lies in its handling of numbers and the presentation of them. Discuss some of the considerations to keep in mind when formatting numbers. In the discussion, include the terms fixed dollar sign, floating dollar sign, currency, and percent.

The ____________________ of a worksheet is the version that shows the actual formulas entered, rather than the resulting values.

A theme is a predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook.

____________________ is the process of finding and correcting errors in a worksheet.

Discuss how to use conditional formatting, which is the feature of applying conditional operators to a cell, range, worksheet, or workbook.

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

Figure 2-4 Click the ____________________ in the Spelling dialog box shown in the accompanying figure to add a misspelled word and its correct spelling to the list of words that Excel automatically will change.

Figure 2-4 To append words to the dictionary, click the ____________________ in the Spelling dialog box shown in the accompanying figure when Excel identifies the word as not in the dictionary.