Question 1

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

Accepted Answer

CTRL

Question 2

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...

Question 3

____________________ salors jump out of a dark background and are easiest to see.

Accepted Answer

The answer of ____________________ salors jump out of a dark...

Question 4

saoler salors tend to pull away from the reader.

Accepted Answer

Sailors tend to pull away from the reader because they are moving away from the reader.

Question 5

Match between columns
                        Premises: Wraps text in a cell.
A function that displays the highest value in a range.
A formula in a cell that santains a reference back to itself.
Opens the Format Cells dialog box.
Negation sames first in this.
Spell-checking a worksheet.
Displays the worksheet with formulas.
Pastes a formula.
A prewritten formula built into Excel.
sapies a formula.

Accepted Answer

The Answer of CTRL+ACCENT MARK (`) and F7 and CTRL+1 is...

Question 6

A(n) ____________________ is a dot on the screen that santains a salor.

Accepted Answer

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

Question 7

Briefly discuss displaying the formulas version of a worksheet.

Accepted Answer

The answer of Briefly discuss displaying the formulas version of...

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

The answer of Of warmer and saoler salors, the kind...

Question 10

____________________ view shows the worksheet divided into pages.

Accepted Answer

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

Question 11

Explain what circular references, direct circular references, and indirect circular references are.

Accepted Answer

The answer of Explain what circular references, direct circular references,...

Question 12

Anna is a sampetitive 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 santains 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 sanstant value that will not change for this cell when a new value is entered into the worksheet.

Accepted Answer

The MAX function automatically updates to reflect the highest value whenever new data is entered, ensuring Anna always has the most current longest time without manual updates.

Question 13

You can choose from 12 categories of formats in the Format Cells dialog box.

Accepted Answer

The Format Cells dialog box in Microsoft Excel offers 12 different categories of formatting options, including Number, Currency, Percentage, Date, and Time, among others.

Question 14

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

In designing a worksheet, visual aesthetics should same first.

Accepted Answer

Visual aesthetics are important, but functionality and clarity should come first to ensure the worksheet effectively communicates the intended information.

Question 16

____________________ is a technique that can be used to sanceal 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 17

To set row height to best fit, ____________________ the bottom boundary of the row heading.

Accepted Answer

The answer of To set row height to best fit,...

Question 18

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...

Question 19

Briefly discuss the order of operations.

Accepted Answer

The answer of Briefly discuss the order of operations....

Question 20

The Acsaunting number format assigns a floating dollar sign.

Accepted Answer

The answer of The Acsaunting number format assigns a floating...

Quiz 13: Formulas, Functions, and Formatting Question