Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Displays the worksheet with formulas.

Accepted Answer

A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V 
A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V

Question 2

Which of the following is the path to the Copy and Paste buttons?

Accepted Answer

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

Accepted Answer

A) True 
 B)False

Question 5

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

Accepted Answer

A) True 
 B)False

Question 6

You can use the arrow keys to complete an entry in Point mode.

Accepted Answer

A) True 
 B)False

Question 7

-Typing =av in a cell displays the ____________________,as shown in the accompanying figure.

Accepted Answer

Formula Au

Question 8

Which of the following are valid formulas?

Accepted Answer

A) =3 ^ 4 
B) =H3 / H11 
C) =11+9 
D) =22-F15 
E)  None of the above. 
A) =3 ^ 4 
B) =H3 / H11 
C) =11+9 
D) =22-F15 
E)  None of the above.

Question 9

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

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Pastes a formula.

Accepted Answer

A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V 
A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V

Question 11

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A formula in a cell that contains a reference back to itself.

Accepted Answer

A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V 
A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V

Question 12

In designing a worksheet,visual aesthetics should come first._________________________

Accepted Answer

A) True 
 B)False

Question 13

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A function that displays the highest value in a range.

Accepted Answer

A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V 
A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Negation comes first in this.

Accepted Answer

A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V 
A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V

Question 15

You can open the Format Cells dialog box by pressing the ____ keys.

Accepted Answer

A)  SHIFT+TAB 
B)  CTRL+1 
C)  ALT+1 
D)  SHIFT+F1 
A)  SHIFT+TAB 
B)  CTRL+1 
C)  ALT+1 
D)  SHIFT+F1

Question 16

With the accounting 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 17

Which of the following is the path to the Sum arrow?

Accepted Answer

Question 18

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?

Accepted Answer

A)  Comma style 
B)  Percent style 
C)  Currency style 
D)  General number 
A)  Comma style 
B)  Percent style 
C)  Currency style 
D)  General number

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

A formula in a cell that creates a refer

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays the worksheet with formulas.

Which of the following is the path to the Copy and Paste buttons?

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

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

You can use the arrow keys to complete an entry in Point mode.

-Typing =av in a cell displays the ____________________,as shown in the accompanying figure.

Which of the following are valid formulas?

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Pastes a formula.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A formula in a cell that contains a reference back to itself.

In designing a worksheet,visual aesthetics should come first._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A function that displays the highest value in a range.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Negation comes first in this.

You can open the Format Cells dialog box by pressing the ____ keys.

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

Which of the following is the path to the Sum arrow?

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

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

Creating a Worksheet and a Chart

Working With Large Worksheets,Charting,and What-If Analysis

Financial Functions,Data Tables,and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters

Exam 2: Formulas,Functions,and Formatting

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays the worksheet with formulas.

Which of the following is the path to the Copy and Paste buttons?

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

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

You can use the arrow keys to complete an entry in Point mode.

-Typing =av in a cell displays the ____________________,as shown in the accompanying figure.

Which of the following are valid formulas?

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Pastes a formula.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A formula in a cell that contains a reference back to itself.

In designing a worksheet,visual aesthetics should come first._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A function that displays the highest value in a range.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Negation comes first in this.

You can open the Format Cells dialog box by pressing the ____ keys.

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

Which of the following is the path to the Sum arrow?

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

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

Creating a Worksheet and a Chart

Working With Large Worksheets,Charting,and What-If Analysis

Financial Functions,Data Tables,and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters