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 Incoming search terms:b7:b9 indicatesIf you want to have a blank line after the title in a […]

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. Incoming search terms:the […]

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 Incoming search terms:which language is used to create macros in excelwhich language is used to create macros in MS excelwhich […]

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 Incoming search terms:excel displays the current cell address in thehow do you display current date and time […]

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 Incoming search terms:an excel workbook is a collection ofms excel is based onexcel workbook is a collection ofms excel multiple […]

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     Incoming search terms:getting data from a cell located in a different sheet is calledconcatenation of text […]

Continue Reading