Microsoft Excel 1000+ MCQ with answer for GATE

1. Which menu option can be sued to split windows into two
A. Format > window
B. View > window > split
C. Window > split
D. View > split
Answer : C

2. Text formulas:
A. Replace cell references
B. Return ASCII values of characters
C. Concatenate and manipulate text
D. Show formula error value
Answer : C

3. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
A. AutoFill
B. Auto correct
C. Auto sum
D. Auto format
Answer : C

4. 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

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

6. Excel displays the current cell address in the ........
A. Formula bar
B. Status Bar
C. Name Box
D. Title Bar
Answer : C

7. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
A. An absolute cell address is created
B. Cell address will change when it is copied to another cell
C. The sheet tab is changed
D. The status bar does not display the cell address
Answer : A

8. The auto calculate feature
A. Can only add values in a range of cells
B. Provides a quick way to view the result of an arithmetic operation on a range of cells
C. Automatically creates formulas and adds them to a worksheet
D. A and c
Answer : B

9. When a range is selected, how can you activate the previous cell?
A. Press the Alt key
B. Press Tab
C. Press Enter
D. None of above
Answer : D

10. How can you print three copies of a workbook?
A. Select File > Properties form the menu and type 3 in the Copies to print text box
B. Select File > Print from the menu and type 3 in the Number of copies text box
C. Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made
D. Press Ctrl+P+3
Answer : B

11. Which of the following Excel screen components can NOT be turned on or off?
A. Formula Bar
B. Status Bar
C. Tool Bar
D. None of above
Answer : D

12. 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

13. Which command will you choose to convert a column of data into row?
A. Cut and Paste
B. Edit >> Paste Special >> Transpose
C. Both of above
D. None of above
Answer : B

14. Each excel file is called a workbook because
A. It can contain text and data
B. It can be modified
C. It can contain many sheets including worksheets and chart sheets
D. You have to work hard to create it
Answer : C

15. Which is not the function of Edit, Clear command?
A. Delete contents
B. Delete notes
C. Delete cells
D. Delete formats
Answer : C

16. 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

17. You can move a sheet from one workbook into new book by
A. From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
B. From Edit menu choose Move of Copy then choose (Move to end) and click OK
C. From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
D. None of above
Answer : C

18. Which of the following is not an example of a value?
A. 350
B. May 10, 2001
C. 0.57
D. Serial Number 50771
Answer : D

19. Long text can be broken down into many lines within a cell. You can do this through
A. Wrap Text in Format >> Cells
B. Justify in Edit >> Cells
C. Text Wraping in Format >> Cells, Layout tab
D. All of above
Answer : A

20. How do you delete a column?
A. Select the column heading you want to delete and select the Delete Row button on the standard toolbar
B. Select the column heading you want to delete and select Insert Delete from the menu
C. Select the row heading you want to delete and select Edit>Delete from the menu
D. Right click the column heading you want to delete and select delete from the shortcut menu
Answer : D

21. We can save and protect the workbok by
A. Write Reservation Password
B. Protection Password
C. Read-only Recommended
D. Any of the above
Answer : D

22. Excel probably considers the cell entry January 1, 2000 to be a
A. Label
B. Value
C. Formula
D. Text string
Answer : B

23. 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 radio button
C. Both of above
D. None of above
Answer : B

24. Which setting you must modify to print a worksheet using letterhead?
A. Paper
B. Margin
C. Layout
D. Orientation
Answer : B

25. Which menu option can be used to split windows into two?
A. Format -> Window
B. View -> Window-> Split
C. Window -> Split
D. View > Split
Answer : C

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

27. 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

28. Which of the following methods cannot be used to enter data in a cell
A. Pressing an arrow key
B. Pressing the Tab key
C. Pressing the Esc key
D. Clicking on the formula bar
Answer : C

29. Which of the following is invalid statement?
A. Sheet tabs can be colored
B. Some picture can be applied as a background of a sheet
C. You can set the column width automatically fit the amount of text
D. The width of a row and be specified manually or fit automatically
Answer : D

30. In help menu of Excel, which of the following tabs are found?
A. Contents tab
B. Answer Wizard tab
C. Index tab
D. all of the above
Answer : D

31. In the formula, which symbol specifies the fixed columns or rows?
A. $
B. *
C. %
D. &
Answer : A

32. 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

33. You can set Page Border in Excel from
A. From Border tab in Format Cells dialog box
B. From Border tool in Formatting toolbar
C. From Line Style tool in Drawing toolbar
D. You can not set page border in Excel
Answer : D

34. 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

35. Which of the following formulas will Excel Not be able to calculate?
A. =SUM(Sales)-A3
B. =SUM(A1:A5)*.5
C. =SUM(A1:A5)/(10-10)
D. =SUM(A1:A5)-10
Answer : A

36. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
A. Press Ctrl +Home
B. Press Home
C. Press Shift + Home
D. Press Alt + Home
Answer : A

37. To create a formula, you can use:
A. Values but not cell references
B. Cell references but not values
C. Values or cell references although not both at the same time
D. Value and cell references
Answer : D

38. Which Chart can be created in Excel?
A. Area
B. Line
C. Pie
D. All of the above
Answer : D

39. MS Excel provides the default value for step in Fill Series dialog box
A. 0
B. 1
C. 5
D. 10
Answer : B

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

41. 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

42. 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

43. How many characters can be typed in a single cell in Excel?
A. 256
B. 1024
C. 32000
D. 65535
Answer : D

44. When you insert an excel file into a word document. The data are
A. Hyperlinked placed in a word table
B. Linked
C. Embedded
D. Use the word menu bar and toolbars
Answer : B