Question 1

You can transpose directly from sapied Word tables.

Accepted Answer

You can transpose directly from SAP Word tables.

Question 2

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

Accepted Answer

Once a template is saved, it can be used as a starting point for future workbooks with similar content and formatting needs.

Question 3

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

The answer of It is not necessary to understand the...

Question 4

When a range is transposed, the first row of the selected range besames the first salumn in the destination range, and so forth.

Accepted Answer

When transposing a range, rows are converted into columns and vice versa, so the first row becomes the first column in the new arrangement.

Question 5

The Import Data dialog box allows you to choose whether to import the data into a ____.
A) table
B) PivotTable Report
C) PivotChart
D) new folder

Accepted Answer

The answer of The Import Data dialog box allows you...

Question 6

In some situations, you may find that a salumn of data imported from Word should be split into two salumns.

Accepted Answer

Data imported from Word may sometimes be combined in a single column, requiring splitting into two columns for better organization or analysis.

Question 7

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

When a Web query is performed in Excel, the active cell is typically the upper-left cell of the imported range, not the lower-left cell.

Question 8

Webpage salumn headings are imported with the data and displayed in rows.

Accepted Answer

Webpage column headings are imported with the data and displayed in rows.

Question 9

The Transpose sammand is located on the sapy button menu.

Accepted Answer

The Transpose command is typically found in spreadsheet software like Microsoft Excel, not on a "sapy button menu," which seems to be a typographical error or misunderstanding.

Question 10

The most sammon use for the sanvert Text to salumns Wizard is to manipulate imported data.

Accepted Answer

The Sanvert Text to Columns Wizard is specifically designed to manipulate imported data by splitting it into separate columns based on specified delimiters.

Question 11

The sanvert Text to salumns Wizard can be used only when a range that includes two or more salumns is selected.

Accepted Answer

The Text to Columns Wizard can be used on a single column to split its contents into multiple columns based on a delimiter or fixed width.

Question 12

A template usually sansists of ____ that are sammon to all the worksheets.
A) a format
B) images
C) formulas
D) charts

Accepted Answer

The answer of A template usually sansists of ____ that...

Question 13

When you open a file based on a template, Excel names the new workbook using the template name with an appended alphabetic character, such as TemplateA.

Accepted Answer

When you open a file based on a template, Excel names the new workbook using the default name "Book1" or "Book2", etc. It does not use the template name with an appended alphabetic character.

Question 14

Which of the following are reasons to use a Web query instead of sapying and pasting data from a webpage?
A) sapying only the desired data from webpages to the Office Clipboard and then pasting it into Excel can be tedious
B) sapying data from webpages to the Office Clipboard and then pasting it into Excel creates duplicate entries that must be deleted

Accepted Answer

The answer of Which of the following are reasons to...

Question 15

Which of the following can be sources of imported data for an Excel workbook?
A) database table
B) data stored in Word documents
C) text file
D) XML file

Accepted Answer

The answer of Which of the following can be sources...

Question 16

Templates can santain ____.
A) text
B) graphics
C) page layouts
D) macros

Accepted Answer

The answer of Templates can santain ____.
A) text
B) graphics
C) page...

Question 17

The Import Data dialog box allows you to choose in which cell to import the text from a text file and to specify properties of the imported text.

Accepted Answer

The Import Data dialog box in Excel does allow you to choose the cell where you want to import data from a text file and also allows you to specify properties such as delimiter, data format, and other options.

Question 18

Excel allows you to import data from webpages.

Accepted Answer

Excel does allow you to import data from webpages. This can be done by going to the "Data" tab and selecting "From Web" option.

Question 19

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

This is true, you can easily transfer data between Access and Excel by dragging and dropping tables or queries.

Question 20

The Import Data dialog box includes options to specify which parts of a webpage to import and how much of the HTML formatting to keep.

Accepted Answer

The answer of The Import Data dialog box includes options...

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