Quiz about Certification Exam, Microsoft, Excel Associate (Office 365 and Office 2019)

Question 1

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.

Accepted 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$ Certification Exam Microsoft Excel Associate (Office 365 and Office 2019) Microsoft-MO-200 3-2781218120

Certification Exam Microsoft Excel Associate (Office 365 and Office 2019) Microsoft-MO-200 3-2781218120

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

Question 2

On the ‘’Prices’’ worksheet, apply the Title style to cell A1.

Accepted 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$ Certification Exam Microsoft Excel Associate (Office 365 and Office 2019) Microsoft-MO-200 3-2781218120

Question 3

On the ‘’Orders’’ worksheet, filter the table data to display only the orders from ‘’Alpine SKI House.’’

Accepted 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$ Certification Exam Microsoft Excel Associate (Office 365 and Office 2019) Microsoft-MO-200 3-2781218120

Question 4

On the ‘’Prices’’ worksheet, in the ‘’Tax column, enter a formula that multiples the value in the ‘’Unit

Price’’ column by cell L2.

Accepted Answer

Option C,h,e,c,k,t,h,e are correct. Solution below. =_*_ TESTLET-7. Clothing Orders Case Study Exhibit. $\"Certification$ Certification Exam Microsoft Excel Associate (Office 365 and Office 2019) Microsoft-MO-200 3-2781218120

Question 5

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.

Accepted 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 Excel Associate (Office 365 and Office 2019) Microsoft-MO-200 2-1267279322

Certification Exam Microsoft Excel Associate (Office 365 and Office 2019) Microsoft-MO-200 2-1267279322

Question 6

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.

Accepted 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$ Certification Exam Microsoft Excel Associate (Office 365 and Office 2019) Microsoft-MO-200 6-147576709

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

Certification Exam Microsoft Excel Associate (Office 365 and Office 2019) Microsoft-MO-200 7-3215847497

Certification Exam Microsoft Excel Associate (Office 365 and Office 2019) Microsoft-MO-200 8-3924344974

Question 7

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

Accepted 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$ Certification Exam Microsoft Excel Associate (Office 365 and Office 2019) Microsoft-MO-200 6-147576709

Question 8

On the ‘Comparison’ chart sheet, swap the data the axis.

Accepted 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$ Certification Exam Microsoft Excel Associate (Office 365 and Office 2019) Microsoft-MO-200 10-2458947508

Certification Exam Microsoft Excel Associate (Office 365 and Office 2019) Microsoft-MO-200 10-2458947508

Certification Exam Microsoft Excel Associate (Office 365 and Office 2019) Microsoft-MO-200 11-1276458648

Certification Exam Microsoft Excel Associate (Office 365 and Office 2019) Microsoft-MO-200 12-3352659077

Question 9

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.

Accepted Answer

Option C,h,e,c,k,t,h,e are correct. Solution below. File. Open. TESTLET-9. Class Schedule Case Study Exhibit. $\"Certification$ Certification Exam Microsoft Excel Associate (Office 365 and Office 2019) Microsoft-MO-200 10-2458947508

Question 10

On the ‘’Instructional Hours’’ worksheet, adjust the width of columns B,G to exactly 12.

Accepted 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$ Certification Exam Microsoft Excel Associate (Office 365 and Office 2019) Microsoft-MO-200 10-2458947508

Quiz Excel Associate (Office 365 and Office 2019)

Free Test - Simulator Excel Associate (Office 365 and Office 2019)

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

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