Which command will you choose to convert a column of data into row?
✅ Correct Answer:Edit > Paste Special > Transpose
Explanation: To flip data from vertical (column) to horizontal (row) or vice versa, you use the 'Transpose' feature. Copy the data, go to the new location, open 'Paste Special', and check the 'Transpose' box. Simple Cut and Paste will keep the original orientation.
42
Which of the following option is not available in Paste Special dialog box?
✅ Correct Answer:SORT
Explanation: The Paste Special dialog box allows operations like 'Add', 'Subtract', 'Multiply', and 'Divide' (to do math while pasting). It also has options for Transpose and Skip Blanks. However, 'SORT' is a Data operation, not a Paste operation, and is not found in this dialog.
43
What happens when you press Ctrl + X after selecting some cells in Excel?
✅ Correct Answer:The cells selected are marked for cutting
Explanation: Unlike Word, where Ctrl+X makes text disappear immediately, in Excel, Ctrl+X only 'Marks' the cells for cutting (indicated by a moving dotted line or 'marching ants'). The content remains visible in the original cell until you actually press 'Paste' in the new location.
44
Which of the following Excel screen components can NOT be turned on or off?
✅ Correct Answer:None of these
Explanation: Excel is highly customizable. You can hide the Formula Bar, you can hide the Status Bar, and you can hide Toolbars (or the Ribbon in newer versions). Since ALL of these components CAN be turned on or off, the correct answer is 'None of these'.
45
How can you show or hide the gridlines in Excel Worksheet?
✅ Correct Answer:Go to Tools > Options > View tab and mark or remove the check box named Gridline
Explanation: Gridlines are the faint gray lines that separate cells. To show or hide them in older Excel, you used the Tools > Options menu (View tab). In modern Excel, there is a simple checkbox named 'Gridlines' in the 'View' tab on the Ribbon.
46
Where can you change automatic or manual calculation mode in Excel?
✅ Correct Answer:Go to Tools > Options > Calculation and mark the corresponding radio button
Explanation: In classic Excel, calculation settings were found in 'Tools > Options > Calculation'. In modern Excel, this is located under 'File > Options > Formulas' or the 'Formulas' tab on the Ribbon. You can select Automatic, Automatic except for data tables, or Manual.
47
You want to set such that when you type Baishakh and drag the fill handle. Excel should produce Jestha, Aashadh and so on. What will you set to effect that?
✅ Correct Answer:Custom List
Explanation: Excel knows standard lists like Mon, Tue, Wed. If you want it to recognize your own sequence (like Desi months: Baishakh, Jestha...), you must create a 'Custom List' in Excel Options. Once added, the AutoFill handle will recognize the pattern and fill the series automatically.
48
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
✅ Correct Answer:F9
Explanation: If Excel is set to 'Manual Calculation' mode (to save speed in heavy files), formulas won't update automatically when you change numbers. To force Excel to recalculate everything immediately, you must press the 'F9' key. (Shift+F9 calculates only the current sheet).
49
You can merge the main document with data source in Excel. In mail merge operation, Word is usually
✅ Correct Answer:client
Explanation: In a Mail Merge process involving Word and Excel: Excel holds the data (list of names/addresses), making it the 'Source'. Microsoft Word consumes that data to create letters, making it the 'Client' (or the Destination document) that requests the information.
50
Which of the following is not the correct method of editing the cell content?
✅ Correct Answer:Press the Alt key
Explanation: You can edit a cell by Double-clicking it, pressing F2, or clicking in the Formula Bar. However, pressing the 'Alt' key simply activates the Ribbon's Key Tips (menu shortcuts) and does not enter cell edit mode. It has no effect on the cell's content.
51
Each excel file is a workbook that contains different sheets. Which of the following cannot be a sheet in workbook?
✅ Correct Answer:data sheet
Explanation: In Excel's history, valid sheet types included 'Worksheets' (standard grid), 'Chart Sheets' (graphs), 'Dialog Sheets' (forms), and 'Module Sheets' (legacy VBA code). However, there is no formal sheet type called a 'Data sheet'. While worksheets hold data, 'Data sheet' is not a specific technical component in Excel structure.
52
The Name box on to the left of formula bar
✅ Correct Answer:shows the name of cell or range currently working on
Explanation: The Name Box is specifically designed to display the address of the currently active cell (like 'A1') or the name of the selected range (if you have named it, e.g., 'SalesData'). It does NOT show the file name (Workbook) or the sheet tab name.
53
Tab scroll buttons are place on Excel screen
✅ Correct Answer:towards the bottom left corner
Explanation: The Tab Scroll Buttons (small arrows) are located at the very bottom left corner of the Excel window, just to the left of the Sheet Tabs (Sheet1, Sheet2...). They are used to scroll through the list of sheet tabs if there are too many to fit on the screen.
54
Which tool you will use to join some cells and place the content at the middle of joined cell?
✅ Correct Answer:Click on Merge and Center tool on formatting toolbar
Explanation: The 'Merge and Center' button on the formatting toolbar is the most direct tool. It performs two actions in one click: it combines the selected cells into one large cell AND centers the text content horizontally within that new cell.
55
When a range is selected, how can you activate the previous cell?
✅ Correct Answer:Press Tab
Explanation: Note: There is a discrepancy in the provided options. The standard shortcut to activate the 'Previous' cell is 'Shift + Tab'. 'Tab' moves to the Next cell, and 'Enter' moves Down. Since 'Shift + Tab' is not listed, 'Press Tab' is often marked in older keys referring to navigation (albeit forward), but technically Shift+Tab is required for 'Previous'.
56
You can use the formula palette to
✅ Correct Answer:create and edit formulas containing functions
Explanation: The Formula Palette (Insert Function dialog) assists users in building complex formulas. It breaks down a function into its individual arguments, providing text boxes and descriptions for each part, ensuring the formula syntax is correct.
57
You can use the format painter multiple times before you turn it off by
✅ Correct Answer:Double clicking the format painter button
Explanation: A single click on the Format Painter applies formatting once and then turns off. By 'Double-clicking' the button, you lock it in the 'On' position, allowing you to click on multiple different cells to apply the same formatting repeatedly until you press Esc.
58
Excel files have a default extension of
✅ Correct Answer:Xls
Explanation: In older versions of Excel (up to Excel 2003), the default file extension was '.xls'. In modern versions (Excel 2007 and later), the default extension is '.xlsx' (XML format). However, '.xls' remains the classic answer for legacy Excel file questions.
59
An excel workbook is a collection of
✅ Correct Answer:Worksheets and charts
Explanation: An Excel file (Workbook) is a container that holds multiple sheets. These sheets can be standard 'Worksheets' (grids for data) or dedicated 'Chart Sheets' (full-page graphs). Therefore, a workbook is a collection of both worksheets and charts.
60
Which of the following is a popular DOS based spreadsheet package?
✅ Correct Answer:Lotus 1-2-3
Explanation: Before Windows became dominant, Lotus 1-2-3 was the industry standard spreadsheet for the DOS operating system. It was famous for integrating spreadsheets, graphing, and database functionality (hence the name 1-2-3).