Exam 7: Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots
Exam 1: Creating a Worksheet and a Chart112 Questions
Exam 2: Formulas,Functions,and Formatting111 Questions
Exam 3: Working With Large Worksheets,Charting,and What-If Analysis111 Questions
Exam 4: Financial Functions,Data Tables,and Amortization Schedules110 Questions
Exam 5: Working With Multiple Worksheets and Workbooks109 Questions
Exam 6: Creating,sorting,and Querying a Table111 Questions
Exam 7: Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots111 Questions
Exam 8: Office 2013 and Windows 8 Essential Concepts and Skills112 Questions
Select questions type
Which of the following are reasons to use a Web query instead of copying and pasting data from a webpage?
(Multiple Choice)
4.8/5
(35)
The only difference between developing a workbook and a template is the ____________________ used to save the template.
(Short Answer)
5.0/5
(30)
Briefly describe planning considerations before you begin importing data.
(Essay)
4.9/5
(36)
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A popular format for data exchange.
(Multiple Choice)
5.0/5
(40)
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Method to import an Access table into an Excel worksheet when both applications are open.
(Multiple Choice)
4.8/5
(32)
-Creating a(n)____________________,such as that shown in the accompanying figure,involves the same basic steps used to create a workbook.

(Short Answer)
4.9/5
(27)
The Import Data dialog box allows you to choose whether to import the data into a ____.
(Multiple Choice)
4.9/5
(37)
To create an exact copy of a formula without replication,hold down the ____ key while dragging the fill handle.
(Multiple Choice)
4.8/5
(39)
Importing ____ provides greater flexibility to manipulate text in Excel.
(Multiple Choice)
4.9/5
(43)
When you import a table from Access into Excel,the table is formatted with the default table style for the database's theme.
(True/False)
4.8/5
(30)
When Excel imports a database table,the data is placed in an Excel ____.
(Multiple Choice)
5.0/5
(28)
When a template is created,dummy ____ is / are used to verify the formulas in the template.
(Multiple Choice)
4.9/5
(32)
Because ____ help speed and simplify work,many Excel users create one for each project on which they work.
(Multiple Choice)
4.9/5
(31)
You should not credit the source of an image unless you can specifically name the image creator.
(True/False)
4.8/5
(30)
The data you search for with the Find command sometimes is called the ____________________.
(Short Answer)
4.7/5
(44)
Only images that are ____ are free for anyone to use without permission.
(Multiple Choice)
4.9/5
(40)
A screen ____ is a portion,usually of one object or section of a window,of the screen.
(Multiple Choice)
4.8/5
(39)
Showing 21 - 40 of 111
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)