Microsoft Excel MCQs with answers Page - 90

The correct answer is (2) Merging. Merging cells in spreadsheet software, such as Microsoft Excel, involves combining two or more selected cells into a single cell. This operation is commonly used to create a larger cell that spans multiple columns or rows, allowing for a visually appealing layout or accommodating larger content in a single cell. Merging cells does not affect the data within the cells; it only affects the presentation of the cells.

To center a paragraph using shortcut keys in many word processing applications, including Microsoft Word, you can press (2) CTRL+E.

The correct answer is (4) Data. You can open the Sort dialog box by choosing Sort from the Data menu.

You can print only an embedded chart by (4) moving the chart to a chart sheet before you print and selecting the chart before you print. When an Excel chart is embedded within a worksheet, it is part of the worksheet's content, and by default, it will be printed along with the rest of the worksheet. However, if you want to print only the chart without the surrounding worksheet data, you can take the following steps: Move the chart to a chart sheet: Right-click on the chart, select "Move Chart" from the context menu, and choose the option to move the chart to a new chart sheet. This will separate the chart from the worksheet and place it on a dedicated chart sheet. Select the chart before printing: Once the chart is on a chart sheet, you can select it by clicking on it. Then, when you go to print, ensure that you have selected the "Selected Chart" option in the print settings. This will print only the selected chart and exclude the rest of the worksheet. By moving the chart to a chart sheet and selecting it before printing, you can isolate and print only the embedded chart. So, the correct answer is (4) a and c.

To use the Format Painter multiple times before turning it off, you can do so by (2) double-clicking the Format Painter button. By default, when you click the Format Painter button once, it allows you to apply the format to a single cell or range. However, if you double-click the Format Painter button, you can use it multiple times without having to click it again for each application. When you double-click the Format Painter button, it remains active until you manually turn it off by pressing the Esc key or by clicking the Format Painter button again. So, the correct answer is (2) double-clicking the Format Painter button.

The popular DOS-based spreadsheet package among the options provided is (4) Lotus 1-2-3. Lotus 1-2-3 was a widely used spreadsheet software application developed by Lotus Software, which was acquired by IBM. It was initially released in 1983 and became one of the most popular spreadsheet packages during the era of MS-DOS (Microsoft Disk Operating System). Lotus 1-2-3 was highly influential in the early days of personal computing, offering advanced features such as cell references, formula calculations, and graphing capabilities. It played a significant role in the widespread adoption of spreadsheet software for business and personal use.

When the formula bar is active in a spreadsheet application, you can indeed see (4) All of the above: the edit formula button, the cancel button, and the enter button. The formula bar is a section in the spreadsheet application where you can view and edit formulas or input data. It typically appears at the top of the application window, just below the toolbar or ribbon. The edit formula button, often represented by an icon such as a pencil or a small spreadsheet, allows you to edit the formula currently displayed in the formula bar. Clicking this button opens the formula for editing. The cancel button, often represented by an "X" or a cancel icon, allows you to discard any changes made to the formula and revert to the original formula or data. The enter button, often represented by a checkmark or an enter icon, allows you to confirm and apply the changes made to the formula in the formula bar. Clicking this button finalizes the edited formula or data. So, when the formula bar is active, all of the mentioned options (the edit formula button, the cancel button, and the enter button) are visible.

When you are typing an equation into a cell, the first thing that must be entered is option (4) an equal sign (=). In Excel, the equal sign is used to indicate that the contents of the cell should be treated as a formula or equation. By starting with an equal sign, Excel understands that you are entering a calculation or function. After entering the equal sign, you can then proceed to input the formula or equation, which may include cell references, operators, functions, and other elements.

To create only a horizontal page break in Excel, you would first select option (1) a row below the row where you want the page break to occur. Here's the process to create a horizontal page break in Excel: Select the row below the row where you want to insert the horizontal page break. Go to the "Page Layout" tab in the Excel ribbon. Click on the "Breaks" button in the "Page Setup" group. From the dropdown menu, select "Insert Page Break". By selecting the row below the desired page break location, you are indicating that you want the page break to occur after that row. This will cause the content below the page break to appear on a new page when you print or view the worksheet in Page Break Preview mode.