Exam (elaborations)
EXCEL MICROSOFT 365 EXAM WITH QUESTIONS AND VERIFIED ANSWERS
- Course
- Institution
EXCEL MICROSOFT 365 EXAM WITH QUESTIONS AND VERIFIED ANSWERS...
[Show more]
Content preview
EXCEL MICROSOFT 365 EXAM WITHQUESTIONS AND VERIFIED ANSWERS
When should you use Excel for a task? - ANSWER while establishing a list of
employees' ID numbers (Excel is widely used for list creation and maintenance).
You are working on your company's "2018 Sales" workbook, which has each
column enlarged and a color graph. When you add a worksheet titled "2018 Profit,"
how will it appear? - ANSWER using the same formatting as "2018 Sales" before
making any modifications.
A user wishes to quickly format a cell and right-clicks on it to access the features
shown in the image. What Excel tool is being used? ANSWER Mini Toolbar
You would like to include several commonly used buttons in the Quick Access
Toolbar. How do you do this? - ANSWER: Right-click the button in the ribbon and
select Add.
You're using a ribbon button and want to understand more about how it works.
How can you get to "Tell me more"? - ANSWER Hover over the button and then
click Tell me More at the bottom of the information that appears.
You want to enter an average into the worksheet given below. You wish to learn
more about the average function in Excel and believe that a video can help you.
How can you get instructions from the workbook? - ANSWER Click Help in the
menu bar.
What is the distinction between workbooks and worksheets? - ANSWER A
workbook is a file, while a worksheet is a specific tab within the workbook.
, You are adding dates to the spreadsheet shown below. What happens if you press
Enter after inputting the date as indicated in cell C9? - ANSWER The date will
show as 8/1/2020, right-aligned.
You are using the most recent version of Excel provided by your employer. Why
would you use the Save as type dropdown menu? - ANSWER You are saving the
file for someone who uses an older version of Excel.
What is the most likely reason for the left-aligned work order and status columns
and right-aligned cost column in the image below? - ANSWER Cells containing
alpha characters are automatically left-aligned, but cells with numeric characters
are right-aligned.
You select the Save icon from the top of an Excel workbook. The graphic below
displays what appears on your screen. Why are you seeing this screen? - ANSWER
This is a new file that has not yet been saved.
Which action cannot be undone using the Undo command? - ANSWER Delete a
tab in the workbook.
You are entering sales statistics for each month of 2018. How can you easily insert
all twelve months in columns? - ANSWER Type "January," then point to the lower
right corner of the cell, hold down the left mouse button, and drag over the next 11
rows.
As you insert sales data into a new worksheet, you accidentally type 6/31/2019.
What action will Excel do with this? - ANSWER Excel will display it as 6/31/2019,
but it will be left-justified and consist of digits and dashes rather than an actual
date.
You're working on the worksheet shown below. What happens in cell C4 if you use
the fill handle to move cell B4 to C4? (Formula in cell B4: =B2-B3) - ANSWER
The equation =C2-C3 will appear in cell C4.
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 Boostertips. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
85651 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now