Examen 2 Parcial De Tic Excel
.jpg "Examen 2 Parcial De Tic Excel - Quiz")
Examen Tic, 1 Semestre de los Grupos A,B,C y D de Cecytes SPS. Tipo 1.
Questions and Answers
- 1.
Es la intersección de una fila por una columna
- A.
Casilla
- B.
Celda
- C.
Renglón
- D.
Cuadro de nombre
Correct Answer
B. CeldaExplanation
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.
Lista numerada
Correct Answer
B. RangoExplanation
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.
Verdadero
- B.
Falso
Correct Answer
B. FalsoExplanation
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.
Cuadro de nombres
- B.
Barra de Formulas
- C.
Rango
- D.
Barra de estado
Correct Answer
B. Barra de FormulasExplanation
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
Correct Answer
C. LibroExplanation
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
Correct Answer
D. HojasExplanation
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.
Barra de estado
- B.
Cuadro de nombres
- C.
Barra de formulas
- D.
Barra activa
Correct Answer
B. Cuadro de nombresExplanation
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.
Correct Answer
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
Correct Answer
C. ProtegerExplanation
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
Correct Answer
D. Ctrl + 1Explanation
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.
?
Correct Answer
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.
Orden personalizado
- D.
Filtro
Correct Answer
C. Orden personalizadoExplanation
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
Correct Answer
D. NumeroExplanation
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
Correct Answer
C. MaxExplanation
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)
Correct Answer
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.
Separadores
- C.
Margenes
- D.
Bordes
Correct Answer
D. BordesExplanation
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)
Correct Answer
B. =A3*C3Explanation
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)
Correct Answer
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
Correct Answer
A. =D7*0.16Explanation
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.
LA FORMULA NECESARIA EN LA LETRA D PARA SACAR EL TOTAL ES....
- A.
=D7+B7
- B.
=D8+D8
- C.
=D7+D8
- D.
=D7+D9
Correct Answer
C. =D7+D8Explanation
The correct answer is =D7+D8. This formula is used to calculate the total by adding the values in cell D7 and D8.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 19, 2013Quiz Created by
Jesushcv
UN Spanish Language Day Quiz: Test Your Spanish Vocabulary!
UN Spanish Language Day Quiz: Test Your Spanish Vocabulary!
Spanish Test - Translate these questions into English
Spanish Test - Translate these questions into English
Back to top