Results
#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?