Question: Which alignment choice spreads the data across the width of the cell?

• 1. Distributed
• 2. Indent
• 3. Justify
• 4. Center

Question: User developed instructions for excel are called?

• 1. Macros
• 2. Programs
• 3. Procedures
• 4. None of the above

Question: Which function displays row data in a column or column data in a row?

• 1. Rows
• 2. Index
• 3. Hyperlink
• 4. Traspose

Question: To move to the previous cell in a table inserted in a document press?

• 1. Shift+Tab
• 2. The Tab Key
• 3. Backspace
• 4. Alt+Tab

Question: When inserting a graphic into a worksheet you could go to cell A1 by pressing?

• 1. Ctrl+Home
• 2. Alt+Home
• 3. Shift+Home
• 4. Enter+Home

Question: When typing character search criteria, excel matches fields based on?

• 1. Capitalization
• 2. Alphabetical order
• 3. Spelling
• 4. Primary records

Question: Why might you hide worksheets in a workbook?

• 1. The file is larger
• 2. The file is smaller
• 3. Some data is private
• 4. Some data is formatted

Question: Sort command of the data menu provides which capability?

• 1. Multiple-Field
• 2. Multiple-Table
• 3. Multiple-Column
• 4. Multiple-Row

Question: In MS Excel which function automatically totals a column or row of values?

• 1. AVG
• 2. ADD
• 3. TOTAL
• 4. SUM

Question: To create table in Ms excel which key is used?

• 1. Shift+T
• 2. Ctrl+Shift+T
• 3. Ctrl+T
• 4. Alt+T