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 (more…) Incoming search terms:b7:b9 indicatesIf you want to have a blank line after the title in […]
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. (more…) Incoming search […]
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 (more…) Incoming search terms:which language is used to create macros in excelwhich language is used to create macros in MS […]
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 (more…) Incoming search terms:how do you display current date and time in ms excelexcel displays the current […]
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 (more…) Incoming search terms:an excel workbook is a collection ofms excel is based onexcel workbook is a collection ofThe purpose […]
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   (more…) Incoming search terms:getting data from a cell located in a different sheet is calledconcatenation of […]
MCQ Questions by Ganesh Maharjan
