4. Which command combines several cells into one large separates?

a. Home-> Alignment->  Merge and Center

b. View->  Alignment->  Merge Cells

c. Home->  Cells->  Combine

d. Format->  Alignment->  Merge Cells

  Tip: Intermediate Excel, (page 58)

 

5. Which of the following is a type of Conditional Formatting? 

(Select all correct answers.)

a. Color Scales

b. Highlight

c. Color Bars

d. Icon Sets

  Tip: Intermediate Excel, page (65-9)

Test Yourself

1. Data Validation includes options to restrict the data in a cell by which criteria?  (Select all correct answers.)

a. Decimals

b. Whole Numbers

c. Dates

d. Times

e. Items from a Reference List

  Tip: Intermediate Excel, (page 49)

 

2. Which of the following are true about Data Validation options?  (Select all correct answers.)

a. An input message can be set to guide users

b. An error message can be set to alert users to a mistake

c. An error message is set by default by Excel

  Tip: Intermediate Excel, (page 50-1)

 

3. Graphics can be added to Excel Spreadsheets.

a. TRUE

b. FALSE

  Tip: Intermediate Excel, (page 56)