MCQ of Microsoft Excel – Set 6
6-1. B7:B9 indicates: A. Cells B7 and cell B9 only. B. Cells B7 through B9. C. Cell B8 only. D. None of the above. 6-2. The Cancel and Enter buttons appear in the: A. Title bar B. Formula bar
p>
6-1. B7:B9 indicates: A. Cells B7 and cell B9 only. B. Cells B7 through B9. C. Cell B8 only. D. None of the above. 6-2. The Cancel and Enter buttons appear in the: A. Title bar B. Formula bar
5-1. The first cell in EXCEL worksheet is labeled as A. AA B. A1 C. Aa D. A0 5-2. 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.
4-1. Which language is used to create macros in Excel? A. Visual Basic B. C C. Visual C++ D. Java 4-2. Which of the following is not a term of MS-Excel? A. Cells B. Rows
3-1. Which Chart can be created in Excel? A. Area B. Line C. Pie D. All of the above 3-2. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00’? A. 5,430.00 B. 5,436.80
2-1. An Excel Workbook is a collection of ……. A. Workbooks B. Worksheets C. Charts D. Worksheets and Charts 2-2. What do you mean by a Workspace? A. Group of Columns B. Group of Worksheets
1-1. Comments put in cells are called ….. A. Smart Tip B. Cell Tip C. Web Tip D. Soft Tip 1-2. Comments can be added to cells using ….. A. Edit -> Comments B. Insert -> Comment
p>