Question 1

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

Accepted Answer

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

Question 2

While holding down the ALT key, you can select nonadjacent ranges and cells. _________________________

Accepted Answer

CTRL

Question 3

The Accounting number format assigns a floating dollar sign. _________________________

Accepted Answer

fixed

Question 4

You can press the ____________________ key to quit Range Finder.

Accepted Answer

The answer of You can press the ____________________ key to...

Question 5

Critical Thinking Questions Case 2-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.
After three months, Anna wants to the know the average distance she runs. What should she do to calculate the average distance?
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.

Accepted Answer

The answer of Critical Thinking Questions Case 2-2
Anna is a...

Question 6

Critical Thinking Questions Case 2-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?
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.

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 she always has an accurate record of her longest total time.

Question 7

____________________ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see.

Accepted Answer

The answer of ____________________ is a technique that can be...

Question 8

Critical Thinking Questions Case 2-1
Leo, owner of Leo's Bread Company, recently installed Excel 2013 and created a new workbook to track sales of different types of bread. He wants to determine which types of bread are the most popular among his customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo has formatted the sales numbers with the Accounting number format.
Leo wants the sales numbers for rye bread, onion rolls, and bagels to look different each time the sales for each exceeds $500. What Excel feature can Leo use to accomplish this?
A) Spell checker
B) Conditional formatting
C) Point mode
D) Formulas version

Accepted Answer

Leo can use conditional formatting to change the appearance of the sales numbers for rye bread, onion rolls, and bagels each time the sales for each exceeds $500. By setting a conditional formatting rule, Leo can choose a different font color, fill color, or border style to apply to the cells with sales numbers that meet the specified condition. This will make it easier for Leo to quickly identify the most popular types of bread among his customers.

Question 9

____________________ view shows the worksheet divided into pages.

Accepted Answer

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

Question 10

____________________ are those portions of a printed page outside the main body of the printed document and always are blank when printed.

Accepted Answer

The answer of ____________________ are those portions of a printed...

Question 11

Critical Thinking Questions Case 2-1
Leo, owner of Leo's Bread Company, recently installed Excel 2013 and created a new workbook to track sales of different types of bread. He wants to determine which types of bread are the most popular among his customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo has formatted the sales numbers with the Accounting number format.
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 spaces from the actual value. He would prefer that the dollar sign appear immediately to the left of the first digit of the value. To specify a floating dollar sign, which of the following formats should Leo apply?
A) Comma style
B) Percent style
C) Currency style
D) General number

Accepted Answer

The Currency style displays a floating dollar sign immediately to the left of the first digit of the value. The Comma style separates thousands with commas, the Percent style displays numbers as percentages, and the General number format displays numbers as plain text without any specific number format.

Question 12

Of warmer and cooler colors, the kind of colors that tend to reach toward the reader are ____________________ colors.

Accepted Answer

The answer of Of warmer and cooler colors, the kind...

Question 13

Cooler colors tend to pull away from the reader. _________________________

Accepted Answer

Cooler colors such as blue, green, and purple tend to recede or appear further away from the viewer, creating a sense of depth or distance. In contrast, warmer colors such as red, orange, and yellow tend to advance or appear closer to the viewer.

Question 14

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

You can click the Page Layout button on the status bar to switch to ____________________ view.

Accepted Answer

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

Quiz 4: Excel 2 Formulas, Functions, and Formatting