SECTION 4
Review Questions

   

 

 

1.         When you link Excel data to a Word document

A.                  The Excel data will be updated when the original worksheet changes

B.                 The size of your Word file will not increase substantially

C.                 You can edit the data in an Excel environment

D.                 All of the above.

 

 

2.         Which of the following is not a valid way to include Excel data in a Word document?

A.                  Enter the data by typing

B.                 Copy and paste the data

C.                 Open the Word file as an Excel workbook and enter the data

D.                 Link the Excel data to the word document

 

 

3.         Which one of the following statements is false?

A.                  Word you can create a link to Excel data by using paste special

B.                 A linked worksheet is different from an embedded worksheet

C.                 An embedded worksheet will not increase the size of your Word file

D.                 Linked data can be automatically updated

 

 

4.         Which of the following statements is true?

A.                  You can send Excel Data as an attachment, or as a simple mail message

B.                 Workbooks cannot be sent as e-mail attachments

C.                 e-mail attachments cannot carry viruses

D.                 You cannot send e-mail from within Excel

 

 

5.         An Excel file can be saved as

A.                  A text file

B.                 A CSV file

C.                 An .xls file

D.                 All of the above

 

 

6.         To get data from a text file into Excel you can

A.                  Import the data

B.                 Type the data directly

C.                 Use a text editor to save the text file as an Excel workbook

D.                 A or B

 

 

7.         Which of the following statements is true for Excel 2003?

A.                  To import data from a database you need to use a query

B.                 You cannot import data from a database without a query

C.                 You cannot import data from a database

D.                 None of the above

 

 

8.         To refresh data that is imported from a database to Excel

A.                  Click the red exclamation button on the status bar

B.                 Click the blue link on the database task pane

C.                 Select Edit->Refresh Data from the edit menu

D.                 You cannot refresh data that has been imported to Excel

 

 

9.         An .mdb file extension indicates what type of file?

A.                  A comma separated value file

B.                 An Excel template file

C.                 A macro

D.                 An Access database file

 

 

10.       To import data from another program you should choose

A.                  Edit->Import->

B.                 Tools->Insert Data->

C.                 Data->Import External Data->

D.                 File->Open as External data->