MICROSOFT EXCEL

In Microsoft Excel, which of the following methods cannot be used to enter data in a cell:

• (A) Pressing an arrow key
• (B) Pressing the Tab key
• (C) Pressing the Esc key
• (D) Clicking on the formula bar

Check Answer

---

Which of the following will not cut information?

• (A) Pressing Ctrl + C
• (B) Selecting Edit>Cut from the menu
• (C) Clicking the Cut button on the standard
• (D) Pressing Ctrl + X

Check Answer

---

Which of the following is not a way to complete a cell entry?

• (A) Pressing enter
• (B) Pressing any arrow key on the keyboard
• (C) Clicking the Enter button on the Formula bar
• (D) Pressing spacebar

Check Answer

---

You can activate a cell by:

• (A) Pressing the Tab key
• (B) Clicking the cell
• (C) Pressing an arrow key
• (D) All of the above

Check Answer

---

Text formulas:

• (A) Replace cell references
• (B) Return ASCII values of characters
• (C) Concatenate and manipulate text
• (D) Show formula error value

Check Answer

---

How do you insert a row?

• (A) Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
• (B) Select the row heading where you want to insert the new row and select Edit >Row from the menu
• (C) Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
• (D) All of the above

Check Answer

---

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

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

Check Answer

---

How do you select an entire column?

• (A) Select Edit > Select > Column from the menu
• (B) Click the column heading letter
• (C) Hold down the shift key as you click anywhere in the column.
• (D) Hold down the Ctrl key as you click anywhere in the column

Check Answer

---

How can you print three copies of a workbook?

• (A) Select File>Properties form the menu and type 3 in the Copies to print text box.
• (B) Select File >Print from the menu and type 3 in the Number of copies text box.
• (C) Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made
• (D) Press Ctrl+P+3

Check Answer

---

To create a formula, you first:

• (A) Select the cell you want to place the formula into
• (B) Type the equals sign (=) to tell Excel that you’re about to enter a formula
• (C) Enter the formula using any input values and the appropriate mathematical operators that make up your formula
• (D) Choose the new command from the file menu

Check Answer

---