Excel Microsoft 365 Exam Questions and Answers 100% Solved
9 views 0 purchase
Course
Excel
Institution
Excel
Excel Microsoft 365 Exam Questions
and Answers 100% Solved
When would you use Excel for a task? - when creating a list of
employees with their ID numbers (Excel is commonly used for creating and
maintaining lists).
You are working in your company's "2018 Sales" Workbook with each
column widen...
You are using a button on the ribbon, and you are interested in learning
more about its functionality. How can you access "Tell me more"? -
✔✔Hover over the button, then click Tell me more at the bottom of the
information displayed.
You want to add an average in the worksheet shown below. You want to
learn more about the average function in Excel and think that a video will
assist you. How can you access training from the workbook? - ✔✔Click
Help from the menu bar.
What is the difference between a workbook and worksheet? - ✔✔A
workbook is the file and a worksheet is the individual tab within the
workbook.
You are adding dates in the spreadsheet shown below. What will happen
when you press Enter after entering the date as shown in cell C9? -
✔✔The date will appear as 8/1/2020 and will be right-aligned.
You are working in the most recent version of Excel provided by your
company. Why would you use the Save as type pull-down menu? -
✔✔You are saving the file for someone with an older version of Excel.
In the image below, what is most likely the reason the work order and
status columns are left-aligned while the cost column is right-aligned? -
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 JOSHCLAY. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.