Microsoft Excel Expert Cert Test 1 *Q&A* (100% Correct) 2024/2025 |VERIFIED|
1 vista 0 veces vendidas
Grado
Microsoft
Institución
Microsoft
Microsoft Excel Expert Cert Test 1 *Q&A*
(100% Correct) 2024/2025 |VERIFIED|
What is the function to calculate the sum of cells from A1 to A10, excluding any errors in the range?
The function is `=SUMIF(A1:A10,"<>#DIV/0!")`
How can you quickly hide a column in Excel?
Right-click...
Microsoft Excel Expert Cert Test 1 *Q&A*
(100% Correct) 2024/2025 |VERIFIED|
What is the function to calculate the sum of cells from A1 to A10, excluding any errors in the range?
The function is `=SUMIF(A1:A10,"<>#DIV/0!")`
How can you quickly hide a column in Excel?
Right-click the column letter and select "Hide" from the context menu.
Which Excel feature allows you to automatically fill in values based on patterns in the data?
The feature is called "Flash Fill."
In Excel, how do you freeze the top row of a worksheet?
Go to the "View" tab, click "Freeze Panes," and select "Freeze Top Row."
What is the difference between the VLOOKUP and XLOOKUP functions?
VLOOKUP only searches vertically, while XLOOKUP can search both vertically and horizontally.
How can you apply conditional formatting to highlight cells that are greater than 100?
Use the "Conditional Formatting" option, select "Highlight Cells Rules," and then choose "Greater
Than" and input "100."
What is the shortcut key to open the "Find and Replace" dialog box in Excel?
Press `Ctrl + F` to open the "Find" dialog box and `Ctrl + H` to open "Find and Replace."
How can you create a drop-down list of values in a cell?
Use Data Validation, select "List" in the Allow box, and enter the values or reference a range of
cells.
1
, Which function in Excel can be used to count the number of cells that are not empty in a range?
The function is `COUNTA`.
How can you remove duplicate values from a range of cells?
Go to the "Data" tab, click "Remove Duplicates," and select the columns to check for duplicates.
How can you protect an Excel worksheet so that users cannot make changes to specific cells?
Select the cells you want to remain editable, unlock them, then protect the worksheet from the
"Review" tab.
What formula would you use to calculate the total interest on a loan over 5 years with an annual interest
rate of 6%?
Use the formula `=PMT(6%/12,5*12,-loan_amount)` to calculate monthly payments, and then
multiply by 60 (months) for the total interest.
How can you combine data from two cells (A1 and B1) into one cell with a space in between?
Use the formula `=A1 & " " & B1`.
What is the Excel function that calculates the average of a range of cells, ignoring any text or empty
cells?
The function is `AVERAGE`.
How do you insert a table in Excel?
Select a range of data, go to the "Insert" tab, and click on "Table."
Which Excel function would you use to find the largest value in a range of cells?
The function is `MAX`.
How do you add a comment to a cell in Excel?
2
Los beneficios de comprar resúmenes en Stuvia estan en línea:
Garantiza la calidad de los comentarios
Compradores de Stuvia evaluaron más de 700.000 resúmenes. Así estas seguro que compras los mejores documentos!
Compra fácil y rápido
Puedes pagar rápidamente y en una vez con iDeal, tarjeta de crédito o con tu crédito de Stuvia. Sin tener que hacerte miembro.
Enfócate en lo más importante
Tus compañeros escriben los resúmenes. Por eso tienes la seguridad que tienes un resumen actual y confiable.
Así llegas a la conclusión rapidamente!
Preguntas frecuentes
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
100% de satisfacción garantizada: ¿Cómo funciona?
Nuestra garantía de satisfacción le asegura que siempre encontrará un documento de estudio a tu medida. Tu rellenas un formulario y nuestro equipo de atención al cliente se encarga del resto.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller StellarGrades. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for $7.56. You're not tied to anything after your purchase.
