Question 1

____ properties are associated with all Microsoft Office files and include author, title, and subject.

Accepted Answer

A)  Automatic 
B)  Hidden 
C)  Replacement 
D)  Standard 
A)  Automatic 
B)  Hidden 
C)  Replacement 
D)  Standard

Question 2

When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following is the Ribbon path to the Cell Styles button?

Accepted Answer

Question 4

The range of cells receiving the content of copied cells is called the ____.

Accepted Answer

A)  receiver cell 
B)  final cell 
C)  receiving range 
D)  destination area 
A)  receiver cell 
B)  final cell 
C)  receiving range 
D)  destination area

Question 5

The default font for a new workbook is ____________________ 11-point regular black.

Accepted Answer

The answer of The default font for a new workbook...

Question 6

Pressing the ____ keyboard shortcut key(s) selects cell A1.

Accepted Answer

A)  CTRL+HOME 
B)  CTRL+END 
C)  HOME 
D)  END 
A)  CTRL+HOME 
B)  CTRL+END 
C)  HOME 
D)  END

Question 7

What effect does the Comma Style format have on the selected cells?

Accepted Answer

A)  Converts decimals to commas within a cell 
B)  Converts decimals to commas within merged cells 
C)  Displays cell contents with two decimal places and commas as thousands separators 
D)  Allows for substitution of selected characters 
A)  Converts decimals to commas within a cell 
B)  Converts decimals to commas within merged cells 
C)  Displays cell contents with two decimal places and commas as thousands separators 
D)  Allows for substitution of selected characters

Question 8

The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

Accepted Answer

A)  Copy Options 
B)  Replace Options 
C)  Formatting Options 
D)  Auto Fill Options 
A)  Copy Options 
B)  Replace Options 
C)  Formatting Options 
D)  Auto Fill Options

Question 9

The opposite of merging cells is splitting a merged cell.

Accepted Answer

A) True 
 B)False

Question 10

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Selects the adjacent cell in the direction of the arrow on the key.

Accepted Answer

A) ALT+PAGE DOWN 
B) ARROW 
C) CTRL+HOME 
D) HOME 
E) CTRL+F
F)END
G)INSERT
H)SHIFT+RIGHT ARROW
I)BACKSPACE
J)SPACEBAR 
A) ALT+PAGE DOWN 
B) ARROW 
C) CTRL+HOME 
D) HOME 
E) CTRL+F
F)END
G)INSERT
H)SHIFT+RIGHT ARROW
I)BACKSPACE
J)SPACEBAR

Question 11

A(n) ____________________ conveys a visual representation of data.

Accepted Answer

The answer of A(n) ____________________ conveys a visual representation of...

Question 12

Which of the following keys toggles between Insert mode and Overtype mode?

Accepted Answer

A)  INSERT 
B)  ENTER 
C)  TAB 
D)  ALT 
A)  INSERT 
B)  ENTER 
C)  TAB 
D)  ALT

____ properties are associated with all Microsoft Office files and include author, title, and subject.

When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros.

Which of the following is the Ribbon path to the Cell Styles button?

The range of cells receiving the content of copied cells is called the ____.

The default font for a new workbook is ____________________ 11-point regular black.

Pressing the ____ keyboard shortcut key(s) selects cell A1.

What effect does the Comma Style format have on the selected cells?

The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

The opposite of merging cells is splitting a merged cell.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Selects the adjacent cell in the direction of the arrow on the key.

A(n) ____________________ conveys a visual representation of data.

Which of the following keys toggles between Insert mode and Overtype mode?

Essential Concepts and Skills

Formulas, Functions, and Formatting

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 2: Creating a Worksheet and a Chart

____ properties are associated with all Microsoft Office files and include author, title, and subject.

When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros.

Which of the following is the Ribbon path to the Cell Styles button?

The range of cells receiving the content of copied cells is called the ____.

The default font for a new workbook is ____________________ 11-point regular black.

Pressing the ____ keyboard shortcut key(s) selects cell A1.

What effect does the Comma Style format have on the selected cells?

The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

The opposite of merging cells is splitting a merged cell.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Selects the adjacent cell in the direction of the arrow on the key.

A(n) ____________________ conveys a visual representation of data.

Which of the following keys toggles between Insert mode and Overtype mode?

Essential Concepts and Skills

Formulas, Functions, and Formatting

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