MS Excel (Spreadsheet) परीक्षाको दृष्टिकोणले निकै महत्वपूर्ण र अलि जटिल खण्ड हो। यस लेखमा एक्सेलका फर्मुला र फिचरमा आधारित ५० वटा महत्त्वपूर्ण प्रश्नहरू छन्।
### MS Excel - Top 50 MCQs
**१. What is the default number of worksheets in a new workbook in MS Excel 2007?**
Answer: 3
**२. Which chart type is best for showing trends over a period of time?**
Answer: Line Chart
**३. What is the cell address of the very first cell in an Excel worksheet?**
Answer: A1
**४. Which function key is used to edit a selected cell in MS Excel?**
Answer: F2
**५. What type of cell referencing is $A$1?**
Answer: Absolute Cell Reference
**६. Which Excel function returns the current date and time?**
Answer: =NOW()
**७. Which Excel function returns only the current date?**
Answer: =TODAY()
**८. What is the maximum number of rows in an Excel 2007/2010 worksheet?**
Answer: 1,048,576
**९. What is the maximum number of columns in an Excel 2007/2010 worksheet?**
Answer: 16,384 (Columns up to XFD)
**१०. Which feature allows you to lock a row or column so it remains visible while scrolling?**
Answer: Freeze Panes
**११. What is the shortcut key to filter data in MS Excel?**
Answer: Ctrl + Shift + L
**१२. Which symbol separates cell ranges in a formula? (e.g., A1 to A10)**
Answer: Colon (:)
**१३. In Excel, a comment attached to a cell is called:**
Answer: Cell Tip
**१४. What error code appears when a value is divided by zero in Excel?**
Answer: #DIV/0!
**१५. Which tool is used to summarize and analyze large amounts of data in Excel?**
Answer: Pivot Table
**१६. What is the shortcut key to select the entire column in Excel?**
Answer: Ctrl + Spacebar
**१७. What is the shortcut key to select the entire row in Excel?**
Answer: Shift + Spacebar
**१८. Which function is used to join two or more text strings into one string?**
Answer: CONCATENATE
**१९. What is the shortcut key to insert the current time in Excel?**
Answer: Ctrl + Shift + ; (Colon)
**२०. Which tool helps you to achieve a specific target value by changing an input value?**
Answer: Goal Seek
**२१. VLOOKUP function searches for a value in:**
Answer: The first column of a table array
**२२. HLOOKUP stands for:**
Answer: Horizontal Lookup
**२३. What is the shortcut key to autosum a column of numbers?**
Answer: Alt + =
**२४. Which error occurs when Excel does not recognize text in a formula?**
Answer: #NAME?
**२५. The small black square at the bottom-right corner of a selected cell is called:**
Answer: Fill Handle
**२६. Which tab contains the 'Sort & Filter' commands?**
Answer: Data Tab
**२७. What is the shortcut key to hide a selected row in Excel?**
Answer: Ctrl + 9
**२८. What is the shortcut key to hide a selected column in Excel?**
Answer: Ctrl + 0
**२९. Can you password protect an Excel workbook?**
Answer: Yes
**३०. What is the output of =LEN("Computer") in Excel?**
Answer: 8
**३१. Which sign must all formulas begin with in MS Excel?**
Answer: Equal to sign (=)
**३२. What is the shortcut key to open the 'Go To' dialog box in Excel?**
Answer: F5
**३३. The intersection of a row and a column in Excel is called:**
Answer: Cell
**३४. What is the default file extension of MS Excel 2016?**
Answer: .xlsx
**३५. Which function counts the number of cells that contain numbers within a range?**
Answer: =COUNT()
**३६. Which function is used to find the highest value in a range?**
Answer: =MAX()
**३७. Which function is used to find the lowest value in a range?**
Answer: =MIN()
**३८. What is the shortcut key to insert a new worksheet in Excel?**
Answer: Shift + F11
**३९. Wrap text feature in MS Excel is used to:**
Answer: Display multi-line text inside a single cell
**४०. Which feature automatically changes the formatting of a cell based on its value?**
Answer: Conditional Formatting
**४१. What is the shortcut key to open the Format Cells dialog box?**
Answer: Ctrl + 1
**४२. Which error means that the column is not wide enough to display the text/number?**
Answer: #######
**४३. In MS Excel, charts are created using which option?**
Answer: Chart Wizard (or Insert > Chart)
**४४. What type of cell reference changes automatically when copied to another cell?**
Answer: Relative Cell Reference
**४5. Which command converts rows into columns or columns into rows?**
Answer: Transpose
**४६. What is the shortcut key to minimize the current workbook window?**
Answer: Ctrl + F9
**४७. What is the shortcut key to maximize or restore the workbook window?**
Answer: Ctrl + F10
**४८. Which box shows the address of the currently active cell?**
Answer: Name Box
**४९. Which bar allows you to enter or edit formulas and data in an active cell?**
Answer: Formula Bar
**५०. The collection of worksheets is called a:**
Answer: Workbook
### निष्कर्ष
यी ५० प्रश्नहरूले एक्सेलको प्राविधिक पक्षलाई बलियो बनाउनेछन्।