MICROSOFT EXCEL

Which of the following is not a basic step in creating a worksheet?

• (A) Save the workbook
• (B) Modify the worksheet
• (C) Enter text and data
• (D) Copy the worksheet

What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20?

• (A) Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows
• (B) Select the range you want, include both cells, point to fill on the Edit menu, and then click down.
• (C) Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special
• (D) All of above

To insert three columns between columns D and E you would:

• (A) Select column D
• (B) Select column E
• (C) Select columns E, F and G
• (D) Select columns D, E, and F

To center worksheet titles across a range of cell, you must:

• (A) Select the cells containing the title text and use the fill handle to center the text across a range of cells
• (B) Widen the columns
• (C) Select the cells containing the title text and use the fill handle to center the text across a range of cells
• (D) Widen the column

When integrating Ms-Word and Excel, Word is usually the:

• (A) Server
• (B) Source
• (C) Client
• (D) None

Charts tips can:

• (A) Show the formatting of a data label
• (B) Show the name of a data series
• (C) Show the value of data point
• (D) Both B and C

The Name box:

• (A) Shows the location of the previously active cell
• (B) Appears the left of the formula bar
• (C) Appears below the status bar
• (D) Appears below the menu bar

How do you change column width to fit the contents?

• (A) Single-click the boundary to the left to the column heading
• (B) Double click the boundary to the right of the column heading
• (C) Press Alt and single click anywhere in the column
• (D) All of above

When you work with large worksheets, you may need to:

• (A) size the worksheet to fit on the specific number of pages
• (B) add and remove page breaks
• (C) specify only certain print areas
• (D) all of above

Hyperlinks cannot be:

• (A) Special shapes like stars and banners
• (B) Drawing objects like rectangles ovals
• (C) Pictures
• (D) All can be hyperlinks