MS EXCEL MCQs Quiz Multiple Choice Questions & Answers

1. What is the short cut key to highlight the entire column ?

1. Ctrl + Right Arrow key
2. None of the above
3. Ctrl + Space Bar
4. Ctrl + Enter

2. How do you rearrange the data in ascending or descending order ?

1. Data, Table
2. None of the above
3. Data, Sort
4. Data, Form

3. If 4/6 entered in a cell without applying any formats, Excel will treat this as

1. Fraction
2. None of the above
3. Date
4. Text

4. How do you display current date and time in MS Excel?

1. now ()
2. time ()
3. date ()
4. Today ()

5. How do you display current date only in MS Excel?

1. now ()
2. time ()
3. date ()
4. Today ()

6. Formatting a cell in Currency, you can specify

1. Percentage symbol
2. None of the above
3. Decimal Places
4. Currency Symbol

7. Which is not the function of “Edit, Clear” command?

1. Delete cells
2. Delete formats
3. Delete contents
4. Delete notes

8. Which of the following is not an underline option in the format cells dialog box?

1. Double Accounting
2. Single Engineering
3. Double
4. Single Accounting

9. Comments can be added to cells using

1. File -> Comments
2. View –> Comments
3. Edit -> Comments
4. Insert -> Comment

10. Which would you choose to create a bar diagram?

1. Tools, Chart
2. Format, Chart
3. Edit, Chart
4. Insert, Chart

11. Which of the following options is appropriate to show the numbers 9779851089510 in a cell?

1. Place the character TX before the number
2. Apply the Text format in the cell and type the numbers
3. Enclose the number is brackets
4. Place the character T before the number

12. Which of the following shortcuts can be used to insert a new line in the same cell?

1. Ctrl + Enter
2. Shift + Enter
3. Enter
4. Alt + Enter

13. An Excel file is generally called a / an :

1. Workbook
2. Sheet
3. E-Spreadsheet
4. Woorksheet

14. Which of the following is the oldest spreadsheet package ?

1. VisiCalc
2. None of the above
3. Excel
4. StarCalc

15. Which key do you press to check spelling?

1. F7
2. F9
3. F3
4. F5

16. What is the keyboard shortcut for creating a chart from the selected cell range ?

1. F11
2. F12
3. F9
4. F10

17. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts ?

1. Logical
2. None of the above
3. Financial
4. Statistical

18. MS-EXCEL can be used to automate

1. Accounts receivable, accounts payable
2. Any of the above
3. Financial statements, Business forecasting
4. Transaction registers, inventory control

19. Which of the following format you can decide to apply or not in AutoFormat dialog box ?

1. Border format
2. All of the above
3. Font format
4. Number format

20. Which menu option can be used to split windows into two?

1. Window -> Split
2. View –> Split
3. Format -> Window
4. View -> Window-> Split

21. How do you wrap the text in a cell?

1. format, cells, number
2. Format, cells, alignment
3. Format, cells, font
4. Format, cells, protection

22. Which of the following you can paste selectively using Paste Special command ?

1. Formulas
2. All of the above
3. Formats
4. Validation

23. You can check the conditions against …………………………….when applying conditional formatting

1. Both (A) and (B)
2. None of the above
3. Formula
4. Cell value

24. A features that displays only the data in column (s) according to specified criteria

1. Filtering
2. Pivot
3. Formula
4. Sorting

25. What do you mean by a Workspace?

1. Group of Rows
2. Group of Workbooks
3. Group of Columns
4. Group of Worksheets

26. Which of the following function will use to find the highest number in a series of number ?

1. MAX(B1:B3)
2. None of the above
3. HIGH (B1:B3)
4. MAXIMUM (B1:B3)

27. How to restrict to run a macro automatically when starting Microsoft Excel?

1. Hold down the ESC key during startup
2. Hold down the ALT key during startup
3. Hold down the SHIFT key during startup
4. Hold down the CTRL key during startup

28. Which of the following is not an option of the spelling dialog box?

1. Edit
2. Change
3. Ignore
4. Ignore all

29. The spelling dialog box can be involved by choosing spelling from ……………………...menu.

1. tools
2. view
3. insert
4. file

30. You accidentally erased a record in the sheet. What command can be used to restore it immediately?

1. Undo
2. Replace
3. Insert
4. Copy

31. The active cell:

1. It is the formula bar.
2. Only A and B.
3. is defined by a bold border around the cell.
4. Receives the data the user enters.

32. What is the AutoComplete feature of Excel?

1. It completes text and numeric entries that match an existing entry in the same column
2. It completes text entries that match an existing entry in the same worksheet
3. It automatically completes abbreviated words
4. It completes text entries that match an existing entry in the same column

33. What does the NOW() function return?

1. It returns the serial number of the current time
2. None of the above
3. It returns the serial number of the current date and time
4. It returns the serial number of the current date

34. Long text can be broken down into many lines within a cell. You can do this through

1. Conditional Formatting
2. None of the above
3. Justify
4. Wrap Text

35. In Excel, by default Numeric Values appears in.

1. Center aligned
2. Justify aligned
3. Left aligned
4. Right aligned

36. What are the tabs that appear at the bottom of each workbook called ?

1. Reference tabs
2. None of the above
3. Location tabs
4. Sheet tabs

37. To record a sequence of keystrokes and mouse actions to play back later we use

1. Calculator
2. Macro Recorder
3. Media player
4. Sound Recorder

38. A function inside another function is called

1. Inner function
2. None of the above
3. Nested function
4. Round function

39. Which functionin Excel tells how many numeric entries are there ?

1. SUM
2. CHKNUM
3. NUM
4. COUNT

40. Which of the following is not a valid data type in Excel ?

1. Label
2. None of the above
3. Number
4. Character

41. Which setting you must modify to print a worksheet using letterhead?

1. Layout
2. Orientation
3. Paper
4. Margin

42. What type of chart is useful for comparing parts of a whole ?

1. Line Chart
2. Dot Graph
3. Pie Chart
4. Column Chart

43. What type of chart is useful for comparing vaues over categories ?

1. Line Chart
2. Dot Graph
3. Pie Chart
4. Column Chart

44. What type of chart is useful for showing trends or changes over time ?

1. Line Chart
2. Dot Graph
3. Pie Chart
4. Column Chart

45. What do you use to create a chart?

1. Data Wizard
2. Chart Wizard
3. Pie Wizard
4. Excel Wizard

46. Which function is not available in the Consolidate dialog box?

1. Max
2. Sum
3. Pmt
4. Average

47. Which of the following methods will not enter data in a cell?

1. Pressing the tab key
2. Clicking the enter button to the formula bar
3. Pressing the Esc key
4. Pressing an arrow key

48. Getting data from a cell located in a different sheet is called

1. Functioning
2. None of the above
3. Referencing
4. Accessing

49. If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?

1. Increase the column width
2. Use the spacebar
3. Re-format the spreadsheet
4. Insert a row

50. Text formula:

1. Concatenate and manipulate text
2. None of the above
3. Replace cell references
4. Return ASCII value of chracters