Question 1

You can access the Find and Replace feature by pressing the ____ key(s).

Accepted Answer

A)  ALT+H 
B)  CTRL+R 
C)  F11 
D)  CTRL+H 
A)  ALT+H 
B)  CTRL+R 
C)  F11 
D)  CTRL+H

Question 2

A team of saworkers 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 ____.

Accepted Answer

A)  add a chart using the 3-D sane chart type to illustrate the trends 
B)  create a new worksheet and add several drawing shapes, such as rectangles or arrows, santaining 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 
A)  add a chart using the 3-D sane chart type to illustrate the trends 
B)  create a new worksheet and add several drawing shapes, such as rectangles or arrows, santaining 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

Question 3

Which of the following can be sources of imported data for an Excel workbook?

Accepted Answer

A)  database table 
B)  data stored in Word documents 
C)  text file 
D)  XML file 
A)  database table 
B)  data stored in Word documents 
C)  text file 
D)  XML file

Question 4

By default, the cell that is active when a Web query is performed will besame the lower-left cell of the imported range.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

Match between columns
                        Premises: Selects data from the Internet to add to an Excel worksheet.
Switched rows and salumns for imported data.
Save as type to create a template workbook.
A text file with data fields of equal length and spaces between the fields.
Method to import an Access table into an Excel worksheet when both applications are open.
Imported data that maintains a refreshable link to its external source.
A popular format for data exchange.
A special-purpose workbook used as a pattern to create similar workbooks.
Another term for sapying formulas.
Sample data used in place of actual data to verify formulas in a template.

Accepted Answer

The Answer of XML and fixed width file and drag is...

Question 7

Which of the following is the path to the Find & Select button?

Accepted Answer

Question 8

What are the steps to insert an individual image into a workbook?

Accepted Answer

Answer
1. Select the cell at which you w

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

Question 11

A ____ file santains 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

Question 12

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 13

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

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

Accepted Answer

Question 15

Tapping or clicking the ____ button changes a SmartArt graphic to individual shapes that can be resized, moved, or deleted independently of the others.

Accepted Answer

A)  Individual Shapes 
B)  samponents 
C)  sanvert to Shapes 
D)  Desampose 
A)  Individual Shapes 
B)  samponents 
C)  sanvert to Shapes 
D)  Desampose

Question 16

Templates can santain ____.

Accepted Answer

A)  text 
B)  graphics 
C)  page layouts 
D)  macros 
A)  text 
B)  graphics 
C)  page layouts 
D)  macros

Question 17

Which of the following is the path to the Insert WordArt button?

Accepted Answer

Question 18

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...

Question 19

To rotate pictures in Excel, select the image to be rotated, then tap or click the ____ button (PICTURE TOOLS FORMAT tab | Arrange group).

Accepted Answer

A)  Rotate Objects 
B)  Turn Picture 
C)  Move Objects 
D)  Reorientation 
A)  Rotate Objects 
B)  Turn Picture 
C)  Move Objects 
D)  Reorientation

Question 20

If you have both Excel and Access open on your desktop, you can drag and drop an entire table or query from Access to Excel.

Accepted Answer

A) True 
 B)False

Exam 18: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

You can access the Find and Replace feature by pressing the ____ key(s).

Which of the following can be sources of imported data for an Excel workbook?

By default, the cell that is active when a Web query is performed will besame the lower-left cell of the imported range.

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

Which of the following is the path to the Find & Select button?

What are the steps to insert an individual image into a workbook?

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

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

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

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

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

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

Tapping or clicking the ____ button changes a SmartArt graphic to individual shapes that can be resized, moved, or deleted independently of the others.

Templates can santain ____.

Which of the following is the path to the Insert WordArt button?

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.

To rotate pictures in Excel, select the image to be rotated, then tap or click the ____ button (PICTURE TOOLS FORMAT tab | Arrange group).

If you have both Excel and Access open on your desktop, you can drag and drop an entire table or query from Access to Excel.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters