Question: Before you create labels such as name tags specify the size by selecting?

• 1. Layout
• 2. Templates
• 3. Format
• 4. Label Options

Question: Protecting a worksheet means?

• 1. No cell in a worksheet can be changed.
• 2. Saving the workbook in a hidden folder
• 3. No additional change can be made to a worksheet
• 4. To lock cells in the worksheet so that a user can not inadvertently change them

Question: What term describes a feature that give Excel enhanced capability?

• 1. Thumbnail
• 2. Trend lining
• 3. Enhancement bit
• 4. Add-in

Question: You can evenly adjust spacing in columns and rows by using the Table Tool called?

• 1. Distribute
• 2. Equalize
• 3. Mirror
• 4. Snap to Grid

Question: When you want to combine cells in any given table row you?

• 1. Join
• 2. Link
• 3. Simplify
• 4. Merge

Question: Where is the address of active cell displayed?

• 1. Name Box
• 2. Row Heading
• 3. Formula Bar
• 4. Status Bar

Question: Excel would evaluate the formula =2010/58 and return this answer?

• 1. 230
• 2. 320
• 3. 311
• 4. 298

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