Exam 8: Excell: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots

Explore all topics

A(n) ____ is a special-purpose workbook you can create and then use as a pattern to create new, similar workbooks or worksheets.

(Multiple Choice)

4.9/5

(30)

Question 61

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.

(Short Answer)

4.9/5

(33)

Question 62

Excel's Transpose command requires that the ____________________ of the transposed data be different from the destination.

(Short Answer)

4.8/5

(33)

Question 63

Modified Multiple Choice Which of the following are reasons to use a Web query instead of copying and pasting data from a webpage?

(Multiple Choice)

4.9/5

(34)

Question 64

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

(True/False)

4.9/5

(30)

Question 65

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

(Short Answer)

4.7/5

(31)

Question 66

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

(True/False)

4.9/5

(31)

Question 67

Excel allows you to take a ____ of any open window and add it to a workbook.

(Multiple Choice)

4.9/5

(34)

Question 68

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

(Multiple Choice)

4.8/5

(35)

Question 69

Briefly describe planning considerations before you begin importing data.

(Essay)

4.9/5

(38)

Question 70

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

(Multiple Choice)

4.9/5

(35)

Question 71

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

(Multiple Choice)

4.7/5

(40)

Question 72

When you bring in data from various external sources into an Excel worksheet, this is known as ____________________ that data.

(Short Answer)

4.7/5

(38)

Question 73

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

(Multiple Choice)

4.8/5

(42)

Question 74

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

(Multiple Choice)

4.9/5

(35)

Question 75

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

(Multiple Choice)

4.9/5

(31)

Question 76

Identify the letter of the choice that best matches the phrase or definition.

Premises:

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

Responses:

template

fixed width file

Web query

Correct Answer:

Verified

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

(Matching)

4.9/5

(40)

Question 77

You can click the ____________________ button (DATA tab | Get External Data group) to display the Select Data Source dialog box and then import a table from an Access database.

(Short Answer)

4.8/5

(33)

Question 78

____ can describe any type of data.

(Multiple Choice)

4.9/5

(26)

Question 79

You can select any range of cells with entries surrounded by blank cells by tapping or clicking a cell in the range and then pressing ____.

(Multiple Choice)

5.0/5

(38)

Question 80

Showing 61 - 80 of 112

A(n) ____ is a special-purpose workbook you can create and then use as a pattern to create new, similar workbooks or worksheets.

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.

Excel's Transpose command requires that the ____________________ of the transposed data be different from the destination.

Modified Multiple Choice Which of the following are reasons to use a Web query instead of copying and pasting data from a webpage?

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

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

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

Excel allows you to take a ____ of any open window and add it to a workbook.

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

Briefly describe planning considerations before you begin importing data.

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

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

When you bring in data from various external sources into an Excel worksheet, this is known as ____________________ that data.

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.

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

You can click the ____________________ button (DATA tab | Get External Data group) to display the Select Data Source dialog box and then import a table from an Access database.

____ can describe any type of data.

You can select any range of cells with entries surrounded by blank cells by tapping or clicking a cell in the range and then pressing ____.

Access: Creating Reports and Forms

Access: Multiple-Table Forms

Access: Advanced Report Techniques

Access: Advanced Form Techniques

Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Excell: Working With Multiple Worksheets and Workbooks

Excell: Creating, Sorting, and Querying a Table

Outlook : Managing Contacts and Personal Contact Information With Outlook

Powerpoint: Creating and Formatting Information Graphics Question

Powerpoint: Collaborating on and Delivering a Presentation Question

Powerpoint: Navigating Presentations Using Hyperlinks and Action Buttons

Powerpoint: Creating a Self-Running Presentation Containing Animation

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

Word: Generating Form Letters, Mailing Labels, and a Directory

Word: Creating a Newsletter With a Pull-Quote and Graphics

Filters