Question 1

Using the screen shot feature, you can capture whole windows only.

Accepted Answer

A) True 
 B)False

Question 2

HTML stands for ____________________ .

Accepted Answer

Hypertext

Question 3

Critical Thinking Questions 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 
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 4

Match between columns
                        Premises: Another term for copying formulas.

Accepted Answer

The Answer of dummy data and drag and drop and is...

Question 5

Only images that are ____ are free for anyone to use without permission.

Accepted Answer

A)  trademarked 
B)  copyrighted 
C)  in the public domain 
D)  shareware 
A)  trademarked 
B)  copyrighted 
C)  in the public domain 
D)  shareware

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

To locate a string in a worksheet, you can use the Locate command on the Locate and Select menu.

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: Sample data used in place of actual data to verify formulas in a template.

Accepted Answer

The Answer of external data and replication and template and is...

Question 9

Which of the following is the path to the Text to Columns button?

Accepted Answer

Question 10

Match between columns
                        Premises: Switched rows and columns for imported data.

Accepted Answer

The Answer of Web query and XML and transposed and is...

Question 11

Because ____ help speed and simplify work, many Excel users create one for each project on which they work.

Accepted Answer

A)  indices 
B)  filters 
C)  text files 
D)  templates 
A)  indices 
B)  filters 
C)  text files 
D)  templates

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Elements in a SmartArt graphic are grouped in ____.

Accepted Answer

A)  aggregates 
B)  clusters 
C)  levels 
D)  fields 
A)  aggregates 
B)  clusters 
C)  levels 
D)  fields

Question 14

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

Accepted Answer

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

Question 15

Modified Multiple Choice Templates can contain ____.

Accepted Answer

A)  text 
B)  graphics 
C)  page layouts 
D)  macros 
A)  text 
B)  graphics 
C)  page layouts 
D)  macros

Question 16

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 17

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 
A)  9 
B)  19 
C)  90 
D)  99

Question 18

By default, the cell that is active when a Web query is performed will become the lower-left cell of the imported range.

Accepted Answer

A) True 
 B)False

Question 19

You always need to pay for images you use on your website.

Accepted Answer

A) True 
 B)False

Question 20

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 
A)  Rotate Objects 
B)  Turn Picture 
C)  Move Objects 
D)  Reorientation

Using the screen shot feature, you can capture whole windows only.

HTML stands for ____________________ .

Only images that are ____ are free for anyone to use without permission.

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

To locate a string in a worksheet, you can use the Locate command on the Locate and Select menu.

Which of the following is the path to the Text to Columns button?

Because ____ help speed and simplify work, many Excel users create one for each project on which they work.

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

Elements in a SmartArt graphic are grouped in ____.

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

Modified Multiple Choice Templates can contain ____.

The only difference between developing a workbook and a template is the ____________________ used to save the template.

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

By default, the cell that is active when a Web query is performed will become the lower-left cell of the imported range.

You always need to pay for images you use on your website.

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

Access: Creating Reports and Forms

Access: Multiple-Table Forms

Access: Advanced Report Techniques

Access: Advanced Form Techniques

Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Excell: Working With Multiple Worksheets and Workbooks

Excell: Creating, Sorting, and Querying a Table

Outlook : Managing Contacts and Personal Contact Information With Outlook

Powerpoint: Creating and Formatting Information Graphics Question

Powerpoint: Collaborating on and Delivering a Presentation Question

Powerpoint: Navigating Presentations Using Hyperlinks and Action Buttons

Powerpoint: Creating a Self-Running Presentation Containing Animation

Word: Using a Template to Create a Resume and Sharing a Finished Document

Word: Generating Form Letters, Mailing Labels, and a Directory

Word: Creating a Newsletter With a Pull-Quote and Graphics

Filters

Exam 8: Excell: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots

Using the screen shot feature, you can capture whole windows only.

HTML stands for ____________________ .

Only images that are ____ are free for anyone to use without permission.

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

To locate a string in a worksheet, you can use the Locate command on the Locate and Select menu.

Which of the following is the path to the Text to Columns button?

Because ____ help speed and simplify work, many Excel users create one for each project on which they work.

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

Elements in a SmartArt graphic are grouped in ____.

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

Modified Multiple Choice Templates can contain ____.

The only difference between developing a workbook and a template is the ____________________ used to save the template.

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

By default, the cell that is active when a Web query is performed will become the lower-left cell of the imported range.

You always need to pay for images you use on your website.

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

Access: Creating Reports and Forms

Access: Multiple-Table Forms

Access: Advanced Report Techniques

Access: Advanced Form Techniques

Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Excell: Working With Multiple Worksheets and Workbooks

Excell: Creating, Sorting, and Querying a Table

Outlook : Managing Contacts and Personal Contact Information With Outlook

Powerpoint: Creating and Formatting Information Graphics Question

Powerpoint: Collaborating on and Delivering a Presentation Question

Powerpoint: Navigating Presentations Using Hyperlinks and Action Buttons

Powerpoint: Creating a Self-Running Presentation Containing Animation

Word: Using a Template to Create a Resume and Sharing a Finished Document

Word: Generating Form Letters, Mailing Labels, and a Directory

Word: Creating a Newsletter With a Pull-Quote and Graphics

Filters