Multiple Choice Question for Microsoft Excel || 1
Read multiple choice questions for computer operator training as well as IT Training. Improve your computer skills.
1 Which of the following methods can not 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
2 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
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
4 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
5 Text formulas:
A. Replace cell
references
B. Return ASCII values of characters
C. Concatenate and manipulate
text
D. Show formula error value
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
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
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
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
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. Press
Ctrl+P+3
10 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