1. What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
Correct : C. Pie Chart
2. The spelling dialog box can be involved by choosing spelling from ________ menu.
Correct : C. tools
3. Which key do you press to check spelling?
Correct : C. F7
4. To record a sequence of keystrokes and mouse actions to play back later we use:
Correct : D. Macro Recorder
5. We can save and protect the workbook by
Correct : D. Any of the above
6. The first cell in EXCEL worksheet is labeled as
Correct : B. A1
7. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
Correct : A. An absolute cell address is created.
8. What are the tabs that appear at the bottom of each workbook called?
Correct : D. Sheet tabs
9. What is represented by the small, black square in the lower-right corner of an active cell or range?
Correct : B. Fill handle
10. In Excel, a Data Series is defined as what?
Correct : C. A collection of related data
11. In Excel, the Fill Color button on the Formatting toolbar is used for what?
Correct : D. To add shading or color to a cell range.
12. In help menu of Excel, which of the following tabs are found?
Correct : D. all of the above.
13. A __________ is a grid with labeled columns and rows.
Correct : B. Worksheet
14. The active cell:
Correct : D. Only A and B.
15. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Correct : D. Financial
16. B7:B9 indicates:
Correct : B. Cells B7 through B9.
17. The Cancel and Enter buttons appear in the:
Correct : B. Formula bar
18. MS-EXCEL can be used to automate
Correct : D. Any of the above
19. NOT, AND, OR and XOR are
Correct : A. Logical Operators
20. In a report, you need to show the monthly rainfall in NepaThe best way to do this is to insert a
Correct : C. chart showing rainfall amounts
21. You want to record experiment information and create a chart that shows the rate of crystal growth over a period of timThe best application to use would be:
Correct : B. spreadsheet
22. You are editing an worksheet that you had previously saveIf you want to save the edited sheet without losing the original one, which command should you use?
Correct : B. Save As
23. If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
Correct : B. Insert a row
24. 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 : B. descending order
25. In order to perform a calculation in a spreadsheet, you need to use a:
Correct : B. formula
26. The box on the chart that contains the name of each individual record is called the ________.
Correct : D. legend
27. If you want all of the white cats grouped together in the database, you need to sort by ________.
Correct : B. Pet Type, then Color
28. You accidentally erased a record in the sheet. What command can be used to restore it immediately?
Correct : C. Undo
29. Where a row and a column meet, what do you call that?
Correct : A. A cell
30. How do you tell one cell from another?
Correct : C. By its address
31. Give me an example of a cell address.
Correct : D. A21
32. Which is an example of a formula?
Correct : A. =A1+A2
33. Which is an example of a function?
Correct : C. =SUM(A1:A2)
34. What is the symbol for multiplying?
Correct : D. *
35. What is the symbol for dividing?
Correct : A. A ./
36. A function inside another function is called _______
Correct : A. Nested function
37. Which of the following is not an underline option in the format cells dialog box?
Correct : D. Single Engineering
38. Formulas in Excel start with
Correct : B. =
39. The default header for a worksheet is
Correct : D. None
40. Which of the following is not an option of the spelling dialog box?
Correct : C. Edit
41. Which of the following methods will not enter data in a cell?
Correct : A. Pressing the Esc key
42. The cell reference for cell range of G2 to M12 is _______
Correct : C. G2:M12
43. What is the keyboard shortcut for creating a chart from the selected cell range?
Correct : D. F11
44. The Software which contains rows and columns is called ______
Correct : C. Spreadsheet
45. You can group noncontiguous worksheets with
Correct : B. The ctrl key and mouse
46. What is the AutoComplete feature of Excel?
Correct : B. It completes text entries that match an existing entry in the same column
47. Which of the following is correct?
Correct : D. =All of the above
48. Which of the following function will return a value of 8?
Correct : D. Only B and C
49. How to restrict to run a macro automatically when starting Microsoft Excel?
Correct : A. Hold down the SHIFT key during startup
50. How to remove the unwanted action from recorded macro without recording the whole macro again?
Correct : C. By edit the macro in the Visual Basic Editor
51. What should be add before a fraction to avoid entering it as a date?
Correct : D. Zero Space
52. Which of the following function will use to find the highest number in a series of number?
Correct : A. MAX(B1:B3)
53. What does the NOW() function return?
Correct : D. None of the above
54. What value will display if the formula = “$55.00″+5 is entered into a cell?
Correct : B. 60
55. What is the shortcut key to insert current date in a cell?
Correct : C. CTRL + ;
56. Which of the following syntax is correct regarding to SUM function in Excel?
Correct : D. All of the above
57. What is the shortcut key to hide entire column?
Correct : B. CTRL + 0
58. How to specify cell range from A9 to A99 in Excel?
Correct : C. (A9 : A99)
59. Selecting the Column G & H then choose Insert->Column, What will happen?
Correct : A. 2 Columns will be inserted after Column F
60. How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.
Correct : B. The Settings tab under the menu Data -> Validation
61. Clear the contents by pressing “DELETE” key from a keyboard will clear
Correct : C. Contents Only
62. Which of the following shortcuts can be used to insert a new line in the same cell?
Correct : B. Alt + Enter
63. What is the quickest way to select entire worksheet?
Correct : D. Click on the rectangle box on the upper left corner where column headings and row headings meet
64. A smart tag will be removed from a cell when
Correct : C. the data in the cell is changed or deleted
65. Which of the following options is appropriate to show the numbers 9779851089510 in a cell?
Correct : D. Apply the Text format in the cell and type the numbers
66. Which of the following is correct syntax in Excel?
Correct : A. =IF(LogicalTest, TrueResult, FalseResult)
67. Which of the following is correct?
Correct : B. =POWER(2,3)
68. Selecting the Rows 5 & 6 then choose Insert->RoWhat will happen?
Correct : A. 2 Rows will be inserted after Row 4
69. If 4/6 entered in a cell without applying any formats, Excel will treat this as
Correct : D. Date
70. If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “MCQ@Questions” in cell C1?
Correct : C. =A1 & “@” & B1
71. How to fit long texts in a single cell with multiple lines?
Correct : B. Use the Wrap Text option in the Format -> Alignment menu
72. If particular workbook have to open each time Excel started, where that workbook should be placed?
Correct : D. XLSTART Folder
73. If the cell B1 contains the formula = $A$1, which of the following statements is true
Correct : B. There is an absolute reference to cell A1
74. Worksheet can be renamed by
Correct : C. Double Click on the Worksheet tab and type new name
75. 1What is the shortcut key to hide entire row?
Correct : C. CTRL + 9
76. What is the shortcut key to insert a new comment in a cell?
Correct : D. Shift + F2
77. Which option allows you to Bold all the negative values within the selected cell range:
Correct : B. Conditional Formatting
78. What is the shortcut key to insert new sheet in current workbook?
Correct : D. Shift + F11
79. Which one is the last column header in Excel 2007?
Correct : A. XFD
80. In maximum, how many sheets can be set as default while creating new workbook?
Correct : B. 255
81. “New Comment” option can be found under _________ tab
Correct : C. Review
82. In Excel, by default Numeric Values appears in
Correct : B. Right aligned
83. To show/hide the grid lines in Microsoft Excel 2007
Correct : A. Page Layout -> Grid lines -> View
84. What will be the result if you type =A1=B1 in cell C1?