MS EXCEL MCQ Multiple Choice Questions Answers - Page 2 for Practice
31. NOT, AND, OR and XOR are
Correct Answer is: Logical Operators
32. The process of arrenging the items of a column in some sequence or order is known as
Correct Answer is: Sorting
33. In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in ……………
Correct Answer is: descending order
34. The ………………………… feature of MS Excel quickly completes a series of data
Correct Answer is: Auto Fill
35. In Excel, you can sum a large range of data by simply selecting a tool button called
Correct Answer is: Auto sum
36. In Excel, which one denoted a range from B1 through E5
Correct Answer is: B1:E5
37. What is represented by the small, black square in the lower-right corner of an active cell or range ?
Correct Answer is: Fill handle
38. How do you tell one cell from another ?
Correct Answer is: By its address
39. How to remove the unwanted action from recorded macro without recording the whole macro again?
Correct Answer is: By edit the macro in the Visual Basic Editor
40. In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a
Correct Answer is: chart showing rainfall amounts
41. The box on the chart that contains the name of each individual record is called the
Correct Answer is: legend
42. The basic unit of a worksheet into which you enter data in Excel is called a
Correct Answer is: cell
43. Comments put in cells are called .....
Correct Answer is: Cell Tip
44. Which of the following is not a term of MS-Excel?
Correct Answer is: Document
45. B7:B9 indicates:
Correct Answer is: Cells B7 through B9
46. What is the quickest way to select entire worksheet?
Correct Answer is: Click on the rectangle box on the upper left corner where column headings and row headings meet
47. If you want all of the white cats grouped together in the database, you need to sort by
Correct Answer is: Pet Type, then Color
48. What is the intersection of a column and a row on a worksheet called ?
Correct Answer is: Cell
49. How will you graphically represent expenditure in different departments ?
Correct Answer is: Pie Chart
50. What type of chart is good for single series of data ?
Correct Answer is: Pie Chart
51. What type of chart will you use to compare performance of sales of two products ?
Correct Answer is: Column Chart
52. Multiple calculations can be made in a single formula using
Correct Answer is: Array Formula
53. Which elements of a worksheet can be protected from accidental modification?
Correct Answer is: All of the above
54. In help menu of Excel, which of the following tabs are found?
Correct Answer is: all of the above.
55. What does COUNTA () function do ?
Correct Answer is: counts non-empty cells
56. What is the shortcut key to insert current date in a cell ?
Correct Answer is: CTRL + ;
57. To select an entire column in MS-EXCEL, press?
Correct Answer is: None of the above
58. What is the short cut key to replace a data with another in sheet ?
Correct Answer is: Ctrl + H
59. What is the shortcut key to hide entire column ?
Correct Answer is: CTRL + 0
60. What is the short cut key to highlight the entire column ?
