1. 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
see answer
c. Pressing the, Esc key
2. Which of the, following will not cut, information?
a. Ctrl +C
b. Selecting Edit>Cut, from the menu
C. Clicking the, Cut button on the, standard
d. Ctrl+X
see answer
a. Ctrl +C
3. 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
see answer
d. Pressing spacebar
4. You can, activate a cell, by:
a. Pressing the, Tab key
b. Clicking the, cell
C. Pressing an arrow, key
d. All
see answer
d. All
5. “Text formulas”:
a. Replace cell, references
b. Return ASCIl values, of characters
c. Concatenate, and manipulate text
d. Show formula error, value
see answer
c. Concatenate, and manipulate text
6. 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, to insert the new, row and click the, Insert:
b. Row button, on the standard, toolbar
C. Select, the row heading where, you want
d. All
see answer
a. Right-click the row, heading where you want, to insert the new row, and select Insert from, the shortcut menu, to insert the new, row and click the, Insert:
7. Which of, the following is not a basic, step in creating a, worksheet?
a. Save workbook,
b. Modifiy the, worksheet
C. Enter text and, data
d. Copy the, worksheet
see answer
d. Copy the, worksheet
8. 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
see answer
b. Click the, column heading, letter
9. 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. Ctrl+P+3
see answer
b. Select File >Print, from the menu and type, 3 in the Number of ,copies text box.
10. To create a formula, you first the formula, into:
a. Select the, cell you want to, place
b. Type the equals, sign (=) to tell EX 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
see answer
a. Select the, cell you want to, place
This is extreemly great work.