Question 1

Which of the following is a SmartArt graphic category?

Accepted Answer

A)  Triangle 
B)  Model 
C)  Circle 
D)  Process 
A)  Triangle 
B)  Model 
C)  Circle 
D)  Process D

Question 2

When you import a table from Access into Excel,the table is formatted with the default table style for the database's theme._________________________

Accepted Answer

A) True 
 B)False  False

Question 3

Excel allows you to import data from webpages.

Accepted Answer

A) True 
 B)False  True

Question 4

When Excel imports a database table,the data is placed in an Excel ____.

Accepted Answer

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

Question 5

A(n)____ is a special-purpose workbook you can create and then use as a pattern to create new,similar workbooks or worksheets.

Accepted Answer

A)  guide 
B)  program 
C)  template 
D)  budget 
A)  guide 
B)  program 
C)  template 
D)  budget

Question 6

Webpages use a file format called ____.

Accepted Answer

A)  DOCX 
B)  HTML 
C)  XLSX 
D)  PPTX 
A)  DOCX 
B)  HTML 
C)  XLSX 
D)  PPTX

Question 7

Which of the following is the path to the Format Painter button?

Accepted Answer

Question 8

Which of the following is the path to the 'Insert a SmartArt Graphic' button?

Accepted Answer

Question 9

Which of the following is the path to the Refresh All button?

Accepted Answer

Question 10

Excel allows you to import formatting from a number of types of sources.
_________________________

Accepted Answer

A) True 
 B)False

Question 11

​HTML stands for Hypertext Markup Language.

Accepted Answer

A) True 
 B)False

Question 12

Saving a template is similar to saving a workbook,except that the file type,Master File is selected in the Save as type box in the Save As dialog box._________________________

Accepted Answer

A) True 
 B)False

Question 13

It is not necessary to understand the layout of data you want to import; Excel automatically arranges each data element in the worksheet.

Accepted Answer

A) True 
 B)False

Question 14

Because ____ help speed and simplify work,many Excel users create one for each project on which they work.

Accepted Answer

A)  indices 
B)  filters 
C)  text files 
D)  templates 
A)  indices 
B)  filters 
C)  text files 
D)  templates

Question 15

Excel includes ____ types of SmartArt graphics.

Accepted Answer

A)  9 
B)  19 
C)  90 
D)  99 
A)  9 
B)  19 
C)  90 
D)  99

Question 16

Which of the following are reasons to use a Web query instead of copying and pasting data from a webpage?

Accepted Answer

A)  copying only the desired data from webpages to the Office Clipboard and then pasting it into Excel can be tedious 
B)  copying data from webpages to the Office Clipboard and then pasting it into Excel creates duplicate entries that must be deleted 
A)  copying only the desired data from webpages to the Office Clipboard and then pasting it into Excel can be tedious 
B)  copying data from webpages to the Office Clipboard and then pasting it into Excel creates duplicate entries that must be deleted

Question 17

A Word document often contains data stored in a(n)____ that can then be copied and pasted into an Excel worksheet.

Accepted Answer

A)  table 
B)  object 
C)  unit 
D)  matrix 
A)  table 
B)  object 
C)  unit 
D)  matrix

Question 18

The Import Data dialog box allows you to choose whether to import the data into a ____.

Accepted Answer

A)  table 
B)  PivotTable Report 
C)  PivotChart 
D)  new folder 
A)  table 
B)  PivotTable Report 
C)  PivotChart 
D)  new folder

Question 19

You should not credit the source of an image unless you can specifically name the image creator.

Accepted Answer

A) True 
 B)False

Question 20

When a range is transposed,the first row of the selected range becomes the first column in the destination range,and so forth.

Accepted Answer

A) True 
 B)False

Which of the following is a SmartArt graphic category?

When you import a table from Access into Excel,the table is formatted with the default table style for the database's theme._________________________

Excel allows you to import data from webpages.

When Excel imports a database table,the data is placed in an Excel ____.

A(n)____ is a special-purpose workbook you can create and then use as a pattern to create new,similar workbooks or worksheets.

Webpages use a file format called ____.

Which of the following is the path to the Format Painter button?

Which of the following is the path to the 'Insert a SmartArt Graphic' button?

Which of the following is the path to the Refresh All button?

Excel allows you to import formatting from a number of types of sources. _________________________

HTML stands for Hypertext Markup Language.

Saving a template is similar to saving a workbook,except that the file type,Master File is selected in the Save as type box in the Save As dialog box._________________________

It is not necessary to understand the layout of data you want to import; Excel automatically arranges each data element in the worksheet.

Because ____ help speed and simplify work,many Excel users create one for each project on which they work.

Excel includes ____ types of SmartArt graphics.

Which of the following are reasons to use a Web query instead of copying and pasting data from a webpage?

A Word document often contains data stored in a(n)____ that can then be copied and pasted into an Excel worksheet.

The Import Data dialog box allows you to choose whether to import the data into a ____.

You should not credit the source of an image unless you can specifically name the image creator.

When a range is transposed,the first row of the selected range becomes the first column in the destination range,and so forth.

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

Which of the following is a SmartArt graphic category?

When you import a table from Access into Excel,the table is formatted with the default table style for the database's theme._________________________

Excel allows you to import data from webpages.

When Excel imports a database table,the data is placed in an Excel ____.

A(n)____ is a special-purpose workbook you can create and then use as a pattern to create new,similar workbooks or worksheets.

Webpages use a file format called ____.

Which of the following is the path to the Format Painter button?

Which of the following is the path to the 'Insert a SmartArt Graphic' button?

Which of the following is the path to the Refresh All button?

Excel allows you to import formatting from a number of types of sources. _________________________

​HTML stands for Hypertext Markup Language.

Saving a template is similar to saving a workbook,except that the file type,Master File is selected in the Save as type box in the Save As dialog box._________________________

It is not necessary to understand the layout of data you want to import; Excel automatically arranges each data element in the worksheet.

Because ____ help speed and simplify work,many Excel users create one for each project on which they work.

Excel includes ____ types of SmartArt graphics.

Which of the following are reasons to use a Web query instead of copying and pasting data from a webpage?

A Word document often contains data stored in a(n)____ that can then be copied and pasted into an Excel worksheet.

The Import Data dialog box allows you to choose whether to import the data into a ____.

You should not credit the source of an image unless you can specifically name the image creator.

When a range is transposed,the first row of the selected range becomes the first column in the destination range,and so forth.

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

HTML stands for Hypertext Markup Language.