Free MO-210 – Microsoft Certification Practice Test Question

Reference / correct answer:

1. On the “Customers” worksheet, click the Select All button OR press Ctrl+A.

2. Click the arrow next to Conditional Formatting from the Home tab in the Styles group, then select New Rule.

3. Click Select a Rule Type in the New Formatting Rule dialog box, then select Use a formula to determine which cells to format.

4. In the Format values where this formula is true box, enter =MOD(ROW(),2)=0.

5. Click on Format.

6. Click the Fill tab from the Format Cells dialog box.

7. Select the desired shade background and then click OK, you are able to view how the background would look in the Preview window in the New Formatting Rule dialog box.

8. Once satisfied, apply the formatting to the cells by clicking OK.

References:

https://support.office.com/en-us/article/Apply-shading-to-alternate-rows-in-a-worksheetA443B0F5-2025-42F6-9099-5DE09C05E880

Reference / correct answer:

1. Select a cell in the “CountryOrRegion” field on the “Customers” worksheet.

2. Select Sort from the Sort & Filter group in the Data tab.

3. In the Sort dialog box, under Column in the Sort by box, Select the “CountryOrRegion” field.

4. Under the Sort On option, select the type of sort desired, in this case Values, to sort by text.

5. Under Order, select Custom List, then set it for customers in the United States to appear first, then the customers in Canada.

6. Then to add another column to sort by, click Add Level.

7. In the Sort dialog box, under Column in the Sort by box, Select the “StateOrProvince” field.

8. Under the Sort On option, select Values.

9. Under Order, select A to Z.

10. Add a final column by clicking Add Level.

11. In the Sort dialog box, under Column in the Sort by box, Select the “PostalCode” field.

12. Under Sort On, select Values.

13. Under Order, select Smallest to Largest.

14. Click OK.

References: https://support.office.com/en-us/article/sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae2e545c4a4654

Reference / correct answer:

1. Select cell N2 on the “Customers” worksheet, which is where you want the Excel function toreturn the result to.

2. In the Address bar, type the average function syntax; =AVERAGE(K1:K101).

References: https://support.office.com/en-us/article/AVERAGE-function-047BAC88-D466-426C-A32B8F33EB960CF6

Reference / correct answer:

1. Select the cells in the “Weight” column which you want to apply the number formatting to.

2. Click Increase Decimal till the desired decimal places of three is selected, this is found on the Home tab.

OR

1. Select the cells in the “Weight” column which you want to apply the number formatting to.

2. On the Home tab, in the Number group, click the arrow next to the list of number formats, then select More Number Formats.

3. Select the type of data you have in the Category list, in this case it would be Scientific.

4. Enter the desired amount of decimal places you want to display in the Decimal places box, in this case it would be three.

References: https://support.office.com/en-us/article/Round-a-number-to-the-decimal-places-I-want-49B936F96904-425D-AA98-02FFB7F9A17B

Reference / correct answer:

1. Select the cells in the “OrderTotal” column which is the data range you are required to highlightthe cells which are above-average.

2. Click Conditional Formatting from the Home tab, then select Top/Bottom Rules, then select the Above Average option.

3. A popped up dialog box will then appear, select the Green Fill with Dark Green Text option asdesired.

4. Click OK.

References: https://www.extendoffice.com/documents/excel/2195-excel-highlight-above-average.html

Reference / correct answer:

1. Select the cell J2 where you want the highest “OrderTotal” value to be.

2. Type in the formula: =MAX(G1:G550).

References:

https://support.office.com/en-us/article/calculate-the-smallest-or-largest-number-in-a-range45fe249f-96c3-443b-8e9f-87f16c48462c

Reference / correct answer:

1. Select the cells in the “CustomerID” column which you want to have checked for duplicates.

2. Select Remove Duplicates from the Data tab.

3. Select the “CustomerID” column which you want to have checked under the Columns options.

4. Click OK.

References: https://support.office.com/en-us/article/Find-and-remove-duplicates-00E35BEA-B46A-4D5DB28E-66A552DC138D

Reference / correct answer:

1. Select cell A5 of the “$5,000 Donors” worksheet where you want the source file to be importedto.

2. Click on File, then select Open.

3. Select Text Files from the Open dialog box.

4. Locate the contributors.txt file in the Documents folder, then double-click it.

5. Click Finish to complete the operation.

References:

https://support.office.com/en-us/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce937b-339e391393ba

Reference / correct answer:

1. Click Find & Select from the Home tab then click on Go To.

OR

1. Press Ctrl+G on the keyboard.

2. Double-click the name range you want, in this case “Oregon”.

3. Delete the contents in the selected cells by pressing Delete on your keyboard.

References: https://support.office.com/en-us/article/Find-named-ranges-14513DF5-0D79-4CD5-9A03968905B244E6

Reference / correct answer:

1. Select the plus icon at the bottom of the screen.

OR

1. Select Insert from the Home tab, then click Insert Sheet.

References: https://support.office.com/en-us/article/Insert-or-delete-a-worksheet-19d3d21e-a3b3-4e13-a422d1f43f1faaf2