Chapter Review


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.

1. Format dialog box

__________________

2. Bold

__________________

3. Italic

__________________

4. Underline

__________________

5. Strikeout

__________________

6. Currency

__________________

7. Percent

__________________

8. Comma

__________________

9. Left Align

__________________

10. Right Align

__________________

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 _________.




Microsoft Excel Whiz 2002 2003
Microsoft Excel Whiz 2002 2003
ISBN: N/A
EAN: N/A
Year: 2004
Pages: 66

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net