Prgramming MCQs Feed | Page - 4

                                            In page break preview, the selected print area shown in white background with blue line around each page, and dark grey area is not a print area, this area contain blank cell which not require to print.                                                

                                            The cell labeled F5 refers to option (2) column F row 5. In Excel, cell references are identified by their column letter and row number. The letter represents the column, and the number represents the row. In this case, the cell labeled F5 means it is in column F and row 5.                                                

                                            Book1 is an example of how option (4) Name box is used to number and name workbooks during each work session. In Excel, the Name box is located next to the formula bar and displays the cell reference of the active cell. It also allows you to assign or change a name for a selected range of cells or a workbook. By default, when you open a new workbook in Excel, it is typically named as "Book1" or a similar default name. However, you can change the name of the workbook by using the Name box or other options available in Excel.                                                

                                            To copy formatting from one area in a worksheet and apply it to another area, you would typically use (4) the Format Painter button on the standard toolbar. The Format Painter button is a tool available in spreadsheet applications like Microsoft Excel. It allows you to copy the formatting from one cell or range of cells and apply it to another cell or range of cells.                                                

                                            The correct answer is (2) On the file menu, click print, and then click selection under print what. This option allows you to print only the selected area of the worksheet. The other options mentioned in (1), (3), and (4) do not specifically address printing a selected area of a worksheet.                                                

                                            The correct answer is (2) To show a geographic distribution of data. A data map is a visual representation that displays data points or values on a map, usually using colors or symbols to indicate different values or categories. It is commonly used to show the geographic distribution of data, such as population density, economic indicators, or disease outbreaks. While some of the other options you mentioned may be useful for data visualization, such as comparing data points or showing changes over time, a data map specifically focuses on presenting data in relation to geographical locations.                                                

                                            The most common subtotal function used with the Subtotals command in Excel is the SUM function. It causes Excel to display the sum each time the control field changes. Therefore, the correct answer is (2) SUM.