Excel Lesson 6-9 Review

Which command is used to reduce the margin between the border and the text in an indented cell?

• Orientation  
• Decrease Indent  
• Column Width
• Alignment  

Which command is used to format a cell or selected cells quickly by choosing from a defined list of styles?

• Format as Table
• Cell Style
• Conditional Formatting  
• Form  

Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?

• Center  
• Merge and Center  
• Orientation  
• Wrap Text  

Carl notices the last two lines of text in cell B4 are not showing up in his spreadsheet. How could Carl format the cell to correct this problem?

• AutoFit  
• Special Formatting  
• Subscript Formatting  
• Merge  

Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D?

• Currency  
• Date  
• Number  

Which command on the Home Ribbon can be used to rotate text to a vertical or diagonal angle in a worksheet?

• Font  
• Orientation  
• Wrap Text  
• Merge & Center  

Column D in a spreadsheet contains employee ID Numbers. Which formatting would be most appropriate for the data in column D?  

• Currency  
• Date  
• Number  
• Text  

What type of formatting appears only when the value in a cell meets conditions specified by a user?

• Criterion  
• Conditional  
• Logical  
• Restrictive  

Which quick-number style button formats numbers to display as currency in the worksheet?  

• Percent  
• Accounting  
• Comma  
• Dollar  

Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet?

• Hyperlink  
• Web link  
• Linkup  
• Text link