1. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….
Correct : D. B1:G10
2. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
Correct : B. Right click on the spreadsheet tab and select DELETE
3. What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?
Correct : D. Trend line
4. what term describes a background that appears as a grainy, non smooth surface
Correct : A. gradient
5. Excel is a
Correct : D. A spreadsheet
6. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called
Correct : D. Pivot Table Report
7. Which of the following is not a valid Zoom percentage in Excel?
Correct : D. 500
8. The spelling tool is placed on ______ toolbar
Correct : A. Standard
9. If you need a text to show vertically in a cell. How will you achieve this?
Correct : B. Choose 90 Degrees in Orientation of Format Cells dialog box
10. Can you set 0.5 inch left indentation for a cell in Excel?
Correct : C. Indentation can be set from Format Cells dialog box
11. You can automatically adjust the size of text in a cell if they do not fit in width by
Correct : C. From Format Cells dialog box mark Shrink to fit check box
12. Formatting a cell in Currency, you can specify
Correct : C. Both of above
13. Formatting a cell in Number format you can’t set
Correct : D. Currency Symbol
14. What is entered by the function =today()
Correct : A. The date value for the day according to system clock
15. Which function will you use to enter current time in a woksheet cell?
Correct : B. =now()
16. Special category of Number tab in Format Cells dialog box can be used to apply formats like
Correct : C. Both of above
17. Merge cells option can be applied from
Correct : A. Format Cells dialog box Alignment Tab
18. Pre-made sheet formats like Simple, Classic, Accounting, Colorful et can be applied from
Correct : B. from Format >> Autoformat
19. Which of the following format you can decide to apply or not in AutoFormat dialog box?
Correct : D. All of above
20. How can you remove borders applied in cells?
Correct : C. Both of above
21. Where can you set the shedding color for a range of cells in Excel?
Correct : D. All of above
22. You can set Page Border in Excel from
Correct : D. You can not set page border in Excel
23. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Correct : B. Apply Conditional Formatting command on Format menu
24. You can check the conditions against __________ when applying conditional formatting
Correct : C. Both of above
25. Which of the following is not true regarding Conditional Formatting?
Correct : B. You can set condition to look for Bold and apply Italics on them.
26. Which of the following is invalid statement?
Correct : D. The width of a row and be specified manually or fit automatically
27. You can use the formula pallette to
Correct : B. create and edit formula containing functions
28. When a range is selected, how can you activate the previous cell?
Correct : D. None of above
29. Which tool you will use to join some cells and place the content at the middle of joined cell?
Correct : D. Click on Merge and Center tool on formatting toolbar
30. Tab scroll buttons are place on Excel screen
Correct : B. towards the bottom left corner
31. The Name box on to the left of formula bar
Correct : C. shows the name of cell or range currently working on
32. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
Correct : D. data sheet
33. Which of the following is not the correct method of editing the cell content?
Correct : A. Press the Alt key
34. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
Correct : C. client
35. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
Correct : B. F9
36. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?
Correct : A. Custom List
37. Where can you change automatic or manual calculation mode in Excel?
Correct : B. Go to Tools >> Options >> Calculation and mark the corresponding radio button
38. How can you show or hide the gridlines in Excel Worksheet?
Correct : C. Both of above
39. Which of the following Excel screen components can NOT be turned on or off?
Correct : D. None of above
40. What happens when you press Ctrl + X after selecting some cells in Excel?
Correct : B. The cells selected are marked for cutting
41. Which of the following option is not available in Paste Special dialog box?
Correct : D. SQRT
42. Which command will you choose to convert a column of data into row?
Correct : B. Edit >> Paste Special >> Transpose
43. It is acceptable to let long text flow into adjacent cells on a worksheet when
Correct : B. no data will be entered in the adjacent cells
44. Which of the cell pointer indicates you that you can make selection?
Correct : A. Doctor’s symbol (Big Plus)
45. Which of the cell pointer indicates that you can fill series?
Correct : B. small thin plus icon
46. Which of the cell pointer indicate that you can move the content to other cell?
Correct : C. Mouse Pointer with anchor at the tip
47. You can auto fit the width of column by
Correct : C. Double clicking on column right border on column header
48. Long text can be broken down into many lines within a cell. You can do this through
Correct : A. Wrap Text in Format >> Cells
49. MS Excel provides the default value for step in Fill Series dialog box
Correct : B. 1
50. When a row of data is to be converted into columns
Correct : D. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.
51. Ctrl + D shortcut key in Excel will
Correct : C. Fill down in the selection
52. The short cut key Ctrl + R is used in Excel to
Correct : C. Fill the selection with active cells to the right
53. The command Edit >> Fill Across Worksheet is active only when
Correct : B. When many sheets are selected
54. Which of the following series type is not valid for Fill Series dialog box?
Correct : D. Time
55. Which of the following you can paste selectively using Paste Special command?
Correct : D. All of above
56. Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
Correct : D. Divide
57. Edit >> Delete command
Correct : D. Deletes selected cells
58. To remove the content of selected cells you must issue ______ command
Correct : B. Edit >> Clear >> Contents
59. The Delete key of keyboard is assigned to which command in Excel?
Correct : A. Edit >> Clear >> Contents
60. If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
Correct : A. From Edit menu choose Clear and then Formats
61. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
Correct : A. Right click on Sheet Tab of third sheet and choose Delete from the context menu
62. Which of the following action removes a sheet from workbook?
Correct : A. Select the sheet, then choose Edit >> Delete Sheet
63. While Finding and Replacing some data in Excel, which of the following statement is valid?
Correct : A. You can Find and Replace within the sheet or workbook
64. Which of the following is not true about Find and Replace in Excel
Correct : D. You can search by rows or columns or sheets
65. You can move a sheet from one workbook into new book by
Correct : C. From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
66. What is the short cut key to replace a data with another in sheet?
Correct : C. Ctrl + H
67. Comments put in cells are called …..
Correct : B. Cell Tip
68. Comments can be added to cells using …..
Correct : B. Insert -> Comment
69. Which menu option can be used to split windows into two?
Correct : C. Window -> Split
70. Getting data from a cell located in a different sheet is called….
Correct : B. Referencing
71. Which of the following is not a valid data type in Excel?
Correct : B. Character
72. Which elements of a worksheet can be protected from accidental modification?
Correct : D. All of the above
73. A numeric value can be treated as label value if …… precedes it.
Correct : A. Apostrophe (‘)
74. Which area in an Excel window allows entering values and formulas?
Correct : C. Formula Bar
75. Multiple calculations can be made in a single formula using…..
Correct : B. Array Formula
76. An Excel Workbook is a collection of …….
Correct : D. Worksheets and Charts
77. What do you mean by a Workspace?
Correct : D. Group of Workbooks
78. MS-EXCEL is based on ……….?
Correct : A. WINDOWS
79. In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
Correct : C. Auto sum
80. To select an entire column in MS-EXCEL, press?
Correct : D. None of the above
81. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
Correct : C. MOD ( )
82. Which function is not available in the Consolidate dialog box?
Correct : A. Pmt
83. Which is not the function of “Edit, Clear” command?
Correct : C. Delete cells
84. Microsoft Excel is a powerful………..
Correct : B. Spreadsheet package
85. How do you rearrange the data in ascending or descending order?
Correct : A. Data, Sort
86. Which Chart can be created in Excel?
Correct : D. All of the above
87. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?
Correct : B. 5436.8
88. How do you display current date and time in MS Excel?
Correct : C. now ()
89. How do you display current date only in MS Excel?
Correct : B. Today ()
90. How do you wrap the text in a cell?
Correct : D. Format, cells, alignment
91. What does COUNTA () function do?
Correct : D. counts non-empty cells
92. What is the short cut key to highlight the entire column?
Correct : D. Ctrl+Space Bar
93. In the formula, which symbol specifies the fixed columns or rows?
Correct : A. $
94. Excel displays the current cell address in the ……….
Correct : C. Name Box
95. What is the correct way to refer the cell A10 on sheet3 from sheet1?
Correct : A. sheet3!A10
96. Which language is used to create macros in Excel?
Correct : A. Visual Basic
97. Which of the following is not a term of MS-Excel?
Correct : D. Document
98. How many worksheets can a workbook have?
Correct : D. none of above
99. Which would you choose to create a bar diagram?
Correct : B. Insert, Chart
100. Which setting you must modify to print a worksheet using letterhead?