MICROSOFT EXCEL

Hyperlinks can be:

• (A) Text
• (B) Drawing objects
• (C) Pictures
• (D) All of above

Check Answer

---

To activate the previous cell in a pre-selected range, press:

• (A) The Alt key
• (B) The Tab key
• (C) The Enter key
• (D) None of the above

Check Answer

---

Which button do you click to add up a series of numbers?

• (A) The auto sum button
• (B) The Formula button
• (C) The quick total button
• (D) The total button

Check Answer

---

When the formula bar is active, you can see:

• (A) The edit formula button
• (B) The cancel button
• (C) The enter button
• (D) All of the above

Check Answer

---

To copy formatting from one area in a worksheet and apply it to another area you would use:

• (A) The Edit Copy Format and Edit>Paste Format commands form the menu.
• (B) The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.
• (C) There is no way to copy and apply formatting in Excel – You have to do it manually
• (D) The Format Painter button on the standard toolbar

Check Answer

---

In a worksheet you can select:

• (A) The entire worksheet
• (B) Rows
• (C) Columns
• (D) All of these

Check Answer

---

When you link data maintained in an excel workbook to a word document?

• (A) The word document cannot be edit
• (B) The word document contains a reference to the original source application
• (C) The word document must contain a hyperlink
• (D) The word document contains a copy of the actual data

Check Answer

---

Which area in an excel window allows entering values and formulas?

• (A) Title bar
• (B) Menu bar
• (C) Formula bar
• (D) Standard toolbar

Check Answer

---

To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the:

• (A) Unfreeze panes command on the window menu
• (B) Freeze panes command on the window menu
• (C) Hold titles command on the edit menu
• (D) Split command on the window menu

Check Answer

---

To edit in an embedded excel worksheet object in a word document:

• (A) Use the excel menu bar and toolbars inside the word application
• (B) Edit the hyperlink
• (C) Edit the data in a excel source application
• (D) Use the word menu bar and toolbars

Check Answer

---