Microsoft Excel MCQs with answers Page - 89

Gridlines in Excel can be (4) turned off for display but turned on for printing, turned on or off for printing, and turned off for display and printing.

Macros are "run" or executed from the (3) Tools menu. In Microsoft Excel, macros are small programs or scripts that automate tasks by performing a series of actions. To run a macro, you can access the Macros feature from the Tools menu.

Auto Calculate will quickly add selected cells if you option (2) click the AutoCalculate button on the toolbar. In Excel, the AutoCalculate feature allows you to quickly perform basic calculations on a selected range of cells without entering a formula. The AutoCalculate button is located on the toolbar, typically in the status bar area. By selecting the cells you want to add and then clicking the AutoCalculate button, Excel will automatically display the sum of the selected cells in the status bar.

The operator that you can use to combine text from two cells into one cell in Excel is the ampersand (&) operator. The ampersand operator acts as a concatenation operator, allowing you to join or concatenate text strings together. To use the ampersand operator, you simply place it between two text strings or cell references that you want to combine. For example, if you have text in cell A1 and text in cell B1, you can combine them into one cell using the following formula: =A1&B1. Here's an example: If cell A1 contains the text "Hello" and cell B1 contains the text "World", using the formula =A1&B1 in cell C1 would result in the combined text "HelloWorld" being displayed in cell C1. The ampersand operator can also be used to combine text with numeric values or other formula results. It is a versatile operator for string concatenation in Excel.

The worksheet in Excel contains option (1) 65,536 rows. In older versions of Excel (up to Excel 2003), the maximum number of rows in a worksheet was limited to 65,536. However, in newer versions of Excel (Excel 2007 and onwards), the maximum number of rows has been increased significantly to over a million rows.

To select several cells or ranges that are not touching each other in Excel, you would option (1) hold down the Ctrl key while selecting. By holding down the Ctrl key, you can select multiple non-adjacent cells or ranges in Excel. You can click on individual cells or click and drag to select multiple ranges while keeping the Ctrl key pressed. This allows you to create a selection that includes cells or ranges that are not next to each other

The correct answer is option (3) Ctrl + K. To add a hyperlink to your worksheet in Microsoft Excel, you can press the keyboard shortcut Ctrl + K. This shortcut opens the "Insert Hyperlink" dialog box, where you can specify the destination of the hyperlink. The "Insert Hyperlink" dialog box allows you to link to various types of destinations, such as a webpage, a file, a location within the current workbook, an email address, or a specific place in the workbook (such as a named range or a cell reference). Therefore, the correct answer is option (3) Ctrl + K.

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.

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.

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