100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
CIS 101: Microsoft Excel Expert Final Certification Test |Expert Answers| ACTUAL EXAM Question and Answers [100% Correct] 2025/2026 $9.43
Add to cart
Quickly navigate to
Preview
  2.  
  3. Microsoft
  4.  
  5. Microsoft

Exam (elaborations)

CIS 101: Microsoft Excel Expert Final Certification Test |Expert Answers| ACTUAL EXAM Question and Answers [100% Correct] 2025/2026

 0 purchase

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

[Show more]

Preview 2 out of 14  pages

Document information

  • November 20, 2024
  • 14
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

  • cis 101 microsoft excel expert final certificati

Written for

All documents for this subject (65)

Seller

avatar-seller
StellarGrades

Reviews received

Content preview

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

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

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

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.43. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69411 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling
$9.43
  • (0)
Add to cart
Added