Question 1

Which of the following actions are provided by the Paste Options button?

Accepted Answer

A)  Pastes an exact copy of what you copied including contents and formatting 
B)  Pastes synonyms or acronyms 
C)  Copy just formulas 
D)  Copy just formatting 
A)  Pastes an exact copy of what you copied including contents and formatting 
B)  Pastes synonyms or acronyms 
C)  Copy just formulas 
D)  Copy just formatting

Question 2

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

Accepted Answer

A)  scheme 
B)  gallery 
C)  theme 
D)  style 
A)  scheme 
B)  gallery 
C)  theme 
D)  style

Question 3

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

Accepted Answer

A) True 
 B)False

Question 4

The most common error when entering a formula is to reference the wrong cell in the formula.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

You can click the ____ button to undo an automatic correction.

Accepted Answer

A)  Auto Fill Options 
B)  AutoCorrect Options 
C)  Paste Options 
D)  Trace Error 
A)  Auto Fill Options 
B)  AutoCorrect Options 
C)  Paste Options 
D)  Trace Error

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

Which of the following is the path to the Conditional Formatting button?

Accepted Answer

Question 10

When Excel recognizes that you entered a date in mm/dd/yy format, it automatically formats the date as ____________________.

Accepted Answer

The answer of When Excel recognizes that you entered a...

Question 11

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

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 13

The default view in Excel is called ____ view.

Accepted Answer

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

Question 14

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 15

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 16

Which of the following is the path to the Comma Style button?

Accepted Answer

Question 17

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Wraps text in a cell.

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 18

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

Accepted Answer

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

Question 19

The default font for the Basis theme is different than the default font for the Office theme.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

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

Which of the following actions are provided by the Paste Options button?

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

The most common error when entering a formula is to reference the wrong cell in the formula.

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

You can click the ____ button to undo an automatic correction.

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

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.

Which of the following is the path to the Conditional Formatting button?

When Excel recognizes that you entered a date in mm/dd/yy format, it automatically formats the date as ____________________.

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

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

The default view in Excel is called ____ view.

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

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

Which of the following is the path to the Comma Style button?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Wraps text in a cell.

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

The default font for the Basis theme is different than the default font for the Office theme.

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

Essential Concepts and Skills

Creating a Worksheet and a Chart

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

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters

Exam 3: Formulas, Functions, and Formatting

Which of the following actions are provided by the Paste Options button?

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

The most common error when entering a formula is to reference the wrong cell in the formula.

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

You can click the ____ button to undo an automatic correction.

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

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.

Which of the following is the path to the Conditional Formatting button?

When Excel recognizes that you entered a date in mm/dd/yy format, it automatically formats the date as ____________________.

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

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

The default view in Excel is called ____ view.

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

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

Which of the following is the path to the Comma Style button?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Wraps text in a cell.

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

The default font for the Basis theme is different than the default font for the Office theme.

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

Essential Concepts and Skills

Creating a Worksheet and a Chart

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

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters