Microsoft Excel Whiz 2002 2003

I. Identification: Identify the following. Write your answer on the space provided before each number.

• __________________1. It is a combination of formatting characters, such as font, font size, and indentation, that you name and store as a set.

• __________________2. This means adding patterns to cell to mark important information.

• __________________3. It copies the format from a selected object or text and applies it to the object or text you click.

• __________________4. It gives you quick access to frequently used commands.

• __________________5. This option adds a dollar sign, commas, and two decimal places.

• __________________6. This button allows you to keep the source Column widths.

• __________________7. This option multiplies the number by 100 and adds a percent sign.

• __________________8. The action to be made if you want to copy the formatting to more than one item using the format painter.

• __________________9. This option adds a comma for every three digits to the left of the decimal place and two decimal places.

• __________________10. The standard width of a column.

II. Write down the shortcut keys of the following commands/options.

III. Fill in the Blanks. Fill in the missing word/s to complete the following steps:

1. Changing Indentations using Format dialog box.

   1. Select the ____________ that contain the text you want to indent.

   2. Press _________ or click Format and choose cells. The Format dialog box appears.

   3. Click on the __________________ tab.

   4. Change the _____________________ to Left (indent) or Right (indent)

   5. Type the number of characters to indent or use the up and down arrows in the Indent Drop-down list box.

   6. Click ______.

2. Adding Shading.

   1. Select the cell or ____________ of cells.

   2. From the Format menu, choose __________________.

   3. Choose the __________________ from the dialog box.

   4. Choose a _________ from the color list.

   5. Click OK or press _________.