Examen 2 Parcial De Tic Excel

When starting a function or formula, we begin editing with the character "=" because it is the symbol used to indicate that we are entering a formula or function in a spreadsheet or programming language. The "=" sign tells the software to interpret the following characters as a command or calculation rather than plain text.

The correct answer is "Celda" because it refers to the intersection of a row and a column in a table or grid. It is a term commonly used in spreadsheet programs or databases to represent a single unit of data within a larger structure.

The correct answer is "Max" because the function "Max" is used to find the highest numerical value in a range of cells. It returns the maximum value among the given arguments.

The correct answer is "Rango". This is because "Rango" refers to a range, which is the selection of multiple cells in a spreadsheet. The other options mentioned, such as "Columnas" (columns), "Dialogos" (dialogs), and "Lista numerada" (numbered list), do not accurately describe the selection of multiple cells. Therefore, "Rango" is the most appropriate answer.

The statement is false because columns are not ordered by numbers and rows are not ordered by letters. In a typical table or grid, columns are usually labeled with letters and rows are labeled with numbers.

The correct answer is =D7+D8. This formula is used to calculate the total by adding the values in cell D7 and D8.

The categories of cell format, such as General, Currency, Accounting, and Date, belong to the "Number" category. This category is used to format cells that contain numerical data, allowing users to customize how numbers are displayed in the cell.

Cuando se abre un archivo en Excel y aún no se ha guardado, el nombre del archivo se muestra en la barra de título como "Libro". Esto se debe a que en Excel, un archivo se conoce como un "libro" que contiene varias hojas de cálculo. Por lo tanto, hasta que se le asigne un nombre y se guarde, se muestra como "Libro" en la barra de título.

The correct answer is "=promedio (rango)". This formula is used to calculate the average of a selected range of cells. The "promedio" function in Excel is used to calculate the average, and "rango" refers to the range of cells that you want to include in the calculation. By using this formula, you can easily find the average value of a specific range of cells in Excel.

The correct answer is =A3*C3. This is because the formula multiplies the values in cell A3 and C3. The other options either add or multiply different cells, which are not specified in the question.

The correct answer is =SUMA(D3:D6). This formula calculates the sum of the values in cells D3 to D6.

The correct answer is "Hojas" because the question is asking what the Tags bar shows, and among the options given, "Hojas" is the only one that fits. The Tags bar typically displays the different sheets or tabs within a workbook or spreadsheet, allowing users to navigate and organize their data.

The correct answer is =D7*0.16. This formula is used to calculate the value of 16% of the value in cell D7. It multiplies the value in cell D7 by 0.16 to determine the result.

The correct answer is "Número, Alineación, Fuente, Bordes, Relleno y Proteger." This is because the "Format Cells" dialog box in Excel is divided into different tabs or sections, and these tabs include options for formatting cells. The "Número" tab allows you to format the number style and display, the "Alineación" tab allows you to adjust the alignment of the cell contents, the "Fuente" tab allows you to change the font style and size, the "Bordes" tab allows you to add or remove borders around cells, the "Relleno" tab allows you to fill cells with colors or patterns, and the "Proteger" tab allows you to protect cells from editing or make them read-only.

The correct answer is "Proteger" because the question is asking for the option in the "Formato de Celdas" dialog box that allows the user to lock or hide cells in the spreadsheet. The option "Proteger" is the most appropriate choice as it refers to the action of protecting cells, which includes both locking and hiding them.

To sort a database in ascending order using the second column, the "Orden personalizado" (Custom Order) tool needs to be used. This tool allows the user to define their own specific order for sorting the data. It provides flexibility in arranging the data according to specific requirements or preferences, unlike the predefined options of sorting in alphabetical or reverse alphabetical order.

The correct answer is "Bordes". This is because the question states that it refers to lines that can be placed to divide cells and appear when printing. "Bordes" translates to "borders" in English, which are lines that can be added to the edges of cells to separate them visually.

The correct answer is "Barra de Formulas". The barra de fórmulas, also known as the formula bar, is a toolbar located at the top of the Excel window. It displays the contents of the active cell, allowing users to view and edit the formulas or data in that cell. This feature is helpful for users to easily see and modify the formulas or data in a cell without directly editing the cell itself.

The correct answer is Ctrl + 1. This keyboard combination is used to access the Format Cells dialog box in various software applications, such as Microsoft Excel. By pressing Ctrl + 1, users can quickly open the dialog box and make changes to the formatting of selected cells, including number format, alignment, font, border, and fill options. This shortcut is commonly used by professionals to efficiently customize the appearance of their data.

The cuadro de nombres, or name box, is an element of the Excel window that indicates which cell is currently active. It displays the cell reference or name of the active cell, making it easier for users to identify and work with specific cells in their worksheets. The name box is located next to the formula bar at the top of the Excel window.