20:00

PDF|

Guide for Microsoft Office Specialist: Excel Associate (Office 2019)

Quiz Microsoft Office Specialist: Excel Associate (Office 2019)

Free Test
/ 10

Quiz

1/10
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
Option C,h,e,c,k,t,h,e are correct.
Solution below.
Select and press delete on the home tab.
TESTLET-7.
Clothing Orders
Case Study
Exhibit.
Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 2-1267279322

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 3-2781218120


Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 4-3047991113

Quiz

2/10
On the ‘’Prices’’ worksheet, apply the Title style to cell A1.
Select the answer
1 correct answer
Option C,h,e,c,k,t,h,e are correct.
Solution below.
Home Tab/ Styles group/ cell styles
TESTLET-7.
Clothing Orders
Case Study
Exhibit.
Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 2-1267279322

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 3-2781218120


Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 4-3047991113

Quiz

3/10
On the ‘’Orders’’ worksheet, filter the table data to display only the orders from ‘’Alpine SKI House.’’
Select the answer
1 correct answer
Option C,h,e,c,k,t,h,e are correct.
Solution below.
On the data tab, click filter. Display only alpine.
TESTLET-7.
Clothing Orders
Case Study
Exhibit.
Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 2-1267279322

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 3-2781218120


Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 4-3047991113

Quiz

4/10
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
Option C,h,e,c,k,t,h,e are correct.
Solution below.
=_*_
TESTLET-7.
Clothing Orders
Case Study
Exhibit.
Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 2-1267279322

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 3-2781218120


Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 4-3047991113

Quiz

5/10
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
Option C,h,e,c,k,t,h,e are correct.
Solution below.
=IF(inventory level<15%), "low", ""). Select and drag to apply to other rows
TESTLET-7.
Clothing Orders
Case Study
Exhibit.
Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 2-1267279322

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 3-2781218120


Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 4-3047991113

Quiz

6/10
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
Option C,h,e,c,k,t,h,e are correct.
Solution below.
Click chart, press layout, click chart title and add it. Press add chart element, data labels, more
detailed options, uncheck value and check percentage.
TESTLET-8.
Sales Summary
Case Study
Exhibit.
Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 5-3863780548

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 6-147576709

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 7-3215847497

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 8-3924344974

Quiz

7/10
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
Option C,h,e,c,k,t,h,e are correct.
Solution below.
Conditional formatting, highlight cell rules, greater than and then pick the color.
TESTLET-8.
Sales Summary
Case Study
Exhibit.
Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 5-3863780548

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 6-147576709

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 7-3215847497

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 8-3924344974

Quiz

8/10
On the ‘Comparison’ chart sheet, swap the data the axis.
Select the answer
1 correct answer
Option C,h,e,c,k,t,h,e are correct.
Solution below.
Right click and open axis options. Check the box that says values in reverse order.
TESTLET-9.
Class Schedule
Case Study
Exhibit.
Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 9-925988902

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 10-2458947508

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 11-1276458648

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 12-3352659077

Quiz

9/10
You are compiling class data to present to the enrollment director at the School of Fine Art.
On the ‘’Substitutes’’ worksheet beginning at cell A1, import the data from the Substitutes text file in
the Documents folder. Use the first row of the data source as headers.
Select the answer
1 correct answer
Option C,h,e,c,k,t,h,e are correct.
Solution below.
File. Open.
TESTLET-9.
Class Schedule
Case Study
Exhibit.
Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 9-925988902

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 10-2458947508

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 11-1276458648

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 12-3352659077

Quiz

10/10
On the ‘’Instructional Hours’’ worksheet, adjust the width of columns B,G to exactly 12.
Select the answer
1 correct answer
Option C,h,e,c,k,t,h,e are correct.
Solution below.
Home tab, cells group, click format. Click column width.
TESTLET-9.
Class Schedule
Case Study
Exhibit.
Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 9-925988902

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 10-2458947508

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 11-1276458648

Certification Exam Microsoft Office Specialist: Excel Associate (Office 2019) Microsoft Microsoft-MO-200 12-3352659077
Looking for more questions?Buy now

Microsoft Office Specialist: Excel Associate (Office 2019) Practice test unlocks all online simulator questions

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

BUY NOW

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

The Microsoft Office Specialist: Excel Associate (Office 2019) Simulator Practice Tests are part of the Microsoft Database and are the best way to prepare for any Microsoft Office Specialist: Excel Associate (Office 2019) exam. The Microsoft Office Specialist: Excel Associate (Office 2019) practice tests consist of 28 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The Microsoft Office Specialist: Excel Associate (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 Microsoft Office Specialist: Excel Associate (Office 2019) Simulator will also give you an idea of the time it will take to complete each section of the Microsoft Office Specialist: Excel Associate (Office 2019) practice test . It is important to note that the Microsoft Office Specialist: Excel Associate (Office 2019) Simulator does not replace the classic Microsoft Office Specialist: Excel Associate (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 Microsoft Office Specialist: Excel Associate (Office 2019) exam.

BUY NOW

Microsoft Office Specialist: Excel Associate (Office 2019) Practice test therefore represents an excellent tool to prepare for the actual exam together with our Microsoft practice test . Our Microsoft Office Specialist: Excel Associate (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 Microsoft Office Specialist: Excel Associate (Office 2019) Simulator and how our unique Microsoft Office Specialist: Excel Associate (Office 2019) Database made up of real questions:

Info quiz:

  • Quiz name:Microsoft Office Specialist: Excel Associate (Office 2019)
  • Total number of questions:28
  • Number of questions for the test:50
  • Pass score:80%

You can prepare for the Microsoft Office Specialist: Excel Associate (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 Microsoft Office Specialist: Excel Associate (Office 2019) Simulator.

Use our Mobile App, available for both Android and iOS devices, with our Microsoft Office Specialist: Excel Associate (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 Microsoft Office Specialist: Excel Associate (Office 2019) practice tests which consist of 28 questions and also provide study material to pass the final Microsoft Office Specialist: Excel Associate (Office 2019) exam with guaranteed success. Our Microsoft Office Specialist: Excel Associate (Office 2019) database contain hundreds of questions and Microsoft Tests related to Microsoft Office Specialist: Excel Associate (Office 2019) Exam. This way you can practice anywhere you want, even offline without the internet.

BUY NOW