Microsoft Excel MCQ Solved Paper for ESIC

1. Which of the following is the latest version of Excel
A. Excel 2000
B. Excel 2002
C. Excel ME
D. Excel XP
Answer : D

2. Which of the following is not true about Find and Replace in Excel
A. You can search for bold and replace with italics
B. You can decide whether to look for the whole word or not
C. You can search in formula too
D. You can search by rows or columns or sheets
Answer : D

3. You can use the drag and drop method to
A. Copy cell contents
B. Move cell contents
C. Add cell contents
D. a and b
Answer : D

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

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

6. When a row of data is to be converted into columns
A. Copy the cells in row, select the same number of cells in row and paste
B. Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
C. Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
D. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
Answer : D

7. Which area in an Excel window allows entering values and formulas?
A. Title Bar
B. Menu Bar
C. Formula Bar
D. Standard Tool Bar
Answer : C

8. Excel files have a default extension of
A. Xls
B. Xlw
C. Wk1
D. 123
Answer : A

9. The Delete key of keyboard is assigned to which command in Excel?
A. Edit >> Clear >> Contents
B. Edit >> Clear >> All
C. Edit >> Delete
D. All of above
Answer : A

10. Which of the following is a correct order of precedence in formula calculation?
A. Multiplication and division exponentiation positive and negative values
B. Multiplication and division, positive and negative values, addition and subtraction
C. Addition and subtraction, positive and negative values, exponentiation
D. All of above
Answer : D

11. The autofill feature
A. extends a sequential series of data
B. automatically adds range of cell values
C. applies a boarder around the selected cells
D. none of the above
Answer : D

12. Which function is not available in the Consolidate dialog box?
A. Pmt
B. Average
C. Max
D. Sum
Answer : A

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

14. Which of the following is not a term of MS-Excel?
A. Cells
B. Rows
C. Columns
D. Document
Answer : D

15. To record a sequence of keystrokes and mouse actions to play back later we use:
A. Media player
B. Sound Recorder
C. Calculator
D. Macro Recorder
Answer : D

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

17. You can use the format painter multiple times before you turn it off by
A. You can use the format painter button on ly one time when you click it
B. Double clicking the format painter button
C. Pressing the Ctrl key and clicking the format painter button
D. Pressing the Alt key and clicking the format painter button
Answer : B

18. Which is used to perform what if analysis?
A. Solver
B. Goal seek
C. Scenario Manager
D. All of above
Answer : D

19. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
A. None of these
B. Select Format > Money from the menu
C. Click the Currency Style button on the formatting toolbar
D. You have to retype everything and manually add the dollar signs, commas, and decimals
Answer : C

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

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

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

23. How can you delete a record?
A. Delete the column from the worksheet
B. Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
C. Select Data > Delete Record from the menu
D. Click the Delete button on the Standard toolbar
Answer : B

24. To copy cell contents using drag and drop press the
A. End key
B. Shift key
C. Ctrl key
D. Esc key
Answer : A

25. Tab scrolling button
A. Allow you to view a different worksheet
B. Allow you to view additional worksheet rows down
C. Allow you to view additional worksheet columns to the right
D. Allow you to view additional sheets tabs
Answer : D

26. Which of the following is not information you can specify using the solver?
A. Input cells
B. Constraints
C. Target cell
D. Changing cells
Answer : A

27. Comments put in cells are called .....
A. Smart Tip
B. Cell Tip
C. Web Tip
D. Soft Tip
Answer : B

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

29. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
A. ROUND ( )
B. FACT ( )
C. MOD ( )
D. DIV ( )
Answer : C

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

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

32. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
A. Unfreeze panes command on the window menu
B. Freeze panes command on the window menu
C. Hold titles command on the edit menu
D. Split command on the window menu
Answer : B

33. Which of the following is not the correct method of editing the cell content?
A. Press the Alt key
B. Press the F2 key
C. Click the formula bar
D. Double click the cell
Answer : A

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

35. Where can you set the shading color for a range of cells in Excel?
A. Choose required color form Patterns tab of Format Cells dialog box
B. Choose required color on Fill Color tool in Formatting toolbar
C. Choose required color on Fill Color tool in Drawing toolbar
D. All of above
Answer : D

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

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

38. Which of the following methods can not be used to edit the contents of a cell?
A. Press the Alt key
B. Clicking the formula bar
C. Pressing the F2 key
D. Double clicking the cell
Answer : A

39. Which of following is Not one of Excels what-if function?
A. Goal seek
B. Solver
C. Scenario manager
D. Auto Outline
Answer : D

40. Which of the following options is not located in the Page Setup dialog box?
A. Page Break Preview
B. Page Orientation
C. Margins
D. Headers and Footers
Answer : A

41. If you begin typing an entry into a cell and then realize that you dont want your entry placed into a cell, you:
A. Press the Erase key
B. Press Esc
C. Press the Enter button
D. Press the Edit Formula button
Answer : B

42. To create a formula, you first:
A. Select the cell you want to place the formula into
B. Type the equals sign (=) to tell Excel that youre about to enter a formula
C. Enter the formula using any input values and the appropriate mathematical operators that make up your formula
D. Choose the new command from the file menu
Answer : B

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

44. In a worksheet you can select
A. The entire worksheet
B. Rows
C. Columns
D. All of the above
Answer : B

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

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

47. To select an entire column in MS-EXCEL, press?
A. CTRL + C
B. CTRL + Arrow key
C. CTRL + S
D. None of the above
Answer : D

48. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
A. F8
B. F9
C. F10
D. F11
Answer : B

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

50. How can you find specific information in a list?
A. Select Tools > Finder from the menu
B. Click the Find button on the standard toolbar
C. Select Insert > Find from the menu
D. Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
Answer : D