Question 1

A ____ file contains data fields separated by a selected character.

Accepted Answer

A)  fixed 
B)  marked 
C)  delimited 
D)  formatted 
A)  fixed 
B)  marked 
C)  delimited 
D)  formatted C

Question 2

Which of the following is NOT a SmartArt graphic category?

Accepted Answer

A)  Matrix 
B)  Pyramid 
C)  Picture 
D)  Microsoft.com 
A)  Matrix 
B)  Pyramid 
C)  Picture 
D)  Microsoft.com D

Question 3

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 A

Question 4

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

Accepted Answer

Question 5

Elements in a SmartArt graphic are grouped in ____.

Accepted Answer

A)  aggregates 
B)  clusters 
C)  levels 
D)  fields 
A)  aggregates 
B)  clusters 
C)  levels 
D)  fields

Question 6

Briefly explain the considerations for choosing a SmartArt graphic.

Accepted Answer

Consider what you want to illustrate in

Question 7

Using the screen shot feature,you can capture whole windows only.

Accepted Answer

A) True 
 B)False

Question 8

A ____ is a way to qualify the data to import by specifying a matching condition or asking a question of a database.

Accepted Answer

A)  question 
B)  query 
C)  quiz 
D)  quota 
A)  question 
B)  query 
C)  quiz 
D)  quota

Question 9

____ 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 10

A text file in which data fields are separated by commas is called a(n)____________________ text file.

Accepted Answer

The answer of A text file in which data fields...

Question 11

Similar in purpose to a bar graph or column chart,a(n)____________________ chart offers a different 3-D view of the data,and is preferred by some businesses.

Accepted Answer

The answer of Similar in purpose to a bar graph...

Question 12

-Excel includes ____ types of SmartArt graphics,an example of which appears in the accompanying figure.

Accepted Answer

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

Question 13

In today's business environment,you often find that you need to create multiple ____________________ that follow the same basic format.

Accepted Answer

worksheets

Question 14

You can select any range of cells with entries surrounded by blank cells by tapping or clicking a cell in the range and then pressing ____.

Accepted Answer

A)  CTRL+ASTERISK 
B)  SHIFT+AMPERSAND 
C)  CTRL+SHIFT+ASTERISK 
D)  CTRL+SHIFT+AMPERSAND 
A)  CTRL+ASTERISK 
B)  SHIFT+AMPERSAND 
C)  CTRL+SHIFT+ASTERISK 
D)  CTRL+SHIFT+AMPERSAND

Question 15

It is not possible to replicate formulas after completing an import,so be sure to complete the replication before the import.

Accepted Answer

A) True 
 B)False

Question 16

When you add a new shape to a SmartArt graphic,Excel rearranges the shapes in the graphic to fit in the same area.

Accepted Answer

A) True 
 B)False

Question 17

SmartArt graphics may include at most one shape.

Accepted Answer

A) True 
 B)False

Question 18

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A text file with data fields of equal length and spaces between the fields.

Accepted Answer

A) template 
B) dummy data 
C) XML 
D) Excel Template 
E) external data
F)fixed width file
G)drag and drop
H)Web query
I)transposed
J)replication 
A) template 
B) dummy data 
C) XML 
D) Excel Template 
E) external data
F)fixed width file
G)drag and drop
H)Web query
I)transposed
J)replication

Question 19

In some situations,you may find that a column of data imported from Word should be split into two columns.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is the path to the Text to Columns button?

Accepted Answer

A ____ file contains data fields separated by a selected character.

Which of the following is NOT a SmartArt graphic category?

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

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

Elements in a SmartArt graphic are grouped in ____.

Briefly explain the considerations for choosing a SmartArt graphic.

Using the screen shot feature,you can capture whole windows only.

A ____ is a way to qualify the data to import by specifying a matching condition or asking a question of a database.

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

A text file in which data fields are separated by commas is called a(n)____________________ text file.

Similar in purpose to a bar graph or column chart,a(n)____________________ chart offers a different 3-D view of the data,and is preferred by some businesses.

-Excel includes ____ types of SmartArt graphics,an example of which appears in the accompanying figure.

In today's business environment,you often find that you need to create multiple ____________________ that follow the same basic format.

You can select any range of cells with entries surrounded by blank cells by tapping or clicking a cell in the range and then pressing ____.

It is not possible to replicate formulas after completing an import,so be sure to complete the replication before the import.

When you add a new shape to a SmartArt graphic,Excel rearranges the shapes in the graphic to fit in the same area.

SmartArt graphics may include at most one shape.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A text file with data fields of equal length and spaces between the fields.

In some situations,you may find that a column of data imported from Word should be split into two columns.

Which of the following is the path to the Text to Columns button?

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

Office 2013 and Windows 8 Essential Concepts and Skills

Filters

Exam 7: Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

A ____ file contains data fields separated by a selected character.

Which of the following is NOT a SmartArt graphic category?

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

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

Elements in a SmartArt graphic are grouped in ____.

Briefly explain the considerations for choosing a SmartArt graphic.

Using the screen shot feature,you can capture whole windows only.

A ____ is a way to qualify the data to import by specifying a matching condition or asking a question of a database.

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

A text file in which data fields are separated by commas is called a(n)____________________ text file.

Similar in purpose to a bar graph or column chart,a(n)____________________ chart offers a different 3-D view of the data,and is preferred by some businesses.

-Excel includes ____ types of SmartArt graphics,an example of which appears in the accompanying figure.

In today's business environment,you often find that you need to create multiple ____________________ that follow the same basic format.

You can select any range of cells with entries surrounded by blank cells by tapping or clicking a cell in the range and then pressing ____.

It is not possible to replicate formulas after completing an import,so be sure to complete the replication before the import.

When you add a new shape to a SmartArt graphic,Excel rearranges the shapes in the graphic to fit in the same area.

SmartArt graphics may include at most one shape.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A text file with data fields of equal length and spaces between the fields.

In some situations,you may find that a column of data imported from Word should be split into two columns.

Which of the following is the path to the Text to Columns button?

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

Office 2013 and Windows 8 Essential Concepts and Skills

Filters