Question 1

The ____ Option button lists formatting options following an insertion of cells,rows,or columns.

Accepted Answer

A)  AutoCorrect 
B)  Insert 
C)  Auto Fill 
D)  Paste 
A)  AutoCorrect 
B)  Insert 
C)  Auto Fill 
D)  Paste

Question 2

To use Range Finder to verify that a formula contains the intended cell references,click or tap the cell with the formula you want to check.

Accepted Answer

A) True 
 B)False

Question 3

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 4

The Insert Options button lists formatting options.

Accepted Answer

A) True 
 B)False

Question 5

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 6

Identify the letter of the choice that best matches the phrase or definition.
-A prewritten formula built into Excel.

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 7

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

Accepted Answer

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

Question 8

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

Accepted Answer

A) True 
 B)False

Question 9

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

Question 10

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

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 12

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?

Accepted Answer

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

Question 13

When you enter a two-digit year that is less than 30,Excel changes the year to ____.

Accepted Answer

A)  20xx 
B)  30xx 
C)  18xx 
D)  19xx 
A)  20xx 
B)  30xx 
C)  18xx 
D)  19xx

Question 14

Clicking the ____ opens the Insert Function dialog box.

Accepted Answer

A)  Insert Function box in the formula bar 
B)  Function dialog box launcher (HOME tab | Calculations group) 
C)  Function button (HOME tab | Function group) 
D)  Functions & Formulas button on the status bar 
A)  Insert Function box in the formula bar 
B)  Function dialog box launcher (HOME tab | Calculations group) 
C)  Function button (HOME tab | Function group) 
D)  Functions & Formulas button on the status bar

Question 15

To copy cell contents,you can select the cell and then press the ____ keys.

Accepted Answer

A)  CTRL+V 
B)  CTRL+X 
C)  CTRL+B 
D)  CTRL+C 
A)  CTRL+V 
B)  CTRL+X 
C)  CTRL+B 
D)  CTRL+C

Question 16

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?

Accepted Answer

A)  Spell checker 
B)  Conditional formatting 
C)  Point mode 
D)  Formulas version 
A)  Spell checker 
B)  Conditional formatting 
C)  Point mode 
D)  Formulas version

Question 17

You can press the ____________________ key to quit Range Finder.

Accepted Answer

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

Question 18

An asterisk (*)following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

Accepted Answer

A) True 
 B)False

Question 19

To paste copied cell contents,you can press the ____ keys.

Accepted Answer

A)  CTRL+C 
B)  CTRL+P 
C)  CTRL+V 
D)  CTRL+X 
A)  CTRL+C 
B)  CTRL+P 
C)  CTRL+V 
D)  CTRL+X

Question 20

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

Accepted Answer

double-tap

The ____ Option button lists formatting options following an insertion of cells,rows,or columns.

To use Range Finder to verify that a formula contains the intended cell references,click or tap the cell with the formula you want to check.

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

The Insert Options button lists formatting options.

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

Identify the letter of the choice that best matches the phrase or definition. -A prewritten formula built into Excel.

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

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

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

Which of the following is a method of entering functions?

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

When you enter a two-digit year that is less than 30,Excel changes the year to ____.

Clicking the ____ opens the Insert Function dialog box.

To copy cell contents,you can select the cell and then press the ____ keys.

You can press the ____________________ key to quit Range Finder.

An asterisk (*)following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

To paste copied cell contents,you can press the ____ keys.

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

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Introduction to Technology

Excel: Creating a Worksheet and a Chart

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

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Filters

Exam 13: Excel: Formulas, Functions, and Formatting

The ____ Option button lists formatting options following an insertion of cells,rows,or columns.

To use Range Finder to verify that a formula contains the intended cell references,click or tap the cell with the formula you want to check.

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

The Insert Options button lists formatting options.

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

Identify the letter of the choice that best matches the phrase or definition. -A prewritten formula built into Excel.

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

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

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

Which of the following is a method of entering functions?

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

When you enter a two-digit year that is less than 30,Excel changes the year to ____.

Clicking the ____ opens the Insert Function dialog box.

To copy cell contents,you can select the cell and then press the ____ keys.

You can press the ____________________ key to quit Range Finder.

An asterisk (*)following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

To paste copied cell contents,you can press the ____ keys.

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

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Introduction to Technology

Excel: Creating a Worksheet and a Chart

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

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Filters