Raman Academy Logo
+917649911100

MS-EXCEL MCQ Questions and Answers

by

Results

Share your score!
Tweet your score!
Share to other

#1. MS-Excel is used for

#2. What kind of software would you most likely use to keep track of a billing account?

#3. Excel worksheet data can be shared with Word document by

#4. A worksheet is made of columns and rows, wherein

#5. Which of the following software applications would be the most appropriate for performing numerical and statistical calculations?

#6. The file responsible for starting MS-Excel is

#7. Anything that is typed in a worksheet appears

#8. Which one is the example of spreadsheet package?

#9. Which option will we use to give heading in the form ?

#10. The extension of saved file in MS-Excel is

#11. Alignment buttons are available on which toolbar?

#12. In Excel, the intersection of a column and a row is called

#13. What does an electronic spreadsheet consist of?

#14. A collection of worksheets is called

#15. All of the following terms are related to spreadsheet software except

#16. Which of the following is an active cell in Excel?

#17. How are the data organised in a spreadsheet?

#18. The basic unit of a worksheet into which you enter data in Excel is called a

#19. The advantage of using a spreadsheet is

#20. A ......... is rectangular grid of rows and columns used to enter data.

#21. The default view in Excel is …… view.

#22. It is a software tool that lets one enter, calculate, manipulate set of numbers.

#23. Borders can be applied to

#24. The cell having bold boundary is called

#25. You can create hyperlinks from the Excel workbook to

#26. To select a column the easiest method is to

#27. Which among the following is not such an operation which can be carried out on objects in graphic program?

#28. Which of the following will you use as an option for saving a file?

#29. What function displays row data in a column or column data in a row?

#30. In Excel, ......... allows users to bring together copies of workbooks that other users gave worked on independently.

#31. Insert date, format page number and insert auto text are buttons on the ......... toolbar.

#32. On saving a worksheet, the ‘Save As’ dialog box

#33. The letter and number of the intersecting column and row is the

#34. Magnifier button is available on

#35. Which of the following is not a valid formula in Microsoft Excel?

#36. Which command is used to calculate total characters in a cell?

#37. The function TODAY ( ) in Excel, enters the current

#38. Which of the following characteristics is used to compute dynamically the results from Excel data?

#39. Which area in an Excel window allows entering values and formulas?

#40. = Sum (B1 : B10) is an example of a

#41. You can copy data or formulas

#42. A cell entry can be edited in the cell or in the

#43. In Excel, this is a prerecorded formula that provides a shortcut for complex calculations.

#44. In Excel, an active cell can be represented by

#45. Three types of data can be entered in a worksheet, as number/characters, text and

#46. The physical arrangement of elements on a page is referred to as a document’s

#47. Cell address $A4 in a formula means it is a

#48. In this chart, only one data series can be plotted

#49. This chart shows the relationship of parts to a whole.

#50. A chart placed in a worksheet is called

#51. Scatter chart is also known as

#52. In Excel, charts are created using which option?

#53. Pie charts are typically created by using which of the following?

#54. Pressing Ctrl + F9 in Excel

#55. To select the current column, press

#56. The cell accepts your typing as its contents, if you press

#57. Which key is used in combination with another key to perform a specific task?

#58. Which of the following commands in Office 2007, can be used to go to the first cell in the current row?

#59. In a worksheet in MS-Excel, what is shortcut key to hide entire row?

#60. To select entire row, which shortcut is used?

Finish

Google search