Question 1

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 2

It is not possible to replicate formulas after sampleting an import, so be sure to samplete the replication before the import.

Accepted Answer

The statement is incorrect because it is possible to replicate formulas after importing data. The process of "sampleting" is not a recognized term in data handling or formula replication.

Question 3

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

Accepted Answer

This statement is false. Using the screen shot feature, you can capture the entire screen, specific sections of the screen, and individual windows.

Question 4

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

Accepted Answer

The answer of When you bring in data from various...

Question 5

SmartArt graphics may include at most one shape.

Accepted Answer

SmartArt graphics can include multiple shapes arranged in a variety of layouts.

Question 6

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

When a new shape is added to a SmartArt graphic, Excel will automatically rearrange the shapes in the graphic to fit into the same space. This ensures the SmartArt graphic maintains its design and appearance.

Question 7

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

When you import a table from Access into Excel, the table is not formatted with any table style, it is simply a plain table without any formatting.

Question 8

Saving a template is similar to saving a workbook, except that the file type, Master File is selected in the Save as type box in the Save As dialog box.

Accepted Answer

Excel Template

Question 9

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

Accepted Answer

There is no "Locate" command in Excel; the correct command is "Find" under the "Find & Select" menu.

Question 10

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

Accepted Answer

There are many free images available on the internet that can be used on a website, as long as they are properly sourced and credited. However, it is important to check the terms and conditions of use for each image to ensure that it is legally allowed to be used on a website. Additionally, there may be some images that require a license or payment to use.

Question 11

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

Accepted Answer

The answer of You should not credit the source of...

Question 12

You often replicate formulas after sampleting an import because the total number of resards to be imported usually is unknown.

Accepted Answer

The total number of records to be imported is usually unknown, so it is necessary to replicate formulas after sampling an import.

Question 13

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

Accepted Answer

Excel allows you to import formatting from various sources such as other Excel workbooks, HTML pages, and text files.

Question 14

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 15

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

Accepted Answer

Each type of graphic in a design software typically includes multiple pre-designed layouts, also known as templates, that users can choose from.

Question 16

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

Accepted Answer

This statement is true. The Find and Replace dialog box can either display minimal options or all available options depending on the user's preference.

Question 17

Deployments are most helpful when you need to create several similar or identical workbooks.

Accepted Answer

Templates

Question 18

Creating a(n) ____________________, such as that shown in the acsampanying figure, involves the same basic steps used to create a workbook.

Accepted Answer

The answer of  Creating a(n) ____________________, such as that...

Question 19

When importing data into a workbook, it is sammon to receive text files with fields of data separated by sammas .

Accepted Answer

Text files often use commas as field separators, making it common to encounter text files with comma-separated fields.

Question 20

The only difference between developing a workbook and a template is the ____________________ used to save the template.

Accepted Answer

The answer of The only difference between developing a workbook...

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