Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
36 Cards in this Set
- Front
- Back
A(n)_____ is a special workbook you can create and then use as a pattern to create new, similar workbooks or worksheets.
|
Template
|
|
_____ can describe any type of data
|
XML
|
|
_____ help speed and simplify work because Excel users often work with the same types of problems repeatedly
|
Templates
|
|
When a template is created, dummy _____ is/are used.
|
Data
|
|
You can press the _____ key while dragging the fill handle to fill a series with numbers that increment by one.
|
CTRL
|
|
Which of the following is the path to the Fill button
|
(Home tab | Editing group)
|
|
When developing a template, you can modify the default color scheme by clicking the _____ tab, clicking the Colors button in the Themes group, and clicking a new color scheme in the gallery.
|
Page Layout
|
|
You can open the Save As dialog box to save a template by pressing the _____ keys
|
CTRL+S
|
|
If you click the New tab in Backstage view, the _____ gallery appears
|
New
|
|
Imported data that maintains a refreshable link to its external source is called _____ data.
|
External
|
|
A(n) _____ contains little or no formatting.
|
Text File
|
|
A _____ file contains data separated by a selected character
|
delimited
|
|
Which of the following is the path to the From Text button
|
(Data tab | Get External Data group)
|
|
The _____ provides step-by-step instructions for importing data from a text file into an Excel worksheet.
|
Text Import Wizard
|
|
Which of the following is the path to the Format Painter button?
|
(Home tab | Clipboard group)
|
|
Which of the following is the path to the Refresh All button?
|
(Data tab | Connections group)
|
|
A _____ is a way to qualify the data to import by specifying a matching condition or asking a question of a database.
|
Query
|
|
When Excel imports an Access table, the data is placed in a worksheet _____.
|
Table
|
|
Web pages use a file format called _____.
|
HTML
|
|
Which of the following is the path to the From Web button?
|
(Data tab | Get External Data group)
|
|
A Word document often contains data stored in a(n) _____ that can then be copied and pasted into an Excel worksheet
|
Table
|
|
Imported data may be easier to work with if the rows and columns are _____.
|
Transposed
|
|
In the Word program, the Copy and Paste buttons are located in the _____ group on the Home tab.
|
Clipboard
|
|
Importing Word data as _____ provides greater flexibility for manipulating and formatting the data in Excel
|
Text
|
|
Which of the following is the path to the Cut button?
|
(Home tab | Clipboard group)
|
|
Which of the following is the path to the Text to Columns button?
|
(Data tab | Data Tools group)
|
|
To create an exact copy of a formula without replication, hold down the _____ key while dragging the fill handle.
|
CTRL
|
|
Which of the following is the path to the Find & Select button?
|
(Home tab | Editing group)
|
|
A string can be a _____ in a cell on a worksheet.
|
all of the above
|
|
You can open the Find tab in the Find and Replace dialog box by pressing the _____ keys
|
CTRL+F
|
|
You can open the Replace in the Find and Replace dialog box by pressing the _____ keys.
|
CTRL+H
|
|
You can insert a Clustered Cone chart by clicking the _____ button (Insert tab | Charts group).
|
Column
|
|
Which of the following is the path to the Legend button?
|
(Chart Tools Layout tab | Labels group)
|
|
The WordArt text added to a worksheet is called a(n) _____.
|
object
|
|
Which of the following is the path to the WordArt button?
|
(Insert tab | Text group)
|
|
Which of the following is a SmartArt graphic category?
|
Process
|