MicroSoft Excel Question & Answer

D.N COMPUTER CENTRE (GHATAKPUKUR, 24 PGS (SOUTH))

MicroSoft Excel Question & Answer

1. Microsoft Excel Application Developed by ...........

A) Mac book
B) Adobe
C) Microsoft
D) None of these

... Answer is C)
Microsoft Excel Application Developed by Microsoft

2. A Excel document of file known as ........?

A) Workbook
B) Worksheet
C) Mac book
D) None of these

... Answer is A)
A Excel document of file known as Workbook.

3. A Sheet is Combination with Columns and .....

A) Sheet
B) Cell
C) Rows
D) None of these

... Answer is C)
A Sheet is Combination with Columns and Rows.

4. Row and Column selected cell is called .........

A) Active Cell
B) Non Active Cell
C) Selected Cell
D) None of these

... Answer is A)
Row and Column selected cell is called Active Cell.

5. Excel 2007 Number of rows ..........

A) 16384
B) 10000
C) 64
D) 1048576

... Answer is D)
Excel 2007 Number of rows 1048576.

6.Excel 2007 number of columns .......

A) 1048576
B) 16384
C) 65536
D) None of these

... Answer is C)
Excel 2007 number of columns 65536.

7. .........is a Electronic Spreadsheet

A) MS-Access
B) MS-Word
C) MS-Power point
D) MS-Excel

... Answer is D)
MS-Excel is a Electronic Spreadsheet.

8. MS-Excel Column assign ........

A) use on Alphabet
B) use on Number
C) use on Formula
D) None of these

... Answer is A)
MS-Excel Column assign use on Alphabet.

9. Excel 2007 Worksheet total cell is ........

A) 65535 x 256
B) 1048576 x 16384
C) 104657 x 16348
D) None of these

... Answer is B)
Excel 2007 Worksheet total cell is 1048576 x 16384.

10. MS-Excel 2007 Workbook by default worksheet .........

A) One
B) Two
C) Three
D) Four

... Answer is C)
MS-Excel 2007 Workbook by default worksheet Three.

11. A1 to C10 Cell range, Total Cells ...........

A) 10
B) 20
C) 30
D) 40

... Answer is C)
A1 to C10 Cell range, Total Cells 30.

12. What is the symbol start formula ?

A) *
B) +
C) #
D) =

... Answer is D)
= is the symbol start formula.

13. MS-Excel 2007 by default row height ........

A) 15
B) 15.7
C) 12.75
D) None of these

... Answer is A)
MS-Excel 2007 by default row height 15.

14. MS-Excel 2007 by default column weight ........

A) 8.34
B) 8.43
C) 4.83
D) None of these

... Answer is B)
MS-Excel 2007 by default row height 8.43.

15. Excel 2007 by default Ribbon .......

A) 7
B) 5
C) 8
D) None of these

... Answer is A)
Excel 2007 by default Ribbon 7.

16. Merge Cells button use on ...... group.

A) font
B) number
C) alignment
D) None of these

... Answer is C)
Merge Cells button use on alignment group.

17. AND is a ............ Function.

A) Logical
B) Statistical
C) Mathematical
D) Financial

... Answer is A)
AND is a Logical Function.

18. IF is a ............ Function.

A) Statistical
B) Financial
C) Mathematical
D) Logical

... Answer is B)
IF is a Logical Function.

19. MS-Excel 2007 first cell address is .......

A) B1
B) A1
C) C1
D) None of these

... Answer is B)
MS-Excel 2007 first cell address is A1.

20. MS-Excel 2007 end cell address is ...........

A) XFD1048575
B) XFD1048576
C) A1048576
D)A1048575

... Answer is B)
MS-Excel 2007 end cell address is XFD1048576.

21. MS-Excel 2007 .......ribbon use on chart.

A) Home
B) Data
C) PageLayout
D) None of these

... Answer is D)
MS-Excel 2007 Insert ribbon use on chart..

22. .......is a not Logical Function.

A) AND
B) OR
C) NOT
D) NOW

... Answer is D)
NOW is a not Logical Function.

23. Conditional Formatting use on .........Tab.

A) Home
B) Insert
C) Page Layout
D) Review

... Answer is A)
Conditional Formatting use on Home Tab.

24. MS-Excel two cell multiply use on ...... Function.

A) SUM
B) MAX
C) PRODUCT
D) AVERAGE

... Answer is C)
MS-Excel two cell multiply use on PRODUCT Function.

25. MS-Excel 2007 ...... View is default view.

A) Page Layout
B) Page Break Pre
C) Normal
D) None of these

... Answer is C)
MS-Excel 2007 Normal View is default view.

26. MS-Excel 2007 worksheet go to end column press on .........Shortcut key.

A) Ctrl + End
B) End + Right Arrow
C) A and B Both
D) None of these

... Answer is B)
MS-Excel 2007 worksheet go to end column press on End + Right Arrow Shortcut key.

27. MS-Excel 2007 file extension is ........

A) .mdb
B) .doc
C) .docx
D) .xlsx

... Answer is D)
MS-Excel 2007 file extension is .xlsx.

28. MS-Excel 2007 Series Option use on ...... Tab.

A) Home
B) Insert
C) PageLayout
D) None of these

... Answer is A)
MS-Excel 2007 Series Option use on Home Tab..

29. MS-Excel 2007 Active Cell Address show ......

A) Status Bar
B) Task Pane
C) Formula Box
D) Name Box

... Answer is D)
MS-Excel 2007 Active Cell Address show Name Box.

30. =NOW() Function use to know ........

A) Today Date
B) Today Time
C) A and B Both
D) None of these

... Answer is C)
=NOW() Function use to know Today Date and Time.

31. Excel Worksheet end of the row press on ..........

A) Ctrl + Down Arrow
B) End + Down Arrow
C) A and B Both
D) None of these

... Answer is C)
Excel Worksheet end of the row press on Ctrl + Down Arrow / End + Down Arrow.

32. Excel 2007 end of the column is .........

A) AFD
B) DFD
C) XED
D) None of these

... Answer is D)
Excel 2007 end of the column is XFD.

33. COUNT is a .........Function.

A) Logical
B) Statistical
C) Math
D) None of these

... Answer is B)
COUNT is a Statistical Function.

34. Excel Mixed cell reference use ........sign.

A) @
B) &
C) $
D) None of these

... Answer is C)
Excel Mixed cell reference use $ sign.

35. 81 SQRT apply, Answer is .......

A) 9
B) 15
C) 81
D) None of these

... Answer is A)
81 SQRT apply, Answer is 9 .

36. "DN Computer Centre" apply UPPER(), Answer is .............

A) dn computer centre
B) DN Computer Centre
C) DN COMPUTER CENTRE
D) None of these

... Answer is C)
"DN Computer Centre" apply UPPER(), Answer is DN COMPUTER CENTRE.

37.What is the Formula Lowest Common Multiple apply ?

A) =SUM
B) =SQRT
C) =LCM
D) None of these

... Answer is C)
=LCM is the Formula Lowest Common Multiple apply.

38. Excel "Cylinder" is a ...........

A) Image
B) WordArt
C) Chart
D) None of these

... Answer is C)
Excel "Cylinder" is a Chart.

39. Excel 2007 "Macro" use ........ Tab.

A) Home
B) View
C) PageLayout
D) None of these

... Answer is B)
Excel 2007 "Macro" use View Tab.

40. ....... is a invalid Formula.

A) =sum(a10:c10)
B) sum(a10:c10)
C) =average(a10:c10)
D) None of these

... Answer is B)
sum(a10:c10) is a invalid Formula.

41. "Highlight Cell Rules" option use on .........

A) Format as Table
B) Conditional Formatting
C) Cell Border
D) None of these

... Answer is B)
"Highlight Cell Rules" option use on Conditional Formatting.

42. Excel Calender use on .......... Option.

A) Series
B) Table
C) Format
D) None of these

... Answer is A)
Excel Calender use on Series Option..

43. Excel "Data Validation" use on ........... Tab.

A) Home
B) Insert
C) Data
D) None of these

... Answer is A)
Excel "Data Validation" use on Data Tab.

44. Excel 2007 Data Validation Data alert ...... types.

A) One
B) Two
C) Three
D) None of these

... Answer is C)
Excel 2007 Data Validation Data alert Three (stop,information,warning) types.

45. Excel 2007 "Vertical Text" use on ........ Option.

A) Orientation
B) Alignment
C) Merge & Centre
D) None of these

... Answer is A)
Excel 2007 "Vertical Text" use on Orientation Option.

46. Excel "B10" is a .......

A) Cell Slider
B) Cell Address
C) Cell Format
D) None of these

... Answer is A)
Excel "B10" is a Cell Address.

47.Excel 2007 "Filter" Option use on ....... Tab.

A) Data
B) Insert
C) Home
D) None of these

... Answer is A)
Excel 2007 "Filter" Option use on Data Tab.

48. "Reminder" use on ......... Formula.

A) =MOD()
B) =SQRT()
C) =SUM()
D) None of these

... Answer is A)
"Reminder" use on =MOD() Formula.

49. "Maximum" value use on ........ Formula.

A) =MAX()
B) =WORKDAY()
C) =MIN()
D) None of these

... Answer is A)
"Maximum" value use on =MAX() Formula.

50. Excel Logical Function is ......

A) =IF()
B) =UPPER()
C) =YEAR()
D) None of these

... Answer is A)
Excel Logical Function is =IF().