Prgramming MCQs Feed | Page - 4

                                            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.                                                

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

                                            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.                                                

                                            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.                                                

                                            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.                                                

                                            The correct answer is (1) One. In Microsoft Access, a table can have one primary key. A primary key is a unique identifier for each record in a table. It ensures that each record in the table is uniquely identified and provides a way to access and manipulate data in the table. The primary key can be composed of one or more fields in the table, but there can only be one primary key per table.                                                

                                            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.