Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A special-purpose workbook used as a pattern to create similar workbooks.
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

Accepted Answer

A template is a special-purpose workbook used as a pattern to create similar workbooks.

Answer: D
 An Excel Template is a specific type of template that is used in Microsoft Excel.

(Note: None of the other choices match the definition given)

Question 2

A team of coworkers from the marketing department are holding a brainstorming session on ways to add more visual interest to a sales data workbook and, at the same time, improve user understanding of the data and calculations included in the workbook. They invite you to be part of the discussion.
-Liz says she wants to find a way to illustrate how changes in production costs affect sales prices.You suggest that she consider ____.
A) inserting an embedded pie chart comparing production costs and sales prices
B) using the Find and Replace commands to apply formatting to the sales prices being illustrated
C) using a SmartArt graphic to illustrate the relationship between increases in production costs and product sales prices
D) importing the production costs data from a text file into a new worksheet

Accepted Answer

Using a SmartArt graphic is the best choice as it allows for a clear illustration of the relationship between production costs and sales prices, making it easier for the user to understand the impact of changes in production costs on product sales prices. A pie chart may not be the best option as it only compares two data points, while a SmartArt graphic allows for a more detailed illustration of the data. Using Find and Replace commands or importing data from a text file would not visually enhance the workbook in the desired way.

Question 3

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Another term for copying formulas.
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

Accepted Answer

Replication is the term used in Excel for copying formulas from one cell to another.

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Method to import an Access table into an Excel worksheet when both applications are open.
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

Accepted Answer

The method to import an Access table into an Excel worksheet when both applications are open is "drag and drop."

Question 5

Briefly explain the considerations for choosing a SmartArt graphic.

Accepted Answer

The answer of Briefly explain the considerations for choosing a...

Question 6

Laura, in Personnel, needs to create a new payroll workbook each month. The formatting and formulas are the same in each new workbook; only the payroll data is different. During a conversation at lunch, she asks if you have any suggestions for ways she can save time with this workbook setup task.
-You suggest to Laura that she get a high level of confidence in the workbooks that she creates.You tell her that one way to do this is to test the workbook extensively,including selecting dummy data that tests the ____ of the formulas.
A) baselines
B) types
C) veracity
D) limits

Accepted Answer

Testing the limits of the formulas with dummy data will ensure that they are working correctly and can handle a range of different inputs. This will give Laura a high level of confidence in the workbooks she creates and save time in the long run by avoiding errors.

Question 7

Laura, in Personnel, needs to create a new payroll workbook each month. The formatting and formulas are the same in each new workbook; only the payroll data is different. During a conversation at lunch, she asks if you have any suggestions for ways she can save time with this workbook setup task.
-Laura was so impressed with your helpful suggestion for the payroll workbook that she gives you a call about another issue.She has just been told that some of the branch office payroll data will now be available in an Access database table.She is unfamiliar with Access and asks you if there is an easy way to get the Access table data into the payroll workbook.You tell her that she can _____.
A) import the Access table using an ASCII table modifier downloaded from the IT department's Web site
B) open the Access database and the Excel workbook and then drag the Access table to the desired location on a worksheet in the payroll workbook
C) open the Access database,print the table's datasheet,and then manually enter the data on the printout in a worksheet in the payroll workbook
D) have the branch offices copy the Access table,paste it on the branch office webpage,and then create a Web query to import the data into the payroll workbook

Accepted Answer

The easiest way to get the Access table data into the payroll workbook is to open both programs and then drag the Access table to the desired location on a worksheet in the payroll workbook. This will automatically import the data while preserving the formatting and formulas already in the workbook. A is incorrect because an ASCII table modifier is not necessary or provided for this task. C is incorrect because manually entering the data from a printout is time-consuming and leaves room for errors. D is incorrect because having the branch offices copy and paste the data onto a webpage and then creating a Web query adds unnecessary steps and complexities.

Question 8

A team of coworkers from the marketing department are holding a brainstorming session on ways to add more visual interest to a sales data workbook and, at the same time, improve user understanding of the data and calculations included in the workbook. They invite you to be part of the discussion.
-Mark wants to illustrate trends in the average sales price for several products.You suggest that he ____.
A) add a chart using the 3-D cone chart type to illustrate the trends
B) create a new worksheet and add several drawing shapes,such as rectangles or arrows,containing text that describes the trends in the average sales prices
C) add pictures of each product trend
D) insert a WordArt title explanation on the sales data worksheet

Accepted Answer

Adding a chart using the 3-D cone chart type can effectively illustrate trends in the average sales price for several products, making it easier for users to understand the data and calculations. This would be more visually appealing and informative than the other options provided.

Question 9

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Selects data from the Internet to add to an Excel worksheet.
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

Accepted Answer

Web query is the process used to import data from the web to Excel.

Answer: E 
 External data refers to data that is stored outside of Excel, but can be used in an Excel worksheet.

Answer: I 
 Transposing refers to flipping data from rows to columns, or vice versa.

Possible other options:

Answer: G
 Drag and drop may be used to move or copy data from one cell to another, but not specifically for importing data from the Internet.

Answer: F
 A fixed width file is a type of text file with columns of equal length, and is not specific to importing data from the Internet.

Answer: A, D
 Templates are pre-formatted documents or spreadsheets that may include dummy data, but do not specifically refer to importing data from the Internet. Excel templates may be used as a starting point for creating a worksheet.

Question 10

Briefly describe planning considerations before you begin importing data.

Accepted Answer

The answer of Briefly describe planning considerations before you begin...

Question 11

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A popular format for data exchange.
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

Accepted Answer

XML (Extensible Markup Language) is a popular format for data exchange between different systems and applications.

Note: None of the other choices specifically relate to a format for data exchange.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A special-purpose workbook used as a pattern to create similar workbooks.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Another term for copying formulas.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Method to import an Access table into an Excel worksheet when both applications are open.

Briefly explain the considerations for choosing a SmartArt graphic.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Selects data from the Internet to add to an Excel worksheet.

Briefly describe planning considerations before you begin importing data.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A popular format for data exchange.