Question: Which function automatically totals a column or row of values?

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

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

• 1. Home tab > paragraph group
• 2. Page layout
• 3. Table tools design
• 4. Table tools layout

Question: Which option displays fill color in alternate in an excel table?

• 1. First Row
• 2. Filled Rows
• 3. Banded Rows
• 4. Last Row

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