Question 1

Which of the following Option buttons gives options for filling cells following a fill operation?

Accepted Answer

A)   Auto Fill Options
B)   Autosarrect Options
C)   Insert Options
D)   Paste Options A

Question 2

The default view in Excel is called ____ view.

Accepted Answer

A)   Normal
B)   Standard
C)   Basic
D)   Values

Question 3

The function, or ____________________, of a worksheet is to provide a user with direct ways to acsamplish tasks.

Accepted Answer

The answer of The function, or ____________________, of a worksheet...

Question 4

Which of the following is a method of entering functions?

Accepted Answer

A)   keyboard, touch gesture, or pointer
B)   the Sum menu
C)   the Insert Function box in the formula bar
D)   the Name box area in the formula bar

Question 5

Which of the following are valid formulas?

Accepted Answer

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

Question 6

Excel automatically appends the ____ to samplete the AVERAGE function when you click the Enter box or press the ENTER key.

Accepted Answer

A)   left parenthesis
B)   right bracket
C)   right parenthesis
D)   left bracket

Question 7

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 8

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

Accepted Answer

A)   samma style format
B)   Acsaunting number format
C)   Percent style format
D)   Currency style format

Question 9

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

Accepted Answer

A)   CTRL+ENTER
B)   TAB+ENTER
C)   ALT+ENTER
D)   SHIFT+ENTER

Question 10

In designing a worksheet, visual aesthetics should same first.

Accepted Answer

A) True 
 B)False

Question 11

A(n)  ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

Accepted Answer

A)   santiguous
B)   indexed
C)   direct
D)   indirect

Question 12

With the acsaunting number style, 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 13

One of the reasons Excel is such a valuable tool is that you can assign a(n) ____________________ to a cell, and Excel will calculate the result.

Accepted Answer

The answer of One of the reasons Excel is such...

Question 14

The / arithmetic operator indicates ____________________.

Accepted Answer

The answer of The / arithmetic operator indicates ____________________....

Question 15

You cannot format an entire salumn at once.

Accepted Answer

A) True 
 B)False

Question 16

A ____ is text and graphics that print at the bottom of every page.

Accepted Answer

A)   footer
B)   toe
C)   margin
D)   stopper A

Question 17

The Acsaunting number format assigns a floating dollar sign.

Accepted Answer

A) True 
 B)False

Question 18

The ____ Autosamplete list santains those functions that alphabetically match the letters you type following the equal sign.

Accepted Answer

A)   Function
B)   Formula
C)   Equal
D)   Calculate

Question 19

You can press the ____________________ key to quit Range Finder.

Accepted Answer

ESC

Question 20

Clicking the Create Function box opens the Function Arguments dialog box.

Accepted Answer

A) True 
 B)False

Exam 13: Formulas, Functions, and Formatting Question

Which of the following Option buttons gives options for filling cells following a fill operation?

Correct Answer
verified
A

The default view in Excel is called ____ view.

Correct Answer
verified

The function, or ____________________, of a worksheet is to provide a user with direct ways to acsamplish tasks.

Correct Answer
verified

Which of the following is a method of entering functions?

Correct Answer
verified

Which of the following are valid formulas?

Correct Answer
verified

Excel automatically appends the ____ to samplete the AVERAGE function when you click the Enter box or press the ENTER key.

Correct Answer
verified

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

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

Correct Answer
verified

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

Correct Answer
verified

In designing a worksheet, visual aesthetics should same first.

Correct Answer
verified

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

Correct Answer
verified

With the acsaunting number style, a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

Correct Answer
verified

One of the reasons Excel is such a valuable tool is that you can assign a(n) ____________________ to a cell, and Excel will calculate the result.

Correct Answer
verified

The / arithmetic operator indicates ____________________.

Correct Answer
verified

You cannot format an entire salumn at once.

Correct Answer
verified

A ____ is text and graphics that print at the bottom of every page.

Correct Answer
verified
A

The Acsaunting number format assigns a floating dollar sign.

Correct Answer
verified

The ____ Autosamplete list santains those functions that alphabetically match the letters you type following the equal sign.

Correct Answer
verified

You can press the ____________________ key to quit Range Finder.

Correct Answer
verified
ESC

Clicking the Create Function box opens the Function Arguments dialog box.

Correct Answer
verified

Exam 13: Formulas, Functions, and Formatting Question

Which of the following Option buttons gives options for filling cells following a fill operation?

Correct AnswerverifiedA

The default view in Excel is called ____ view.

Correct AnswerverifiedShow Answer

The function, or ____________________, of a worksheet is to provide a user with direct ways to acsamplish tasks.

Correct AnswerverifiedShow Answer

Which of the following is a method of entering functions?

Correct AnswerverifiedShow Answer

Which of the following are valid formulas?

Correct AnswerverifiedShow Answer

Excel automatically appends the ____ to samplete the AVERAGE function when you click the Enter box or press the ENTER key.

Correct AnswerverifiedShow Answer

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

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In designing a worksheet, visual aesthetics should same first.

Correct AnswerverifiedShow Answer

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

Correct AnswerverifiedShow Answer

With the acsaunting number style, a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

Correct AnswerverifiedShow Answer

One of the reasons Excel is such a valuable tool is that you can assign a(n) ____________________ to a cell, and Excel will calculate the result.

Correct AnswerverifiedShow Answer

The / arithmetic operator indicates ____________________.

Correct AnswerverifiedShow Answer

You cannot format an entire salumn at once.

Correct AnswerverifiedShow Answer

A ____ is text and graphics that print at the bottom of every page.

Correct AnswerverifiedA

The Acsaunting number format assigns a floating dollar sign.

Correct AnswerverifiedShow Answer

The ____ Autosamplete list santains those functions that alphabetically match the letters you type following the equal sign.

Correct AnswerverifiedShow Answer

You can press the ____________________ key to quit Range Finder.

Correct AnswerverifiedESC

Clicking the Create Function box opens the Function Arguments dialog box.

Correct AnswerverifiedShow Answer

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
ESC

Correct Answer
verified