1000+ Microsoft Excel MCQ for IIFT [Solved]

1. When you link data maintained in an excel workbook to a word document
A. The word document cannot be edit
B. The word document contains a reference to the original source application
C. The word document must contain a hyperlink
D. The word document contains a copy of the actual data
Answer : B

2. To delete an embedded objects, first
A. Double click the object
B. Select the object by clicking it
C. Press the Shift + Delete keys
D. Select it and then press the delete key
Answer : D

3. You can use the formula pallette to
A. format cells containing numbers
B. create and edit formula containing functions
C. enter assumptions data
D. copy a range of cells
Answer : B

4. Which of the cell pointer indicate that you can move the content to other cell?
A. Doctors symbol (Big Plus)
B. small thin plus icon
C. Mouse Pointer with anchor at the tip
D. None of above
Answer : C

5. While Finding and Replacing some data in Excel, which of the following statement is valid?
A. You can Find and Replace within the sheet or workbook
B. Excel does not have option to match case for find
C. Both are valid
D. None are valid
Answer : A

6. You can enter which types of data into worksheet cells?
A. Labels, values, and formulas
B. Labels and values but not formulas
C. Values and formulas but not labels
D. Formulas only
Answer : A

7. Which of the following format you can decide to apply or not in AutoFormat dialog box?
A. Number format
B. Border format
C. Font format
D. All of above
Answer : D

8. The name box
A. Shows the location of the previously active cell
B. Appears to the left of the formula bar
C. Appears below the status bar
D. Appears below the menu bar
Answer : B

9. You cannot link excel worksheet data to a word document
A. With the right drag method
B. With a hyperlink
C. With the copy and paste special commands
D. With the copy and paste buttons on the standard toolbar
Answer : D

10. Which of the following option is not available in Paste Special dialog box?
A. Add
B. Subtract
C. Divide
D. SQRT
Answer : D

11. To save a workbook, you:
A. Click the save button on the standard toolbar from the menu
B. Press Ctrl+F5
C. Click Save on the Windows Start button
D. Select Edit>Save
Answer : A

12. An Excel Workbook is a collection of .......
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and Charts
Answer : D

13. Which button do you click to add up a series of numbers?
A. The autosum button
B. The Formula button
C. The quicktotal button
D. The total button
Answer : A

14. You can use drag-and-drop to embed excel worksheet data in a word document
A. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
B. By dragging a range of excel data to the word button on the taskbar while pressing Shift key
C. By dragging a range of excel data to the word button on the taskbar while pressing Alt key
D. None of above
Answer : A

15. In Excel, the Fill Color button on the Formatting toolbar is used for what?
A. To insert a background
B. To add borders
C. To select a distribution of figures
D. To add shading or color to a cell range
Answer : D

16. Which of the following is an absolute cell reference?
A. !A!1
B. $A$1
C. #a#1
D. A1
Answer : B

17. How do you display current date only in MS Excel?
A. date ()
B. Today ()
C. now ()
D. time ()
Answer : B

18. How do you wrap the text in a cell?
A. Format, cells, font
B. Format, cells, protection
C. Format, cells, number
D. Format, cells, alignment
Answer : D

19. Status indicators are located on the
A. Vertical scroll bar
B. Horizontal scroll bar
C. Formula bar
D. Standard toolbar
Answer : C

20. Which language is used to create macros in Excel?
A. Visual Basic
B. C
C. Visual C++
D. Java
Answer : A

21. Edit >> Delete command
A. Deletes the content of a cell
B. Deletes Formats of cell
C. Deletes the comment of cell
D. Deletes selected cells
Answer : D

22. Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
A. Square
B. Percentage
C. Goal Seek
D. Divide
Answer : D

23. How do you display current date and time in MS Excel?
A. date ()
B. Today ()
C. now ()
D. time ()
Answer : C

24. The short cut key Ctrl + R is used in Excel to
A. Right align the content of cell
B. Remove the cell contents of selected cells
C. Fill the selection with active cells to the right
D. None of above
Answer : C

25. Which area in an excel window allows entering values and formulas
A. Title bar
B. Menu bar
C. Formula bar
D. Standard toolbar
Answer : C

26. Right clicking something in Excel:
A. Deletes the object
B. Nothing the right mouse button is there for left handed people
C. Opens a shortcut menu listing everything you can do to the object
D. Selects the object
Answer : C

27. To activate the previous cell in a pre-selected range, press
A. The Alt key
B. The Tab key
C. The Enter key
D. None of the above
Answer : D

28. What does COUNTA () function do?
A. counts cells having alphabets
B. counts empty cells
C. counts cells having number
D. counts non-empty cells
Answer : D

29. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
A. Pie chart
B. Row chart
C. Line chart
D. Column chart
Answer : C

30. You can auto fit the width of column by
A. double clicking on the column name on column header
B. Double click on the cell pointer in worksheet
C. Double clicking on column right border on column header
D. Double clicking on the column left border of column header
Answer : C

31. Which symbol must all formula begin with?
A. =
B. +
C. (
D. @
Answer : A

32. Comments can be added to cells using
A. Edit > Comments
B. Insert > Comments
C. File > Comments
D. View > Comments
Answer : B

33. How can you remove borders applied in cells?ACC
A. Choose None on Border tab of Format cells
B. Open the list on Border tool in Formatting toolbar then choose first tool (no border)
C. Both of above
D. None of above
Answer : C

34. To remove the content of selected cells you must issue ______ command
A. Edit >> Delete
B. Edit >> Clear >> Contents
C. Edit >> Clear >> All
D. Data >> Delete
Answer : B

35. It is acceptable to let long text flow into adjacent cells on a worksheet when
A. Data will be entered in the adjacent cells
B. No data will be entered in the adjacent cells
C. There is no suitable abbreviation of the text
D. There is not time to format the next
Answer : B

36. Rounding errors can occur
A. When you use multiplication, division, or exponentiation in a formula
B. When you use addition and subtraction in a formula
C. Because excel uses hidden decimal places in computation
D. When you show the results of formulas with different decimal places that the calculated results
Answer : A

37. The spelling dialog box can be involved by choosing spelling from ________ menu.
A. insert
B. file
C. tools
D. view
Answer : C

38. When a label is too long to fit within a worksheet cell, you typically must
A. Shorten the label
B. Increase the column width
C. Decrease the column width
D. Adjust the row height
Answer : B

39. What is the correct way to refer the cell A10 on sheet3 from sheet1?
A. sheet3!A10
B. sheet1!A10
C. Sheet3.A10
D. A10
Answer : A

40. The command Edit >> Fill Across Worksheet is active only when
A. One sheet is selected
B. When many sheets are selected
C. When no sheet is selected
D. None of above
Answer : B

41. Concatenation of text can be done using
A. Apostrophe ( )
B. Exclamation ( ! )
C. Hash ( # )
D. Ampersand ( & )
Answer : D

42. How many worksheets can a workbook have?
A. 3
B. 8
C. 255
D. none of above
Answer : D

43. What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
A. XY Chart
B. Line Chart
C. Pie Chart
D. Column Chart
Answer : C

44. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
A. work sheet
B. chart sheet
C. module sheet
D. data sheet
Answer : D

45. Where can you change automatic or manual calculation mode in Excel?
A. Double CAL indicator on status bar
B. Go to Tools >> Options >> Calculation and mark the corresponding raio button
C. Both of above
D. None of above
Answer : B

46. To copy formatting from one area in a worksheet and apply it to another area you would use:
A. The Edit > Copy Format and Edit>Paste Format commands form the menu
B. The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
C. There is no way to copy and apply formatting in Excel You have to do it manually
D. The Format Painter button on the standard toolbar
Answer : D

47. The chart wizard term data series refers to
A. A chart legend
B. A collection of chart data markers
C. A set of values you plot in a chart
D. A data label
Answer : B

48. Which of the following is not a valid data type in excel
A. Number
B. Character
C. Label
D. Date/time
Answer : B

49. When you want to insert a blank imbedded excel object in a word document you can
A. Click the object command on the insert menu
B. Click the office links button on the standard toolbar
C. Click the create worksheet button on the formatting toolbar
D. Click the import excel command on the file menu
Answer : A

50. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
A. 5430
B. 5436.80
C. 5436.8
D. 6.8
Answer : B