# Examen 2 Parcial De Tic Excel

Approved & Edited by ProProfs Editorial Team
At ProProfs Quizzes, our dedicated in-house team of experts takes pride in their work. With a sharp eye for detail, they meticulously review each quiz. This ensures that every quiz, taken by over 100 million users, meets our standards of accuracy, clarity, and engagement.
| Written by Jesushcv
J
Jesushcv
Community Contributor
Quizzes Created: 1 | Total Attempts: 4,388
Preguntas: 20 | Attempts: 4,411

Settings

Examen Tic, 1 Semestre de los Grupos A,B,C y D de Cecytes SPS. Tipo 1.

• 1.

### Es la intersección de una fila por una columna

• A.

Casilla

• B.

Celda

• C.

Renglón

• D.

B. Celda
Explanation
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.

Rate this question:

• 2.

### Es la selección de varias celdas

• A.

Columnas

• B.

Rango

• C.

Dialogos

• D.

B. Rango
Explanation
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.

Rate this question:

• 3.

### Las Columnas se ordenan por números y las Filas por letras

• A.

• B.

Falso

B. Falso
Explanation
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.

Rate this question:

• 4.

### Nos muestra el contenido de la celda activa, es decir, la casilla donde estamos situados

• A.

• B.

Barra de Formulas

• C.

Rango

• D.

B. Barra de Formulas
Explanation
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.

Rate this question:

• 5.

### El nombre de un archivo en Excel cuando no ha sido guardado se muestra en la barra de titulo como:

• A.

Documento

• B.

Hoja

• C.

Libro

• D.

Presentacion

C. Libro
Explanation
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.

Rate this question:

• 6.

### La barra de Etiquetas nos muestra:

• A.

Celdas

• B.

Rangos

• C.

Libros

• D.

Hojas

D. Hojas
Explanation
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.

Rate this question:

• 7.

### Elemento de la ventana de Excel que indica cuál es  la celda Activa

• A.

• B.

• C.

Barra de formulas

• D.

Barra activa

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

Rate this question:

• 8.

### El cuadro de diálogo de formato de celdas se divide en las siguientes pestañas:

• A.

Número, Celdas, Fuente, Bordes, Rangosy Proteger.

• B.

Número, Letras, Fuente, Bordes, Relleno y Calcular.

• C.

Número, Alineación, Fuente, Bordes, Relleno y Proteger.

• D.

Número, Eliminar, Fuente, Insertar, Relleno y Proteger.

C. Número, Alineación, Fuente, Bordes, Relleno y Proteger.
Explanation
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.

Rate this question:

• 9.

### La ficha técnica de la caja de diálogo Formato de Celdas que permite bloquear u ocultar celdas de la hoja de cálculo es

• A.

Formato

• B.

Numero

• C.

Proteger

• D.

Ocultar

C. Proteger
Explanation
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.

Rate this question:

• 10.

### Combinación de teclas utilizada para acceder al cuadro de dialogo Formato de celdas

• A.

Ctrl + F1

• B.

Alt + 1

• C.

Ctrl + B1

• D.

Ctrl + 1

D. Ctrl + 1
Explanation
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.

Rate this question:

• 11.

### Al Comenzar una Función o Formula comenzamos a editar con el caracter

• A.

*

• B.

/

• C.

=

• D.

?

C. =
Explanation
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.

Rate this question:

• 12.

### Ordenar una base de datos Ascendente con la observación que se usara la 2 Columna de la base de datos para ordenar todo se tiene que usar la herramienta......

• A.

Orden A a Z

• B.

Orden Z a A

• C.

• D.

Filtro

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

Rate this question:

• 13.

### Las categorías de formato  celda:  General, Moneda, Contabilidad, Fecha, pertenecen a

• A.

Bordes

• B.

Alineacion

• C.

Fuente

• D.

Numero

D. Numero
Explanation
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.

Rate this question:

• 14.

### Función que muestra el mayor  dato numérico de una serie de celdas:

• A.

Suma

• B.

Producto

• C.

Max

• D.

Contar

C. Max
Explanation
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.

Rate this question:

• 15.

### Fórmula que se utiliza para calcular el promedio de un rango de celdas seleccionadas:

• A.

=promedio / total valor

• B.

=promedio (rango)

• C.

=prom (a1:a20)

• D.

=calcular.promedio (rango)

B. =promedio (rango)
Explanation
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.

Rate this question:

• 16.

### Se le llama así a las líneas que se pueden colocar para dividir las celdas, y aparezcan al momento de imprimir.

• A.

Líneas de selección

• B.

• C.

Margenes

• D.

Bordes

D. Bordes
Explanation
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.

Rate this question:

• 17.

### Selecciona la respuesta correcta, en la letra A tomando en cuenta las coordenadas de la celdas

• A.

=A3+C3

• B.

=A3*C3

• C.

=A3*A6

• D.

=Suma (A3*C3)

B. =A3*C3
Explanation
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.

Rate this question:

• 18.

### Selecciona la respuesta correcta, en la letra B tomando en cuenta las coordenadas de la celdas

• A.

=SUM(D3..D6)

• B.

=D3:D6

• C.

=PROMEDIO (D3:D6)

• D.

=SUMA(D3:D6)

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

Rate this question:

• 19.

### EN LA LETRA C, LA FORMULA QUE SE NECESITA ES.......

• A.

=D7*0.16

• B.

=D7* IVA

• C.

=D7*D9

• D.

=D7*CELDAIVA

A. =D7*0.16
Explanation
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.

Rate this question:

• 20.

• A.

=D7+B7

• B.

=D8+D8

• C.

=D7+D8

• D.

=D7+D9