1.                  How do you insert an existing Excel worksheet into your document?

A.                  Click the Insert menu, click Object, and click the Create From File tab. Then you can browse to your file and click OK to complete the process.

B.                 Click the Insert menu and click Excel Worksheet.

C.                 Any of the above.

D.                 None of the above.

 

 

2.                  You have typed data in four cells in the row. How would you add up these four cells?

A.                  It’s not possible, so we would copy the data into Excel and use its commands.

B.                 Create a chart.

C.                 Press Ctrl and S.

D.                 Place your cursor in cell number 5 and click the AutoSum button.

 

 

3.                  How do you automatically turn your table into a chart?

A.                  It is not possible; you must copy your data into Excel.

B.                 Click the Insert menu and click Chart.

C.                 Select your table, click the Insert menu, click Object, and click the Create New tab. Then, click Microsoft Graph Chart and click OK.

D.                 Click the Insert menu and click Diagram.

 

 

4.                  When converting table to a text, which of the following is not a default separator choice?

A.                  Spaces

B.                 Paragraph Marks

C.                 Commas

D.                 Tabs

 

 

5.                  What is a section break?

A.                  It’s an invisible way to lay the groundwork for your document so different formats and items can be applied.

B.                 It marks the beginning of every new page.

C.                 It is a tool used for outlines.

D.                 It marks where headers and footers begin and end.

 

 

6.                  You’ve just gone out and purchased a giant collection of ClipArt. Which application would you use to add that collection to your current one?

A.                  Microsoft Office Picture Manager

B.                 Microsoft Office PowerPoint 2003

C.                 Microsoft Clip Organizer

D.                 Microsoft Office Publisher 2003

 

 

7.                  What task cannot be performed with the Research Pane?

A.                  Look up a word’s meaning.

B.                 Search encyclopaedia results on a word.

C.                 AutoSummarize your document.

D.                 Translate a word or phrase.

 

 

8.                  Which item is not an AutoSummarize option?

A.                  Highlight key points in existing document

B.                 Create summary in new document

C.                 Insert abstract into the existing document

D.                 Create summary (with key points highlighted) in new document

 

 

9.                  Which command will not open the Thesaurus?

A.                  F7

B.                 Shift + F7

C.                 Tools – Language - Thesaurus

D.                 All of these commands will open the Thesaurus.

 

 

10.              How do you open the Sort dialog?

A.                  Sort Ascending button

B.                 Sort Descending button

C.                 Sort menu on the Tables and Borders toolbar

D.                 Table - Sort