CIS 101: Microsoft Excel Expert Final
Certification Test |Expert Answers| ACTUAL
EXAM Question and Answers [100%
Correct] 2025/2026
What function in Excel is used to calculate the total sum of a range of numbers?
The correct answer is:
SUM
How would you apply a conditional ...
CIS 101: Microsoft Excel Expert Final
Certification Test |Expert Answers| ACTUAL
EXAM Question and Answers [100%
Correct] 2025/2026
What function in Excel is used to calculate the total sum of a range of numbers?
The correct answer is: SUM
How would you apply a conditional format that highlights cells with values greater than 100 in Excel?
The correct answer is: Use the Conditional Formatting feature and select "Greater Than" from the
dropdown, then enter 100.
Which Excel function would you use to find the average of a range of numbers?
The correct answer is: AVERAGE
What is the correct formula for calculating the future value of an investment in Excel?
The correct answer is: =FV(rate, nper, pmt, [pv], [type])
How can you quickly freeze the top row in an Excel worksheet?
The correct answer is: Go to the View tab and click "Freeze Panes," then select "Freeze Top Row."
In Excel, how would you change the orientation of your worksheet from portrait to landscape?
The correct answer is: Go to the Page Layout tab, click "Orientation," and select "Landscape."
How can you create a chart based on data in Excel?
The correct answer is: Select the data range and go to the Insert tab, then choose the desired
chart type.
1
, What is the purpose of using the VLOOKUP function in Excel?
The correct answer is: VLOOKUP is used to look up a value in a table and return a corresponding
value from another column.
How do you add a comment to a cell in Excel?
The correct answer is: Right-click the cell, select "New Comment," and type your comment.
What is the shortcut key to add a new worksheet in Excel?
The correct answer is: Press Shift + F11.
How would you remove duplicates from a range of data in Excel?
The correct answer is: Select the range, go to the Data tab, and click "Remove Duplicates."
What does the COUNTIF function do in Excel?
The correct answer is: COUNTIF counts the number of cells in a range that meet a specified
condition.
How do you add a hyperlink to a cell in Excel?
The correct answer is: Right-click the cell, select "Hyperlink," and enter the URL or file path.
What is the purpose of using absolute references in Excel formulas?
The correct answer is: Absolute references ($A$1) ensure that the cell reference does not change
when the formula is copied to another cell.
How would you protect a worksheet in Excel so that others cannot edit the content?
The correct answer is: Go to the Review tab, click "Protect Sheet," and set a password.
What is the difference between the CONCATENATE and TEXTJOIN functions 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 $9.38. You're not tied to anything after your purchase.
