MICROSOFT EXCEL

To center worksheet titles across a range of cells, you must select the cells containing the title text plus the range:

• (A) Over which the title text is to be centered
• (B) Widen the columns
• (C) Select the cells containing the title text plus the range over which the title text is to be enfettered
• (D) Format the cells with the comma style

Check Answer

---

How do you delete a column?

• (A) Select the column heading you want to delete and select the Delete Row button on the standard toolbar
• (B) Select the column heading you want to delete and select Insert Delete from the menu
• (C) Select the row heading you want to delete and select Edit>Delete from the menu
• (D) Right click the column heading you want to delet and select delete from the shortcut menu

Check Answer

---

How can you find specific information in a list?

• (A) Select Tools > Finder from the menu
• (B) Click the Find button on the standard toolbar
• (C) Select Insert > Find from the menu
• (D) Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

Check Answer

---

When integrating word and excel, word is usually the?

• (A) Server
• (B) Destination
• (C) Client
• (D) Both B and C

Check Answer

---

When a label is too long to fit within a worksheet cell, you typically must:

• (A) Shorten the label
• (B) Increase the column width
• (C) Decrease the column width
• (D) Adjust the row height

Check Answer

---

The name box:

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

Check Answer

---

Comments put in cells are called ________.

• (A) Smart tip
• (B) Cell tip
• (C) Web tip
• (D) Soft tip

Check Answer

---

Which is used to perform what if analysis?

• (A) Solver
• (B) Goal seek
• (C) Scenario Manager
• (D) All of above

Check Answer

---

You can use the horizontal and vertical scroll bars to:

• (A) Split a worksheet into two panes
• (B) View different rows and columns edit the contents of a cell
• (C) Edit the contents of a cell
• (D) view different worksheets

Check Answer

---

Multiple calculations can be made in a single formula using:

• (A) Standard formulas
• (B) Array formula
• (C) Complex formulas
• (D) Smart formula

Check Answer

---