20:00

PDF|

Guide for Excel Associate (Office 365 and Office 2019)

Quiz Excel Associate (Office 365 and Office 2019)

Free Test
/ 10

Quiz

1/10
Topic 1, Clothing Orders
Case Study
Exhibit.
Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 2-2364869137


Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 1-3798899378


Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 3-2236661659
You are updating the sales spreadsheet for an online clothing store.
On the "Quote’’ worksheet move the cells E8:F32 up to correct the alignment by deleting cells E7:F7.
Select the answer
1 correct answer
Select and press delete on the home tab.

Quiz

2/10
Topic 1, Clothing Orders
Case Study
Exhibit.
Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 2-2364869137


Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 1-3798899378


Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 3-2236661659
On the ‘’Prices’’ worksheet, apply the Title style to cell A1.
Select the answer
1 correct answer
Home Tab/ Styles group/ cell styles

Quiz

3/10
Topic 1, Clothing Orders
Case Study
Exhibit.
Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 2-2364869137


Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 1-3798899378


Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 3-2236661659
On the ‘’Orders’’ worksheet, filter the table data to display only the orders from ‘’Alpine SKI House.’’
Select the answer
1 correct answer
On the data tab, click filter. Display only alpine.

Quiz

4/10
Topic 1, Clothing Orders
Case Study
Exhibit.
Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 2-2364869137


Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 1-3798899378


Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 3-2236661659
On the ‘’Prices’’ worksheet, in the ‘’Tax column, enter a formula that multiples the value in the ‘’Unit
Price’’ column by cell L2.
Select the answer
1 correct answer
=_*_

Quiz

5/10
Topic 1, Clothing Orders
Case Study
Exhibit.
Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 2-2364869137


Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 1-3798899378


Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 3-2236661659
On the ‘’Prices’’ worksheet, in the ‘’inventory Notice’’ column, use a function to display ‘’Low’’ if the
‘’ inventory Level % is below 15%. Otherwise, leave the ‘’Inventory Notice’’ blank.
Select the answer
1 correct answer
=IF(inventory level<15%), "low", ""). Select and drag to apply to other rows

Quiz

6/10
Topic 1, Clothing Orders
Case Study
Exhibit.
Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 2-2364869137


Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 1-3798899378


Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 3-2236661659
On the ‘’Inventory’ chart sheet, insert a chart title above the chart, at the top of the plot are
a. Display the percentage values as data labels to the right of each data bar.
Select the answer
1 correct answer
Click chart, press layout, click chart title and add it. Press add chart element, data labels, more
detailed options, uncheck value and check percentage.

Quiz

7/10
Topic 2, Sales Summary
Case Study


Exhibit.

Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 4-4073785023

Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 5-2775176475


Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 6-4147936768

Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 7-743367958
You are revising a sales summary report for Northwind Traders.
On the ‘’Summary’’ worksheet, in cells F4:F11, use conditional formatting to apply the Yellow Fill
with Dark Yellow Text format to cells that contain values greater than ‘’$5,000,000.’’
Select the answer
1 correct answer
Conditional formatting, highlight cell rules, greater than and then pick the color.

Quiz

8/10
Topic 2, Sales Summary
Case Study


Exhibit.

Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 4-4073785023

Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 5-2775176475


Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 6-4147936768

Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 7-743367958
On the ‘’Region 1’’ worksheet, perform a multi-level sort, Sort table data by ‘’Product’’ (A to Z) and
then by ‘’Total Sales’’ (Largest to Smallest).
Select the answer
1 correct answer
Click sort and filter. Press custom sort and add levels to sort by.

Quiz

9/10
Topic 2, Sales Summary
Case Study


Exhibit.

Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 4-4073785023

Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 5-2775176475


Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 6-4147936768

Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 7-743367958
On the ‘’Projections’ worksheet, in the ‘’Quarter2’’ column, enter a formula that multiples the value
in the Quarter 1’’ column by the ‘Q2_increase’ named range. Use the range name in the formula
instead of a cell reference or value.
Select the answer
1 correct answer

Quiz

10/10
Topic 2, Sales Summary
Case Study


Exhibit.

Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 4-4073785023

Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 5-2775176475


Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 6-4147936768

Certification Exam Excel Associate (Office 365 and Office 2019) Microsoft Microsoft-MO-200 7-743367958
On the ‘’Summary’ worksheet, in cell B15, use a function to display the highest sales amount from
the ‘’Total Sales’’ column.
Select the answer
1 correct answer
Looking for more questions?Buy now

Excel Associate (Office 365 and Office 2019) Practice test unlocks all online simulator questions

Thank you for choosing the free version of the Excel Associate (Office 365 and Office 2019) practice test! Further deepen your knowledge on Microsoft Simulator; by unlocking the full version of our Excel Associate (Office 365 and Office 2019) Simulator you will be able to take tests with over 35 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 35 questions.

BUY NOW

What to expect from our Excel Associate (Office 365 and Office 2019) practice tests and how to prepare for any exam?

The Excel Associate (Office 365 and Office 2019) Simulator Practice Tests are part of the Microsoft Database and are the best way to prepare for any Excel Associate (Office 365 and Office 2019) exam. The Excel Associate (Office 365 and Office 2019) practice tests consist of 35 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The Excel Associate (Office 365 and Office 2019) database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with Excel Associate (Office 365 and Office 2019) Simulator will also give you an idea of the time it will take to complete each section of the Excel Associate (Office 365 and Office 2019) practice test . It is important to note that the Excel Associate (Office 365 and Office 2019) Simulator does not replace the classic Excel Associate (Office 365 and Office 2019) study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the Excel Associate (Office 365 and Office 2019) exam.

BUY NOW

Excel Associate (Office 365 and Office 2019) Practice test therefore represents an excellent tool to prepare for the actual exam together with our Microsoft practice test . Our Excel Associate (Office 365 and Office 2019) Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our Excel Associate (Office 365 and Office 2019) Simulator and how our unique Excel Associate (Office 365 and Office 2019) Database made up of real questions:

Info quiz:

  • Quiz name:Excel Associate (Office 365 and Office 2019)
  • Total number of questions:35
  • Number of questions for the test:50
  • Pass score:80%

You can prepare for the Excel Associate (Office 365 and Office 2019) exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our Excel Associate (Office 365 and Office 2019) Simulator.

Use our Mobile App, available for both Android and iOS devices, with our Excel Associate (Office 365 and Office 2019) Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.

Our Mobile App contains all Excel Associate (Office 365 and Office 2019) practice tests which consist of 35 questions and also provide study material to pass the final Excel Associate (Office 365 and Office 2019) exam with guaranteed success. Our Excel Associate (Office 365 and Office 2019) database contain hundreds of questions and Microsoft Tests related to Excel Associate (Office 365 and Office 2019) Exam. This way you can practice anywhere you want, even offline without the internet.

BUY NOW