Question 1

To add a pie chart,first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)  fill 
B)  range 
C)  location 
D)  paste 
A)  fill 
B)  range 
C)  location 
D)  paste

Question 3

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

Accepted Answer

A)  AutoFormat 
B)  AutoComplete 
C)  AutoFunction 
D)  AutoCalculate 
A)  AutoFormat 
B)  AutoComplete 
C)  AutoFunction 
D)  AutoCalculate

Question 4

You use ____ to view an XPS file.

Accepted Answer

A)  Adobe Reader 
B)  Backstage View 
C)  Microsoft PowerView 
D)  XPS Viewer 
A)  Adobe Reader 
B)  Backstage View 
C)  Microsoft PowerView 
D)  XPS Viewer

Question 5

A pie chart with one or more slices offset is referred to as a(n)____ pie chart.

Accepted Answer

A)  exploded 
B)  outer 
C)  offset 
D)  rasterized 
A)  exploded 
B)  outer 
C)  offset 
D)  rasterized

Question 6

A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names.

Accepted Answer

A) True 
 B)False

Question 7

You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).

Accepted Answer

A) True 
 B)False

Question 8

The ____ button allows you to erase recent cell entries.

Accepted Answer

A)  Undo 
B)  Cell Style 
C)  Bold 
D)  Increase Decimal 
A)  Undo 
B)  Cell Style 
C)  Bold 
D)  Increase Decimal

Question 9

When text is longer than the width of a column,Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.

Accepted Answer

A) True 
 B)False

Question 10

Both the Cancel button and the Enter button appear on the formula bar when you begin typing in a cell.

Accepted Answer

A) True 
 B)False

Question 11

To enter data in a cell,you must first select the ____.

Accepted Answer

A)  row 
B)  worksheet 
C)  column 
D)  cell 
A)  row 
B)  worksheet 
C)  column 
D)  cell

To add a pie chart,first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).

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

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

You use ____ to view an XPS file.

A pie chart with one or more slices offset is referred to as a(n)____ pie chart.

A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names.

You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).

The ____ button allows you to erase recent cell entries.

When text is longer than the width of a column,Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.

Both the Cancel button and the Enter button appear on the formula bar when you begin typing in a cell.

To enter data in a cell,you must first select the ____.

Formulas, Functions, and Formatting

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 Screenshots

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

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

Exam 1: Creating a Worksheet and a Chart

To add a pie chart,first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).

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

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

You use ____ to view an XPS file.

A pie chart with one or more slices offset is referred to as a(n)____ pie chart.

A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names.

You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).

The ____ button allows you to erase recent cell entries.

When text is longer than the width of a column,Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.

Both the Cancel button and the Enter button appear on the formula bar when you begin typing in a cell.

To enter data in a cell,you must first select the ____.

Formulas, Functions, and Formatting

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 Screenshots

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

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters