Application Software

In MS Word 2007, which shortcut key is used to view A “Print Preview” of a document?

• (A) ALT + CTRL + P
• (B) ALT + SHIFT + R
• (C) ALT + CTRL + I
• (D) ALT + SHIFT + P

In MS Word 2007, which shortcut key is used to switch to Outline view?

• (A) ALT + CTRL + P
• (B) ALT + SHIFT + O
• (C) ALT + SHIFT + P
• (D) ALT + CTRL + O

Which option displays fill color in alternate rows in an Excel Table?

• (A) Banded Rows
• (B) First Row
• (C) Last Row
• (D) Filled Rows

What function displays row data in a column or column data in a row?

• (A) Hyperlink
• (B) Transpose
• (C) Index
• (D) Rows

When typing character search criteria, Excel matches fields based on?

• (A) Alphabetical order
• (B) Capitalization
• (C) Spelling
• (D) Primary records

What does an I-beam facilitate?

• (A) Locating text
• (B) Highlighting text
• (C) Dragging and selecting text
• (D) Formatting text 

Which function automatically totals a column or row of values?

• (A) TOTAL
• (C) SUM
• (5) ADD
• (D) AVG

The information inside your table needs to be sorted alphabetically. To do this, you go to:

• (A) Table Tools Design
• (B) Page Layout
• (C) Home tab > M Paragraph group
• (D) Tale Tools Layout

Why might you hide worksheets in a workbook?

• (A) The fie is smaller
• (B) The file is larger
• (C) Some data is private
• (D) Some data formatted

User developed instructions for Excel are called:

• (A) Programs
• (B) Procedures
• (C) Macros
• (D) All of these