Microsoft Excel 1000+ MCQ with answer for SSC Stenographer

1. Which tool you will use to join some cells and place the content at the middle of joined cell?
A. From Format Cells dialog box click on Merge Cells check box
B. From Format Cells dialog box select the Centered alignment
C. From Format Cells dialog box choose Merge and Center check box
D. Click on Merge and Center tool on formatting toolbar
Answer : D

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

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

4. Which would you choose to create a bar diagram?
A. Edit, Chart
B. Insert, Chart
C. Tools, Chart
D. Format, Chart
Answer : B

5. The Name box on to the left of formula bar
A. shows the name of workbook currently working on
B. shows the name of worksheet currently working on
C. shows the name of cell or range currently working on
D. None of above
Answer : C

6. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
A. Use =if() function to format the required numbers red
B. Apply Conditional Formatting command on Format menu
C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
D. All of above
Answer : B

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

8. How do you rearrange the data in ascending or descending order?
A. Data, Sort
B. Data, Form
C. Data, Table
D. Data Subtotals
Answer : A

9. We can save and protect the workbook by
A. Write Reservation Password
B. Protection Password
C. Read-only Recommended
D. Any of the above
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. 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

12. Which elements of worksheet can be protected from accidental modification
A. Contents
B. Objects
C. Scenarios
D. All of above
Answer : D

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

14. A numeric value can be treated as label value if ...... precedes it.
A. Apostrophe ( )
B. Exclamation ( ! )
C. Hash ( # )
D. Tilde ( ~ )
Answer : A

15. Which of the following is a popular DOS based spreadsheet package?
A. Word
B. Smart cell
C. Excel
D. Lotus 1-2-3
Answer : D

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

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

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

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

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

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

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

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

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

25. Data can be arranged in a worksheet in a easy to understand manner using
A. auto formatting
B. applying styles
C. changing fonts
D. all of above
Answer : D

26. Which of the cell pointer indicates that you can fill series?
A. Doctors symbol (Big Plus)
B. small thin plus icon
C. Mouse Pointer with anchor at the tip
D. None of above
Answer : B

27. A numeric value can be treated as a label value if it precedes with
A. Apostrophe (&lsquo
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&
Answer : A

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

29. Documentation should include
A. Destination and users of the output data
B. Source of input data
C. Information on the purpose of the workbook
D. All of the above
Answer : D

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

31. You can convert existing excel worksheet data an charts to an HTML document by using
A. FTP wizard
B. Internet assistant wizard
C. Intranet wizard
D. Import wizard
Answer : B

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. In Excel, a Data Series is defined as what?
A. A type of chart
B. A cell reference
C. A collection of related data
D. A division of results
Answer : C

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

35. The Chart wizard term data categories refers to;
A. A chart plot area
B. A horizontal axis
C. The organization of individual values with a charts data series
D. The data range that supply chart data
Answer : B

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

37. Which of the following is not a worksheet design criterion?
A. Efficiency
B. Aditibility
C. Description
D. Clarity
Answer : C

38. Which of the cell pointer indicates you that you can make selection?
A. Doctors symbol (Big Plus)
B. small thin plus icon
C. Mouse Pointer with anchor at the tip
D. None of above
Answer : A

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 active cell:
A. is defined by a bold border around the cell
B. Receives the data the user enters
C. It is the formula bar
D. Only A and B
Answer : D

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

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

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

44. 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 resultsof formulas with different decimal places that the calculated results
Answer : A

45. Ctrl + D shortcut key in Excel will
A. Open the font dialog box
B. Apply double underline for the active cell
C. Fill down in the selection
D. None of above
Answer : C

46. Tab scroll buttons are place on Excel screen
A. towards the bottom right corner
B. towards the bottom left corner
C. towards the top right corner
D. towards the top left corner
Answer : B

47. When the formula bar is active, you can see
A. The edit formula button
B. The cancel button
C. The enter button
D. All of the above
Answer : D

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

49. Which of the following series type is not valid for Fill Series dialog box?
A. Linear
B. Growth
C. Autofill
D. Time
Answer : D

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