Chapter 7

11 September 2022
4.7 (114 reviews)
67 test answers

Unlock all answers in this set

Unlock answers (63)
question
The ____ provides step-by-step instructions for importing data from a text file into an Excel worksheet.
answer
Text Import Wizard
question
A ____ file contains data fields separated by a selected character.
answer
delimited
question
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.
answer
False
question
The Transpose command is located on the Copy button menu.
answer
False
question
Excel allows you to import data from webpages
answer
true
question
Excel allows you to take a ____ of any open window and add it to a workbook.
answer
screen shot
question
You always need to pay for images you use on your website.
answer
False
question
All of the following are formats accepted for picture files EXCEPT ____.
answer
.mp3
question
A Word document often contains data stored in a(n) ____ that can then be copied and pasted into an Excel worksheet.
answer
table
question
Deployments are most helpful when you need to create several similar or identical workbooks
answer
False
question
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.
answer
true
question
A(n) ____ contains little or no formatting
answer
text file
question
When Excel imports a database table, the data is placed in an Excel ____.
answer
table
question
Importing ____ provides greater flexibility to manipulate text in Excel.
answer
raw data
question
The Convert Text to Columns Wizard can be used only when a range that includes two or more columns is selected.
answer
False
question
You can add text to a SmartArt graphic by using the ____.
answer
Text Pane
question
You can select any range of cells with entries surrounded by blank cells by clicking a cell in the range and then pressing ____.
answer
CTRL + SHIFT + ASTERISK
question
Excel allows you to import formatting from a number of types of sources
answer
true
question
The most common use for the Convert Text to Columns Wizard is to manipulate imported data.
answer
True
question
____ can describe any type of data.
answer
XML
question
Which of the following is the path to the Get Data From Web button?
answer
(DATA tab | Get External Data group)
question
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.
answer
false
question
You can transpose directly from copied Word tables.
answer
False
question
A ____ is a way to qualify the data to import by specifying a matching condition or asking a question of a database.
answer
query
question
A screen ____ is a portion, usually of one object or section of a window, of the screen.
answer
clipping
question
When you import a table from Access into Excel, the table is formatted with the default table style for the database's theme.
answer
false
question
SmartArt graphics may include at most one shape
answer
False
question
HTML stands for Hypertext Markup Language
answer
true
question
You should not credit the source of an image unless you can specifically name the image creator
answer
False
question
In some situations, you may find that a column of data imported from Word should be split into two columns
answer
true
question
It is not necessary to understand the layout of data you want to import; Excel automatically arranges each data element in the worksheet
answer
False
question
When a template is created, dummy ____ is/are used to verify the formulas in the template.
answer
data
question
Clicking the ____ button changes a SmartArt graphic to individual shapes that can be resized, moved, or deleted independently of the others.
answer
Convert to Shapes
question
Which of the following is the path to the Format Painter button?
answer
(HOME tab | Clipboard group)
question
After a template is saved, it can be used every time a similar workbook is developed
answer
true
question
The WordArt graphic is a customizable diagram that you use to pictorially present lists, processes, and relationships
answer
False
question
Because ____ help speed and simplify work, many Excel users create one for each project on which they work.
answer
templates
question
You can access the Find and Replace feature by pressing the ____ key(s)
answer
CTRL+H
question
Webpage column headings are imported with the data and displayed in rows.
answer
true
question
A(n) ____ is a special-purpose workbook you can create and then use as a pattern to create new, similar workbooks or worksheets.
answer
template
question
Which of the following is the path to the 'Take a Screenshot' button?
answer
(INSERT tab | Illustrations group)
question
Excel includes ____ types of SmartArt graphics
answer
9
question
When a range is transposed, the first row of the selected range becomes the first column in the destination range, and so forth
answer
true
question
Each type of graphic includes several layouts, or templates, from which to choose.
answer
true
question
In some cases, when you import data, the data will need to be ____, meaning that the rows and columns need to be switched
answer
transposed
question
You often replicate formulas after completing an import because the total number of records to be imported usually is unknown
answer
true
question
Which of the following is a SmartArt graphic category?
answer
Process
question
Which of the following is the path to the Find & Select button?
answer
(Home tab | Editing group)
question
When importing data into a workbook, it is common to receive text files with fields of data separated by commas.
answer
true
question
When you add a new shape to a SmartArt graphic, Excel rearranges the shapes in the graphic to fit in the same area.
answer
true
question
Which of the following is the path to the 'Insert a SmartArt Graphic' button?
answer
(INSERT tab | Illustrations group)
question
For a file that does not yet have a file name, you can open the Save As dialog box to save a template by pressing the ____ keys
answer
CTRL+S
question
____ a shape within a SmartArt graphic means moving it to a higher level
answer
Promoting
question
It is not necessary to understand the layout of data you want to import; Excel automatically arranges each data element in the worksheet.
answer
False
question
Which of the following is NOT a SmartArt graphic category
answer
Microsoft.com
question
Using the screen shot feature, you can capture whole windows only
answer
False
question
Elements in a SmartArt graphic are grouped in ____.
answer
levels
question
Webpages use a file format called ____.
answer
HTML
question
Which of the following is the path to the 'Get Data From Text' button?
answer
(DATA tab | Get External Data group)
question
Which of the following is the path to the Text to Columns button?
answer
(Data tab | Data Tools group)
question
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.
answer
False
question
____ a shape within a SmartArt graphic means moving it to a lower level.
answer
Demoting
question
The Find and Replace dialog box has two variations, one displaying minimal options and the other displaying all of the available options.
answer
true
question
Which of the following is the path to the Refresh All button?
answer
(DATA tab | Connections group)
question
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.
answer
False
question
To locate a string in a worksheet, you can use the Locate command on the Locate and Select menu.
answer
false
question
Some spreadsheet specialists refer to copying formulas as replacing
answer
false