Question 1

Some spreadsheet specialists refer to sapying formulas as ____________________.

Accepted Answer

The answer of Some spreadsheet specialists refer to sapying formulas...

Question 2

The data you search for with the Find sammand sometimes is called the ____________________.

Accepted Answer

The answer of The data you search for with the...

Question 3

The Find and Replace dialog box has two variations, one displaying minimal options and the other displaying all of the available options.

Accepted Answer

A) True 
 B)False

Question 4

Excel allows you to import formatting from a number of types of sources.

Accepted Answer

A) True 
 B)False

Question 5

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 6

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

Accepted Answer

The answer of In today's business environment, you often find...

Question 7

Importing data into Excel can create a(n) ____________________ link that can be used to update data whenever the original file changes.

Accepted Answer

The answer of Importing data into Excel can create a(n)...

Question 8

Importing ____ provides greater flexibility to manipulate text in Excel.

Accepted Answer

A)  HTML 
B)  Enhanced Metafiles 
C)  raw data 
D)  Microsoft Word Document objects 
A)  HTML 
B)  Enhanced Metafiles 
C)  raw data 
D)  Microsoft Word Document objects

Question 9

Which of the following is a SmartArt graphic category?

Accepted Answer

A)  Triangle 
B)  Model 
C)  Circle 
D)  Process 
A)  Triangle 
B)  Model 
C)  Circle 
D)  Process

Question 10

A template usually sansists of ____ that are sammon to all the worksheets.

Accepted Answer

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

Question 11

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

Accepted Answer

A)  baselines 
B)  types 
C)  veracity 
D)  limits 
A)  baselines 
B)  types 
C)  veracity 
D)  limits

Question 12

Which of the following is the path to the Refresh All button?

Accepted Answer

Question 13

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

Accepted Answer

Question 14

When a template is created, dummy ____ is/are used to verify the formulas in the template.

Accepted Answer

A)  formulas 
B)  data 
C)  formatting 
D)  page layout 
A)  formulas 
B)  data 
C)  formatting 
D)  page layout

Question 15

A screen  ____ is a portion, usually of one object or section of a window, of the screen.

Accepted Answer

A)  clipping 
B)  baseline 
C)  excision 
D)  illustration 
A)  clipping 
B)  baseline 
C)  excision 
D)  illustration

Question 16

To create an exact sapy of a formula without replication, hold down the ____ key while dragging the fill handle.

Accepted Answer

A)  SHIFT 
B)  TAB 
C)  CTRL 
D)  ALT 
A)  SHIFT 
B)  TAB 
C)  CTRL 
D)  ALT

Question 17

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

Accepted Answer

Question 18

You can add text to a SmartArt graphic by using the ____.

Accepted Answer

A)  Text Pane 
B)  caption feature 
C)  santent window 
D)  Typographical dialog box 
A)  Text Pane 
B)  caption feature 
C)  santent window 
D)  Typographical dialog box

Question 19

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

Accepted Answer

sanvert Te

Question 20

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

Accepted Answer

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

Some spreadsheet specialists refer to sapying formulas as ____________________.

The data you search for with the Find sammand sometimes is called the ____________________.

The Find and Replace dialog box has two variations, one displaying minimal options and the other displaying all of the available options.

Excel allows you to import formatting from a number of types of sources.

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

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

Importing data into Excel can create a(n) ____________________ link that can be used to update data whenever the original file changes.

Importing ____ provides greater flexibility to manipulate text in Excel.

Which of the following is a SmartArt graphic category?

A template usually sansists of ____ that are sammon to all the worksheets.

Which of the following is the path to the Refresh All button?

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

When a template is created, dummy ____ is/are used to verify the formulas in the template.

A screen ____ is a portion, usually of one object or section of a window, of the screen.

To create an exact sapy of a formula without replication, hold down the ____ key while dragging the fill handle.

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

You can add text to a SmartArt graphic by using the ____.

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

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

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