Tutor Chetan - Notes Microsoft Office Package MS Excel- 100 MCQS Questions. Microsoft Excel - 100 MCQS Important Questions with Answers
Tutor Chetan - Notes
Microsoft Office Package
MS Excel - 100 MCQS Questions
Part 2
1. MS-Excel uses the …. function when creating a data
table.
- A. Average
- B. Count
- C. Both A and B
- D. Table
- Ans: D
2. Comments can be added to cells using ….
- A. Edit Comments
- B. Insert Comment
- C. File Comments
- D. View Comments
- Ans: B
3. Which menu option can be used to split windows into two?
- A. Format Window
- B. View Window Split
- C. Window Split
- D. View Split
- Ans: C
4. Getting data from a cell located in a different sheet is called….
- A. Accessing
- B. Referencing
- C. Updating
- D. Functioning
- Ans: B
5. Which of the following is not a valid data type in Excel?
- A. Number
- B. Character
- C. Label
- D. Date/Time
- Ans: B
6. Which elements of a worksheet can be protected from accidental modification?
- A. Contents
- B. Objects
- C. Scenarios
- D. All of the above
- Ans: D
7. A numeric value can be treated as label value if ______ precedes it.
- A. Apostrophe (‘)
- B. Exclamation (!)
- C. Hash (#)
- D. Tilde (~)
- Ans: A
8. Concatenation of text can be done using...
- A. Apostrophe (‘)
- B. Exclamation (!)
- C. Hash (#)
- D. Ampersand (&)
- Ans: D
9. Which area in an Excel window allows entering values and formulas?
- A. Title Bar
- B. Menu Bar
- C. Formula Bar
- D. Standard Tool Bar
- Ans: C
10. Multiple calculations can be made in a single formula using...
- A. Standard Formulas
- B. Array Formula
- C. Complex Formulas
- D. Smart Formula
- Ans: B
11. An Excel Workbook is a collection of …
- A. Workbooks
- B. Worksheets
- C. Charts
- D. Worksheets and Charts
- Ans: D
12. What do you mean by a Workspace?
- A. Group of Columns
- B. Group of Worksheets
- C. Group of Rows
- D. Group of Workbooks
- Ans: D
13. MS-EXCEL is based on ……….?
- A. WINDOWS
- B. DOS
- C. UNIX
- D. OS/2
- Ans: A
14. 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
- Ans: C
15. To select an entire column in MS-EXCEL, press?
- A. CTRL + C
- B. CTRL + Arrow key
- C. CTRL + S
- D. None of the above
- Ans: D
16. 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 ( )
- Ans: C
17. Which function is not available in the Consolidate dialog box?
- A. PMT
- B. Average
- C. Max
- D. Sum
- Ans: A
18. Which is not the function of “Edit, Clear” command?
- A. Delete contents
- B. Delete notes
- C. Delete cells
- D. Delete formats
- Ans: C
19. Microsoft Excel is a powerful ________.
- A. Word processing package
- B. Spreadsheet package
- C. Communication S/W Package
- D. DBMS package
- Ans: B
20. How do you rearrange the data in ascending or descending order?
- A. Data, Sort
- B. Data, Form
- C. Data, Table
- D. Data Subtotals
- Ans: A
21. Which Chart can be created in Excel?
- A. Area
- B. Line
- C. Pie
- D. All of the above
- Ans: D
22. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00’?
- A. 5,430.00
- B. 5,436.80
- C. 5,436.8
- D. 6.8
- Ans: B
23. How do you display current date and time in MS Excel?
- A. date ()
- B. Today ()
- C. now ()
- D. time ()
- Ans: C
24. How do you display current date only in MS Excel?
- A. date ()
- B. Today ()
- C. now ()
- D. time ()
- Ans: B
25. 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
- Ans: D
26. What does COUNTA () function do?
- A. counts cells having alphabets
- B. counts empty cells
- C. counts cells having number
- D. counts non-empty cells
- Ans: D
27. What is the short cut key to highlight the entire column?
- A. Ctrl+C
- B. Ctrl+Enter
- C. Ctrl+Page Up
- D. Ctrl+Space Bar
- Ans: D
28. In the formula, which symbol specifies the fixed columns or rows?
- A. $
- B. *
- C. %
- D. &
- Ans: A
29. Excel displays the current cell address in the ______.
- A. Formula bar
- B. Status Bar
- C. Name Box
- D. Title Bar
- Ans: C
30. 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
- Ans: A
31. Which language is used to create macros in Excel?
- A. Visual Basic
- B. C
- C. Visual C++
- D. Java
- Ans: A
32. Which of the following is not a term of MS-Excel?
- A. Cells
- B. Rows
- C. Columns
- D. Document
- Ans: D
33. How many worksheets can a workbook have?
- A. 3
- B. 8
- C. 255
- D. none of above
- Ans: D
34. Which would you choose to create a bar diagram?
- A. Edit, Chart
- B. Insert, Chart
- C. Tools, Chart
- D. Format, Chart
- Ans: B
35. Which setting you must modify to print a worksheet using letterhead?
- A. Paper
- B. Margin
- C. Layout
- D. Orientation
- Ans: B
36. What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
- A. XY Chart
- B. Line Chart
- C. Pie Chart
- D. Column Chart
- Ans: C
37. The spelling dialog box can be involved by choosing spelling from ________ menu.
- A. insert
- B. file
- C. tools
- D. view
- Ans: C
38. Which key do you press to check spelling?
- A. F3
- B. F5
- C. F7
- D. F9
- Ans: C
39. 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
- Ans: D
40. We can save and protect the workbook by...
- A. Write Reservation Password
- B. Protection Password
- C. Read-only Recommended
- D. Any of the above
- Ans: D
41. The first cell in EXCEL worksheet is labeled as...
- A. AA
- B. A1
- C. Aa
- D. A0
- Ans: B
42. What happens when dollar signs ($) are entered in a cell address? (ex. $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.
- Ans: A
43. 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
- Ans: D
44. What is represented by the small, black square in the lower-right corner of an active cell or range?
- A. Copy handle
- B. Fill handle
- C. Insert handle
- D. Border
- Ans: B
45. 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
- Ans: C
46. In Excel, the Fill Color button on the Formatting toolbar is used for what?
- A. To insert a background.
- B. To add borders.
- C. To select a distribution of figures.
- D. To add shading or color to a cell range.
- Ans: D
47. 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.
- Ans: D
48. A __________ is a grid with labeled columns and rows.
- A. Dialog box
- B. Worksheet
- C. Clipboard
- D. Toolbar
- Ans: B
49. 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.
- Ans: D
50. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
- A. Logical
- B. Math & Trigonometry
- C. Statistical
- D. Financial
COMMENTS