Play with MS Excel - 1

To change the font, font size, color, or style: Select the ________ you want to modify.

• Column Headings
• Cells

A quick way to include professional formatting for different parts of your workbook, such as titles and headers.

• Font Color
• Cell Style
• Borders
• Fill Color

_______ allows you to set a column's width to fit its content automatically.

• Auto Fill
• Resize
• Fill Handle
• Auto Fit

What does every formula in MS EXCEL start with?

• +

• -

• =

• *

What is a rectangular box in a MS EXCEL Spreadsheet called?

• row

• column

• cell

What is an example of a RANGE in MS Excel.

• B2-F5

• F5:B2

• B2:5F

• (B2:F5)

Kenyon would like to convert the cell range A1:F20 to a Medium 18 style. Which formatting style should he select?

• Cell Style

• Conditional Formatting

• Fill Color

• Format as Table

Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?

• Find & Select

• Format Cell

• Sort & Filter

• Organize

Joan has created a spreadsheet that displays sales of her employees. She would like to view only those employees with sales above $25,000 who are from Region 3. What option will allow her to do that?

• Ascending

• Descending

• Filter

• Custom Filter

Joan wants to see her sales representatives in numerical order with the sales person who sold the least at the top. Which sorting option should she choose?

• Ascending

• Customer Filter

• Descending

• Primary Sort