MS excel set 7 Detailed Explanation And More Example

Question : 1

The numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?

a) Click the Currency Style button on the formatting toolbar

b) You have to retype everything and manually add the dollar signs, commas, and decimals.

c) Select Format > Money from the menu

d) All the above

e) None of these

Question : 2

In Excel Book1 is an example of how … are numbered and named during each work session

a) Active cell

b) Formula bar

c) Menu bar

d) Name box

Question : 3

What is the short cut key to replace a data with another in sheet?

a) Ctrl + R

b) Ctrl + Shift + R

c) Ctrl + H

d) Ctrl + F

e) None of these

Question : 4

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 : 5

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 : 6

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