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
- (C) Pressing the Esc key
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
- (A) Pressing Ctrl + C
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
- (D) Pressing spacebar
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
- (D) All of the above
Text formulas:
- (A) Replace cell references
- (B) Return ASCII values of characters
- (C) Concatenate and manipulate text
- (D) Show formula error value
- (C) Concatenate and manipulate text
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
- (A) Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
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
- (D) Copy the worksheet
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
- (D) Hold down the Ctrl key as you click anywhere in the column
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
- (B) Select File >Print from the menu and type 3 in the Number of copies text box.
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
- (B) Type the equals sign (=) to tell Excel that you’re about to enter a formula