## Excel Exam Set ( Poush 2)

Welcome to your Ms Excel Exam Set 1

Name
1.
The len function does what ?

2.
Excel has ………….. Functions

3.
A graphical form of worksheet of data is called ….

4.
Function of filter in excel is on

5.

6.
Which is not the chart type ?

7.
Goal seek is ….

8.
Auto fit is …

9.
The auto fill features is

10.
The auto sum button exist on ….. Toolbar

11.
the range of cells from which you want to count cells that meets the criteria is ……

12.
Which one is the conditional operator ?

13.
.to join text from two cells , which operator is used ?

14.
Which function is used to find the reminder

15.
Which is a valid cell address ?

16.

17.
The function of countA() is ….

18.
which command makes the text “Nepal” capital

19.
Which is not a valid cell reference in excel ?

20.
If a1=5 b2=6 c2=10.5 then what will be the output of =int(sum(a1,b2,c2))

21.
Graphic object is used in chart for ?

22.
=sum(a1:a3) is equivalent with …

23.
Fill series command is used for …

24.
What is the value of mod((d3/10)+ int (d3/10),d3) , where d3=67

25.
The format apply based on user criteria is called

26.
Pivot chart shows….

27.
The scenario is used for ….

28.
What will happen if you drag downward for cell containing date?

29.
To activate cell

30.
In ms excel b7:b9 indicates

31.
in excel what happens when dollar sign \$ are entered in a cell address

32.
The intersection of row and column is called ..

33.
How many characters can be typed in a single cell in excel ?

34.
Getting data from a cell located in a different sheet is called ….

35.
Data can be arranged in a worksheet in an easy to understand manner using

36.
Which area in an excel window allows entering values and formulas

37.
Multiple calculations can be made in a single formula using .

38.
In excel , when the result is too long to feet in a cell what will displayed ?

39.
To organize data in a list alphabetically , numerically or chronologically is known as …

40.
Which is the shortcut key for row hide ?

41.
How many sheets are there in excel workbook?

42.
What is the name of excel file ?

43.
Which character fixes row and column

44.
When insert a column in excel previous column moves on

45.
The information of the cell gives on

46.
Command is associated with ,

47.
The box which appears right side of chart is called

48.
Which shortcut key is used to insert chart ?

49.
The cell labeled F5 refers to :

## Comment List

• Bidur says:

sir maile napadikina diyako ho ahile samaya alli tite xa mero so, yo pahilo exam ho mero !! malai Tapaiko class ra yo exam ani note asadhai pan pareyo !!

very helpful question thank you sir

• Ramesh Mahara says:

Thank for teaching me great thanks

• khemjung430 says:

Helloloksewa is the institute where you will get MCQs ideas very clearly and subjective in a practical way. I’m a computer operator student and am damn sure that it would help me to apply this idea, skill, and knowledge where I go. Glad to be part of helloloksewa.

• Santosh.mahato says:

ok

• Santosh.mahato says:

helping for remember question thanks