MS excel set 4 Detailed Explanation And More Example

Question : 1

The Trace Precedence on Auditing shows

a) Which cells are used in current formula

b) In which formula the current cell is used

c) Which cells are used in this formula and in which formula this cell is used

d) All of above

e) None of these

Question : 2

Right clicking something in Excel:

a) Deletes the object

b) Nothing the right mouse button is there for left handed people

c) Opens a shortcut menu listing everything you can do to the object

d) Selects object

e) None of these

Question : 3

In a worksheet you can select

a) Etire worksheet

b) Rows

c) Columns

d) All of the above

Question : 4

In Excel you can use the formula palette to

a) Format cells containing numbers

b) Create and edit formulas containing functions

c) Entered assumptions data

d) Copy a range of cells

Question : 5

Each cell in a Microsoft Office Excel document is referred to by its cell address, which is the

a) cell's column label

b) cell's column label and worksheet tab name

c) cell's row label

d) cell's row and column labels

e) None of these

Question : 6

Which of the following formulas is not entered correctly?

a) =10+50

b) =B7*B1

c) =B7+14

d) 10+50

e) None of these