MS excel set 11 Detailed Explanation And More Example

Question : 1

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

a) The word document can not 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

e) None of these

Question : 2

The spelling tool Is placed on _toolbar

a) Standard

b) Formatting

c) Drawing

d) Reviewing

e) None of these

Question : 3

To center worksheet titles across a range of cell, you must

a) Select the cells containing the title text and use the fill handle to center the text across a range of cells

b) Widen the columns

c) Select the cells containing the title text and use the fill handle to center the text across a range of cells

d) Widen the column

e) None of these

Question : 4

In Excel 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

Question : 5

In Excel one can copy data or formulas

a) With the copy, paste and cut commands on the edit menu

b) With commands on ta shortcut menu

c) With buttons on the standard toolbars

d) All of the above

Question : 6

In Excel a fast way to add up this column of number is to click in the cell below the numbers and then

a) Click subtotals on the data menu

b) View the sum in the formula bar

c) Click the autosum button on the standard toolbar, then press enter

d) All of above