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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
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.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes 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 these notes for $7.56. You're not tied to anything after your purchase.
