MS excel set 7 Detailed Explanation And More Example

Question : 1

What does COUNTA ( ) function do?

a) counts cells having alphabets

b) counts empty eel is

c) counts cells having number

d) counts non-empty cells

e) None of these

Question : 2

Which of the following options is not available to remove arrows of Formula Auditing?

a) Remove all precedent arrows

b) Remove all dependent arrows

c) Remove all arrows

d) Remove all arrows for this cell

e) None of these

Question : 3

Which button do you click to add up a series of numbers?

a) The autosum button

b) The Formula button

c) The quicktotal button

d) The total button

e) None of these

Question : 4

In Excel when you are typing an equation into a cell the first thing that must be entered is

a) the first cell referenced

b) parenthesis

c) quotation marks

d) an equal sign

Question : 5

lt is acceptable of let long text flow into adjacent cells on a worksheet when

a) Data will be entered in the adjacent cells

b) No data will be entered in the adjacent cells

c) There is not suitable abbreviation of the text

d) There is not time to format the next

e) None of these

Question : 6

Which is not the function of "Edit, Clear" command?

a) Delete contents

b) Delete notes

c) Delete eel is

d) Delete formats

e) None of these