1000+ Microsoft Excel MCQ for SSC CPO [Solved]

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

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

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

4. What are the tabs that appear at the bottom of each workbook called?
A. Reference tabs
B. Position tabs
C. Location tabs
D. Sheet tabs
Answer : D

5. If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
A. From Edit menu choose Clear and then Formats
B. From Edit menu choose Delete
C. Click on Remove Formatting tool on Standard Toolbar
D. Double click the Format Painter and then press Esc key in keyboard
Answer : A

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

7. Excel uniquely identifies cells within a worksheet with a cell name
A. Cell names
B. Column numbers and row letters
C. Column letters and row numbers
D. Cell locator coordinates
Answer : C

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

9. It is acceptable to let long text flow into adjacent cells on a worksheet when
A. data will be entered in the adjecent cells
B. no data will be entered in the adjacent cells
C. there is no suitable abbrevition for the text
D. there is not time to format the text
Answer : B

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

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

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

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

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

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

17. Which of the following you can paste selectively using Paste Special command?
A. Validation
B. Formats
C. Formulas
D. All of above
Answer : D

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

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

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

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

22. What is the short cut key to replace a data with another in sheet?
A. Ctrl + R
B. Ctrl + Shift + R
C. Ctrl + H
D. Ctrl + F
Answer : C

23. Rounding errors can occur
A. Whe 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

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

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

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

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

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

29. Which of following is Not one of Excels what-if function?
A. Goal seek
B. Solver
C. Scenario manager
D. Auto Outline
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. 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

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

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

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

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

37. Which of the following is not a valid data type in Excel?
A. Number
B. Character
C. Label
D. Date/Time
Answer : B

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

39. Files created with Lotus 1-2-3 have an extension
A. DOC
B. XLS
C. 123
D. WK1
Answer : C

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

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

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

43. A typical worksheet has …. Number of columns
A. 128
B. 256
C. 512
D. 1024
Answer : B

44. You can select a single range of cells by
A. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
B. Pressing the Ctrl key while dragging over the desired cells
C. Pressing the Shift key and an arrow key
D. Dragging over the desired cells
Answer : D

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