Microsoft Excel Whiz 2002 2003

  1. TRUE OR FALSE. Write T if the statement is true and F if it is false.

    • ___1. Inserting rows and columns is necessary if you have to enter a series of text in a table and there are enough rows and columns for it.

    • ___2. Hiding rows and columns helps you organize small worksheet.

    • ___3. Freezing panes will either unlock the top and/or upper-left panes depending on where you have placed your pointer.

    • ___4. A split worksheet enables you to view different sections of the worksheet side-by-side in separate panes.

    • ___5. Each section of a worksheet is referred to as a pane.

    • ___6. Tabs helps you organize your work by adding color to your worksheet tabs.

    • ___7. Smart Tags allows you to immediately adjust how information is pasted or how automatic changes occur in your Office programs.

    • ___8. The Zoom feature of Excel allows you to magnify or shrink the view of the worksheet.

    • ___9. 2-D reference is a reference to a range that spans two or more worksheet in a workbook.

    • ___10. Spell Check corrects spelling errors in your work.

  2. Find the Difference: Encircle the letter with the correct answer.

    1. To select the worksheet you want to move, do any of the following except:

      1. Click on the tab key, then drag the worksheet where you want it located.

      2. Right-click on the sheet tab, then click Move. The Move and Copy dialog box appears.

      3. Click on Edit menu then choose Move or Copy Sheet.

    2. To select the sheet you want to delete, do any of the following except:

      1. Right-click, then choose Delete.

      2. On the Edit menu, click Delete Sheet.

      3. Press the Delete key.

    3. To rename a worksheet, do one of the following except:

      1. Right-click the Sheet tab and then choose Rename.

      2. Double-click the Status bar.

      3. Click the Sheet tab you want to rename. In the Format menu, click Sheet, then choose Rename.

    4. To switch between worksheets in a workbook, do any of the following except:

      1. Click the Sheet tab you want to open.

      2. Press Ctrl+Page Down to move to the next worksheet or Ctrl+Page UP to go to previous.

      3. Right-click on the status bar, then click the workbook you want to open.

    5. To remove a split window, do any of the following except:

      1. Click Window from the menu bar, then choose Remove Split.

      2. Press Alt+W and then press S.

      3. Press Tab and then Ctrl+R.

Related

Категории