Question 1

SmartArt graphics may include at most one shape.

Accepted Answer

A) True 
 B)False

Question 2

____ a shape within a SmartArt graphic means moving it to a lower level.

Accepted Answer

A)  Descending 
B)  Demoting 
C)  Reducing 
D)  Rasterizing 
A)  Descending 
B)  Demoting 
C)  Reducing 
D)  Rasterizing

Question 3

Excel allows you to take a ____ of any open window and add it to a workbook.

Accepted Answer

A)  sneak peek 
B)  screen shot 
C)  quick glimpse 
D)  cybergrab 
A)  sneak peek 
B)  screen shot 
C)  quick glimpse 
D)  cybergrab

Question 4

Webpage column headings are imported with the data and displayed in rows.

Accepted Answer

A) True 
 B)False

Question 5

When importing data into a workbook,it is common to receive text files with fields of data separated by commas._________________________

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is the path to the 'Take a Screenshot' button?

Accepted Answer

Question 7

The Find and Replace dialog box has two variations,one displaying minimal options and the other displaying all of the available options.

Accepted Answer

A) True 
 B)False

Question 8

The most common use for the Convert Text to Columns Wizard is to manipulate imported data.

Accepted Answer

A) True 
 B)False

SmartArt graphics may include at most one shape.

____ a shape within a SmartArt graphic means moving it to a lower level.

Excel allows you to take a ____ of any open window and add it to a workbook.

Webpage column headings are imported with the data and displayed in rows.

When importing data into a workbook,it is common to receive text files with fields of data separated by commas._________________________

Which of the following is the path to the 'Take a Screenshot' button?

The Find and Replace dialog box has two variations,one displaying minimal options and the other displaying all of the available options.

The most common use for the Convert Text to Columns Wizard is to manipulate imported data.

Creating a Worksheet and a Chart

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

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 7: Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

SmartArt graphics may include at most one shape.

____ a shape within a SmartArt graphic means moving it to a lower level.

Excel allows you to take a ____ of any open window and add it to a workbook.

Webpage column headings are imported with the data and displayed in rows.

When importing data into a workbook,it is common to receive text files with fields of data separated by commas._________________________

Which of the following is the path to the 'Take a Screenshot' button?

The Find and Replace dialog box has two variations,one displaying minimal options and the other displaying all of the available options.

The most common use for the Convert Text to Columns Wizard is to manipulate imported data.

Creating a Worksheet and a Chart

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

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