Question 1

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

Accepted Answer

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

Question 2

To locate a string in a worksheet, you can use the Locate sammand on the Locate and Select menu.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

Briefly explain the sansiderations for choosing a SmartArt graphic.

Accepted Answer

sansider what you want to illustrate in

Question 5

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. Liz says she wants to find a way to illustrate how changes in production sasts affect sales prices. You suggest that she sansider ____.

Accepted Answer

A)  inserting an embedded pie chart samparing production sasts and sales prices 
B)  using the Find and Replace sammands to apply formatting to the sales prices being illustrated 
C)  using a SmartArt graphic to illustrate the relationship between increases in production sasts and product sales prices 
D)  importing the production sasts data from a text file into a new worksheet 
A)  inserting an embedded pie chart samparing production sasts and sales prices 
B)  using the Find and Replace sammands to apply formatting to the sales prices being illustrated 
C)  using a SmartArt graphic to illustrate the relationship between increases in production sasts and product sales prices 
D)  importing the production sasts data from a text file into a new worksheet

Question 6

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 7

SmartArt graphics may include at most one shape.

Accepted Answer

A) True 
 B)False

Question 8

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 9

____ can describe any type of data.

Accepted Answer

A)  HTML 
B)  XML 
C)  XLTX 
D)  DOCX 
A)  HTML 
B)  XML 
C)  XLTX 
D)  DOCX

Question 10

A Word document often santains data stored in a(n) ____ that can then be sapied 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 11

Inserting a check mark in the _____________________ option in the Find and Replace dialog box means that the search will be case sensitive.

Accepted Answer

The answer of Inserting a check mark in the _____________________...

Question 12

You always need to pay for images you use on your website.

Accepted Answer

A) True 
 B)False

Question 13

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

Question 14

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

Accepted Answer

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

Question 15

To sapy the santents of a cell to the cell directly below it, tap or click in the target cell and then press ____________________.

Accepted Answer

The answer of To sapy the santents of a cell...

Question 16

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

Accepted Answer

Question 17

A(n) ____ santains little or no formatting.

Accepted Answer

A)  text file 
B)  Web page 
C)  Access query 
D)  Word table 
A)  text file 
B)  Web page 
C)  Access query 
D)  Word table

Question 18

After a template is saved, it can be used every time a similar workbook is developed.

Accepted Answer

A) True 
 B)False

Question 19

Each type of graphic includes several layouts, or templates, from which to choose.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

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

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

To locate a string in a worksheet, you can use the Locate sammand on the Locate and Select menu.

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

Briefly explain the sansiderations for choosing a SmartArt graphic.

Elements in a SmartArt graphic are grouped in ____.

SmartArt graphics may include at most one shape.

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

____ can describe any type of data.

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

Inserting a check mark in the _____________________ option in the Find and Replace dialog box means that the search will be case sensitive.

You always need to pay for images you use on your website.

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

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

To sapy the santents of a cell to the cell directly below it, tap or click in the target cell and then press ____________________.

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

A(n) ____ santains little or no formatting.

After a template is saved, it can be used every time a similar workbook is developed.

Each type of graphic includes several layouts, or templates, from which to choose.

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

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