Prgramming MCQs Feed | Page - 2

                                            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.                                                

                                            You can copy data or formulas in Excel using (4) All of the above methods. Excel provides multiple ways to copy data or formulas: With the copy, paste, and cut commands on the Edit menu: You can select the desired data or formulas, click on the Edit menu, and use the Copy, Paste, or Cut commands to duplicate or move the selected content. With commands on a shortcut menu: When you right-click on a selected cell or range, a shortcut menu appears. This menu contains options such as Copy, Paste, and Cut, which allow you to perform the respective actions on the selected content. With buttons on the standard toolbars: Excel includes standard toolbars with various buttons for common operations. The standard toolbars typically have buttons for Copy, Paste, and Cut, allowing you to click on these buttons to perform the corresponding actions. Using any of these methods, you can copy data or formulas within a worksheet, between worksheets, or even between different Excel files. So, the correct option is (4) All of the above.                                                

                                            The correct answer is option (2) Ctrl + 1. To open the Format Cells dialog box in Microsoft Excel, you can press the keyboard shortcut Ctrl + 1. This shortcut opens the Format Cells dialog box, which allows you to modify various formatting options for the selected cells or objects. The Format Cells dialog box provides options to customize the number format, font, alignment, border, fill, and other formatting settings in Excel. Therefore, the correct answer is option (2) Ctrl + 1.