Question 1

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.

Accepted Answer

A)  ALT+O 
B)  CTRL+S 
C)  SHIFT+X 
D)  CTRL+V

Question 2

When saving a template, and the Excel Template file type is chosen in the ____________________ box in the Save As dialog box, Excel automatically changes the location to the appropriate folder created when Office 2013 was installed.

Accepted Answer

The answer of When saving a template, and the Excel...

Question 3

Importing data into Excel can create a(n) ____________________ link that can be used to update data whenever the original file changes.

Accepted Answer

The answer of Importing data into Excel can create a(n)...

Question 4

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 5

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

Accepted Answer

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

Question 6

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...

Question 7

Some spreadsheet specialists refer to copying formulas as ____________________.

Accepted Answer

The answer of Some spreadsheet specialists refer to copying formulas...

Question 8

-Excel includes ____ types of SmartArt graphics, an example of which appears in the accompanying figure.

Accepted Answer

A)  9 
B)  19 
C)  90 
D)  99

Question 9

To rotate pictures in Excel, select the image to be rotated, then tap or click the ____ button (PICTURE TOOLS FORMAT tab | Arrange group).

Accepted Answer

A)  Rotate Objects 
B)  Turn Picture 
C)  Move Objects 
D)  Reorientation

Question 10

Which of the following is the path to the 'Get Data From Text' button?

Accepted Answer

A)  (DATA tab | Get External Data group) 
B)  (HOME tab | Import Data group) 
C)  (GET EXTERNAL DATA tab | Text group) 
D)  (TEXT tab | Import Data group)

Question 11

A(n) ____ contains little or no formatting.

Accepted Answer

A)  text file 
B)  Web page 
C)  Access query 
D)  Word table

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Case 7-1
Laura, in Personnel, needs to create a new payroll workbook each month. The formatting and formulas are the same in each new workbook; only the payroll data is different. During a conversation at lunch, she asks if you have any suggestions for ways she can save time with this workbook setup task.
-Laura was so impressed with your helpful suggestion for the payroll workbook that she gives you a call about another issue. She has just been told that some of the branch office payroll data will now be available in an Access database table. She is unfamiliar with Access and asks you if there is an easy way to get the Access table data into the payroll workbook. You tell her that she can _____.

Accepted Answer

A)  import the Access table using an ASCII table modifier downloaded from the IT department's Web site 
B)  open the Access database and the Excel workbook and then drag the Access table to the desired location on a worksheet in the payroll workbook 
C)  open the Access database, print the table's datasheet, and then manually enter the data on the printout in a worksheet in the payroll workbook 
D)  have the branch offices copy the Access table, paste it on the branch office webpage, and then create a Web query to import the data into the payroll workbook

Question 14

You can select any range of cells with entries surrounded by blank cells by tapping or clicking a cell in the range and then pressing ____.

Accepted Answer

A)  CTRL+ASTERISK 
B)  SHIFT+AMPERSAND 
C)  CTRL+SHIFT+ASTERISK 
D)  CTRL+SHIFT+AMPERSAND

Question 15

What are the steps to insert an individual image into a workbook?

Accepted Answer

The answer of What are the steps to insert an...

Question 16

To copy the contents of a cell to the cell directly below it, tap or click in the target cell and then press ____________________.

Accepted Answer

The answer of To copy the contents of a cell...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is the path to the 'Insert a SmartArt Graphic' button?

Accepted Answer

A)  (DESIGN tab | Illustrations group) 
B)  (INSERT tab | Images group) 
C)  (INSERT tab | Illustrations group) 
D)  (VIEW tab | Insert SmartArt group)

Question 19

____ a shape within a SmartArt graphic means moving it to a lower level.

Accepted Answer

A)  Descending 
B)  Demoting 
C)  Reducing 
D)  Rasterizing

Question 20

You can access the Find and Replace feature by pressing the ____ key(s).

Accepted Answer

A)  ALT+H 
B)  CTRL+R 
C)  F11 
D)  CTRL+H

Exam 8: Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet