Microsoft Excel MCQs with answers Page - 91

The advantage of using a spreadsheet is option (4) all of the above. Using a spreadsheet offers several advantages: Calculations can be done automatically: Spreadsheets have built-in functions and formulas that allow you to perform calculations automatically. You can create complex formulas to calculate sums, averages, percentages, and more without the need for manual calculations. Changing data automatically updates calculations: One of the key advantages of spreadsheets is that when you change the input data, the associated calculations and formulas are updated automatically. This ensures that your calculations are always up to date and accurate without the need for manual recalculation. More flexibility: Spreadsheets provide flexibility in terms of organizing and analyzing data. You can easily sort and filter data, apply formatting, create charts and graphs, and perform "what-if" scenarios by changing input values. This flexibility allows you to analyze and present data in various ways to gain insights and make informed decisions. Therefore, all of the options mentioned in the question (calculations can be done automatically, changing data automatically updates calculations, and more flexibility) are advantages of using a spreadsheet.

The view that puts a blue line around each page that would be printed is option (3) Page Break Preview. Page Break Preview is a view in Excel that allows you to see how your worksheet will be divided and displayed across multiple pages when printed. In this view, Excel displays a blue line to indicate the page breaks.

Each Excel file is called a workbook because (3) it can contain many sheets including worksheets and chart sheets. In Microsoft Excel, a workbook is a file that can contain multiple sheets or tabs. These sheets can be of different types, such as worksheets for data entry and analysis or chart sheets for creating charts and graphs. A workbook provides a structure for organizing and managing data within Excel. It allows you to have multiple sheets within a single file, making it easier to organize related data and perform various calculations and analyses. The ability to have multiple sheets in a workbook is one of the key features of Excel and provides a powerful way to organize and manage data effectively. So, the correct answer is (3) it can contain many sheets including worksheets and chart sheets.

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.

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

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.

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.

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.