Category | Microsoft Excel (MCQs)

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

Continue Reading

MCQ of Microsoft Excel – Set 5

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.

Continue Reading

MCQ of Microsoft Excel – Set 4

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

Continue Reading

MCQ of Microsoft Excel – Set 3

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

Continue Reading

MCQ of Microsoft Excel – Set 2

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

Continue Reading

MCQ of Microsoft Excel – Set 1

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    

Continue Reading

error: Content is protected !!