Question 1

In business situations,it is a good idea to save a template in the default ____________________ folder location so your template would appear with other templates when users need to find them.

Accepted Answer

The answer of In business situations,it is a good idea...

Question 2

You can transpose directly from copied Word tables.

Accepted Answer

A) True 
 B)False

Question 3

HTML stands for ____________________ .

Accepted Answer

The answer of HTML stands for ____________________ ....

Question 4

In some cases,when you import data,the data will need to be ____,meaning that the rows and columns need to be switched.

Accepted Answer

A)  formatted 
B)  transposed 
C)  deleted 
D)  none of the above

Question 5

Which of the following is the path to the Get Data From Web button?

Accepted Answer

A)  (DATA tab | Get External Data group) 
B)  (GET EXTERNAL DATA tab | Web group) 
C)  (VIEW tab | Launch Web Query group) 
D)  none of the above

Question 6

A template usually consists of ____ that are common to all the worksheets.

Accepted Answer

A) a format 
B) images 
C) formulas 
D) charts

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

The ____________________ tool allows you to create shadowed,skewed,rotated,and stretched text on a chart sheet or worksheet.

Accepted Answer

The answer of The ____________________ tool allows you to create...

Question 9

Imported data that maintains a refreshable link to its external source is called ____ data.

Accepted Answer

A)  formatted 
B)  external 
C)  exported 
D)  internal

Question 10

The ____________________ Wizard is a powerful tool for manipulating text data in columns.

Accepted Answer

The answer of The ____________________ Wizard is a powerful tool...

Question 11

The Convert Text to Columns Wizard can be used only when a range that includes two or more columns is selected.

Accepted Answer

A) True 
 B)False

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

In business situations,it is a good idea to save a template in the default ____________________ folder location so your template would appear with other templates when users need to find them.

You can transpose directly from copied Word tables.

HTML stands for ____________________ .

In some cases,when you import data,the data will need to be ____,meaning that the rows and columns need to be switched.

Which of the following is the path to the Get Data From Web button?

A template usually consists of ____ that are common to all the worksheets.

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

The ____________________ tool allows you to create shadowed,skewed,rotated,and stretched text on a chart sheet or worksheet.

Imported data that maintains a refreshable link to its external source is called ____ data.

The ____________________ Wizard is a powerful tool for manipulating text data in columns.

The Convert Text to Columns Wizard can be used only when a range that includes two or more columns is selected.