MS Excel

1) Which option of chart Wizard contains the option of Series Name , category and value in Data ?

Answer Is: (C) Data label

Explanation:

No answer description available for this question. Let us discuss.

2) Which of the folliwing formulas is not entered correctly ?

Answer Is: (D) 10+50

Explanation:

No answer description available for this question. Let us discuss.

3) _____function in MS Excel returns current time .

Answer Is: (C) EOMONTH

Explanation:

No answer description available for this question. Let us discuss.

4) ____Function in MS Excel takes a date string and returns parsed date value .

Answer Is: (C) DATEVALUE

Explanation:

No answer description available for this question. Let us discuss.

5) each_le in MS excle is called a______

Answer Is: (A) workbook

Explanation:

No answer description available for this question. Let us discuss.

6) The intersection of a row and column in MS Excel is called …?

Answer Is: (D) cell

Explanation:

No answer description available for this question. Let us discuss.

7) Shortcut key for : edit the selected cell .

Answer Is: (B) F2

Explanation:

No answer description available for this question. Let us discuss.

8) _____function in MS Excel returns fractional year between given dates.

Answer Is: (D) YEARFRAC

Explanation:

No answer description available for this question. Let us discuss.

9) In a worksheet you can select

Answer Is: (B) Rows

Explanation:

No answer description available for this question. Let us discuss.

10) In MS Excle ,_____function returns function returns number equivalent of text value .

Answer Is: (A) N

Explanation:

No answer description available for this question. Let us discuss.

11) What is the Extension of Excle Workbook in MS Excle 2007 ?

Answer Is: (B) .xlsx

Explanation:

No answer description available for this question. Let us discuss.

12) Which symbol must all formula being with ?

Answer Is: (A) =

Explanation:

No answer description available for this question. Let us discuss.

13) Shortcut key for : select entire row .

Answer Is: (C) Shift + Space

Explanation:

No answer description available for this question. Let us discuss.

14) _____function in MS Excel returns second from a time value.

Answer Is: (B) SECOND

Explanation:

No answer description available for this question. Let us discuss.

15) _____function in MS Excel returns minutes from a time value.

Answer Is: (A) MINUTES

Explanation:

No answer description available for this question. Let us discuss.

16) To activate the previous cell in a pre-selected range,press

Answer Is: (D) none of them

Explanation:

No answer description available for this question. Let us discuss.

17) Which of the following formulas will Excel Not be able to calculate ?

Answer Is: (A) "=SUM(Sales)-A3"

Explanation:

No answer description available for this question. Let us discuss.

18) The latest version of MS Excel can have ….. Rows.

Answer Is: (A) 10,48,576

Explanation:

No answer description available for this question. Let us discuss.

19) Excel is a collection of workbook ……….

Answer Is: (B) Worksheets

Explanation:

No answer description available for this question. Let us discuss.

20) In MS Excle, _____function returns #NA error number.

Answer Is: (B) NA

Explanation:

No answer description available for this question. Let us discuss.

21) Which function will you use to enter current time in a worksheet cell ?

Answer Is: (B) "=now()"

Explanation:

No answer description available for this question. Let us discuss.

22) IN MS Excel , ____function returns true if the given cell contains an even numbers.

Answer Is: (C) ISEVEN

Explanation:

No answer description available for this question. Let us discuss.

23) In MS Excle , ______function retuns true if a cell is blank.

Answer Is: (A) ISBLANK

Explanation:

No answer description available for this question. Let us discuss.

24) Shortcut key for : insert link.

Answer Is: (B) Ctrl + K

Explanation:

No answer description available for this question. Let us discuss.

25) On an excel sheet the active cell in indicated by ?

Answer Is: (B) A dark wide border

Explanation:

No answer description available for this question. Let us discuss.

26) MS ExCEl Based on ____Software.

Answer Is: (A) WINDOWS

Explanation:

No answer description available for this question. Let us discuss.

27) A spreadsheet is a collection of pages is called a ____

Answer Is: (A) Workbook

Explanation:

No answer description available for this question. Let us discuss.

28) In MS Excle ,_____function returns true even if just one of the given conditions is true .

Answer Is: (A) OR

Explanation:

No answer description available for this question. Let us discuss.

29) The latest version of MS Excel can have ….. Columns.

Answer Is: (B) 16384

Explanation:

No answer description available for this question. Let us discuss.

30) In MS Excel, a function is entered by typing …. Symbol.

Answer Is: (D) =

Explanation:

No answer description available for this question. Let us discuss.

31) ____function in MS Excle takes year, month and date values and displaysgives date.

Answer Is: (A) DATE

Explanation:

No answer description available for this question. Let us discuss.

32) Rows in MS Excel are named in the form of …

Answer Is: (B) numbers(1,2,3,4,…)

Explanation:

No answer description available for this question. Let us discuss.

33) which of the following option is not available in paste special diolog box?

Answer Is: (D) SQRT

Explanation:

No answer description available for this question. Let us discuss.

34) Which menu have the fill option in MS Excel ?

Answer Is: (D) Edit

Explanation:

No answer description available for this question. Let us discuss.

35) _____function in MS Excel returns the date after given number of working days .

Answer Is: (B) WORKDAY

Explanation:

No answer description available for this question. Let us discuss.

36) In MS Excle , which menu does have sort option

Answer Is: (D) Data

Explanation:

No answer description available for this question. Let us discuss.

37) Shortcut key for : Enter the current date .

Answer Is: (B) Ctri+ ;

Explanation:

No answer description available for this question. Let us discuss.

38) Which of these data type is not in MS. Excle ?

Answer Is: (C) Label

Explanation:

No answer description available for this question. Let us discuss.

39) To drag selected range of data to another worksheet in the same workbook , use the

Answer Is: (D) Ctrl key

Explanation:

No answer description available for this question. Let us discuss.

40) Excel file without any macros has the default extentoin of …..

Answer Is: (A) .xlsx

Explanation:

No answer description available for this question. Let us discuss.

41) when a rangeis selected,how can you activate the previous cell?

Answer Is: (D) none of these

Explanation:

No answer description available for this question. Let us discuss.

42) _____function in MS Excel returns day of week for given date .

Answer Is: (A) WEEKDAY

Explanation:

No answer description available for this question. Let us discuss.

43) Which of these charts does not exits in MS Excle

Answer Is: (D) Graph

Explanation:

No answer description available for this question. Let us discuss.

44) Collumns in MS Exel are named in the form of ….

Answer Is: (C) alphabets(A,B,C,D,…)

Explanation:

No answer description available for this question. Let us discuss.

45) Which of these options is not available in the Chart Options in MS Excel "CHART WIZARD" ?

Answer Is: (C) Data Series

Explanation:

No answer description available for this question. Let us discuss.

46) How are data organized in a spreadsheet ?

Answer Is: (C) rows and columns

Explanation:

No answer description available for this question. Let us discuss.

47) Shortcut key for : Enter the current time

Answer Is: (B) Ctrl+ Shift + ;

Explanation:

No answer description available for this question. Let us discuss.

48) In MS Excel, ____fuction returns positive value irrespective of whether the input is posittive or negative.

Answer Is: (A) ABS

Explanation:

No answer description available for this question. Let us discuss.

49) In MS Excle,in which bar have the currency option ?

Answer Is: (A) Formatting Toolbar

Explanation:

No answer description available for this question. Let us discuss.

50) You can set border in excel form

Answer Is: (D) you can set page border in excel

Explanation:

No answer description available for this question. Let us discuss.

Comments (0)

Leave your comment

Please enter comment.

Please enter name.
Please enter valid email address.
Please enter valid website URL.

Up