Prgramming MCQs Feed | Page - 6

                                            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.                                                

                                            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.                                                

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

                                            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 (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.                                                

                                            The correct answer is (1) Nested function. A function defined inside another function is called a nested function.                                                

                                            Data in a spreadsheet are organized in (3) rows and columns. In a spreadsheet, such as Microsoft Excel, data is arranged in a grid-like structure consisting of rows and columns. Each row is identified by a number, while each column is identified by a letter. The intersection of a row and a column is called a cell, which is the smallest unit of data in a spreadsheet. This row and column organization allows you to store and manipulate data in a structured and tabular format. Each cell can contain text, numbers, formulas, or other data types. By organizing data in rows and columns, you can easily input, manipulate, analyze, and visualize the data using various features and functions provided by the spreadsheet software. So, the correct answer is (3) rows and columns.                                                

                                            In a worksheet, you have the flexibility to select the entire worksheet, specific rows, and specific columns, making the correct option (4) All of the above.