20:00

PDF|

Guide for Excel 2016: Core Data Analysis, Manipulation, and Presentation

Quiz Excel 2016: Core Data Analysis, Manipulation, and Presentation

Free Test
/ 10

Quiz

1/10
SIMULATION
Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are
evaluating customer data and order data.
Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 1-2500754618


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 2-3353728890


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 3-1435987842


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 4-3919849094


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 5-1218925433


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 6-474562080


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 7-3729599580


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 8-3543763578


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 9-1459716132


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 10-796299591


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 11-575645247


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 12-2242411651


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 13-733003305


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 14-3052359275


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 15-3549980204


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 16-2868220788


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 17-2470603325


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 18-1891052605


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 19-1712959735


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 20-525961076


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 21-1882424917


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 22-894860202


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 23-3748591974


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 24-2760085682


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 25-4143268086


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 26-909148095


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 27-2013949995


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 28-1688659726


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 29-1253339704


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 30-4019045033

On the “Customers” worksheet, format the table so that every other row is shaded. Use a technique
that automatically updates the formatting if you insert a new row.
Select the answer
1 correct answer
A.
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.
B.
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. Click the Fill tab from the Format Cells dialog box. 5. 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. 6. Once satisfied, apply the formatting to the cells by clicking OK.

Quiz

2/10
SIMULATION
Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are
evaluating customer data and order data.
Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 31-2619961601


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 32-3353728890


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 33-1435987842


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 34-3919849094


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 35-1218925433


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 36-474562080


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 37-3729599580


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 38-3543763578


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 39-1459716132


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 40-796299591


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 41-575645247


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 42-2242411651


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 43-733003305


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 44-3052359275


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 45-3549980204


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 46-2868220788


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 47-2470603325


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 48-1891052605


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 49-1712959735


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 50-525961076


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 51-1882424917


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 52-894860202


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 53-3748591974


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 54-2760085682


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 55-4143268086


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 56-909148095


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 57-2013949995


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 58-1688659726


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 59-1253339704


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 60-4019045033

On the “Customers” worksheet, sort the table to order the records by the “CountryOrRegion” field,
with customers in the United States first and customers in Canada second.
Then sort the customers in each country alphabetically (from A to Z) by the “StateOrProvince” field.
Finally, sort the customers in each state or province in ascending order by the ‘PostalCode” field.
Select the answer
1 correct answer
A.
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. 5. In the Sort dialog box, under Column in the Sort by box, Select the “PostalCode” field. 6. Under Sort On, select Values. 7. Under Order, select Smallest to Largest. 8. Click OK.
B.
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.

Quiz

3/10
SIMULATION
Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are
evaluating customer data and order data.
Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 61-2619961601


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 62-3353728890


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 63-1435987842


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 64-3919849094


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 65-1218925433


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 66-474562080


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 67-3729599580


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 68-3543763578


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 69-1459716132


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 70-796299591


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 71-575645247


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 72-2242411651


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 73-733003305


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 74-3052359275


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 75-3549980204


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 76-2868220788


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 77-2470603325


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 78-1891052605


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 79-1712959735


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 80-525961076


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 81-1882424917


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 82-894860202


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 83-3748591974


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 84-2760085682


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 85-4143268086


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 86-909148095


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 87-2013949995


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 88-1688659726


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 89-1253339704


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 90-4019045033

On the “Customers” worksheet, enter a formula in cell N2 that uses an Excel function to return the
average age of the customers based on the values in the “CurrentAge” column.
Select the answer
1 correct answer
A.
1. Select cell N2 on the “Customers” worksheet, which is where you want the Excel function to return the result to. 2. In the Address bar, type the average function syntax; =AVERAGE(K1:K101).
B.
1. Select cell N2 on the “Customers” worksheet, which is where you want the Excel function to return the result to. 2. In the Address bar, type the average function syntax; =AVERTGE(K1:K181).

Quiz

4/10
SIMULATION
Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are
evaluating customer data and order data.
Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 91-2500754618


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 92-3353728890


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 93-1435987842


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 94-3919849094


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 95-1218925433


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 96-474562080


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 97-3729599580


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 98-3543763578


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 99-1459716132


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 100-796299591


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 101-575645247


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 102-2242411651


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 103-733003305


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 104-3052359275


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 105-3549980204


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 106-2868220788


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 107-2470603325


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 108-1891052605


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 109-1712959735


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 110-525961076


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 111-1882424917


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 112-894860202


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 113-3748591974


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 114-2760085682


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 115-4143268086


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 116-909148095


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 117-2013949995


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 118-1688659726


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 119-1253339704


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 120-4019045033

On the “Products” worksheet, apply a number format to display the numbers in the “Weight” column
to three decimal places.
Select the answer
1 correct answer
A.
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.
B.
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.

Quiz

5/10
SIMULATION
Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are
evaluating customer data and order data.
Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 121-2619961601


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 122-3353728890


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 123-1435987842


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 124-3919849094


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 125-1218925433


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 126-474562080


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 127-3729599580


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 128-3543763578


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 129-1459716132


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 130-796299591


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 131-575645247


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 132-2242411651


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 133-733003305


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 134-3052359275


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 135-3549980204


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 136-2868220788


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 137-2470603325


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 138-1891052605


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 139-1712959735


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 140-525961076


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 141-1882424917


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 142-894860202


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 143-3748591974


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 144-2760085682


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 145-4143268086


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 146-909148095


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 147-2013949995


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 148-1688659726


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 149-1253339704


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 150-4019045033

On the “Orders” worksheet, use an automatic formatting method to format cells in the “OrderTotal”
column that contain above-average values by applying Green Fill with Dark Green Text. Use a
technique that automatically updates the formatting if the column values change.
Select the answer
1 correct answer
A.
1. Select the cells in the “OrderTotal” column which is the data range you are required to highlight the 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 as desired. 4. Click OK.
B.
1. Select the cells in the “OrderTotal” column which is the data range you are required to highlight the cells which are above-average. 2. Click Conditional Formatting from the Home tab, then select Top/Bottom Rules, then select the Above Average option. 4. Click OK.

Quiz

6/10
SIMULATION
Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are
evaluating customer data and order data.
Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 151-2619961601


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 152-3353728890


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 153-1435987842


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 154-3919849094


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 155-1218925433


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 156-474562080


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 157-3729599580


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 158-3543763578


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 159-1459716132


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 160-796299591


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 161-575645247


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 162-2242411651


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 163-733003305


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 164-3052359275


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 165-3549980204


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 166-2868220788


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 167-2470603325


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 168-1891052605


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 169-1712959735


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 170-525961076


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 171-1882424917


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 172-894860202


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 173-3748591974


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 174-2760085682


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 175-4143268086


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 176-909148095


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 177-2013949995


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 178-1688659726


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 179-1253339704


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 180-4019045033

On the “Orders” worksheet, enter a formula in cell J2 that uses an Excel function to return the
“OrderTotal” value of the individual order that has the highest “OrderTotal” value.
Select the answer
1 correct answer
A.
1. Select the cell J2 where you want the highest “OrderTotal” value to be. 2. Type in the formula: =MAX(G1:G550).
B.
1. Select the cell J2 where you want the highest “OrderTotal” value to be. 2. Type in the formula: =MAX(G1:G660).

Quiz

7/10
SIMULATION
Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are
evaluating customer data and order data.
Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 181-4052284805


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 182-3353728890


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 183-1435987842


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 184-3919849094


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 185-1218925433


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 186-474562080


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 187-3729599580


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 188-3543763578


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 189-1459716132


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 190-796299591


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 191-575645247


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 192-2242411651


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 193-733003305


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 194-3052359275


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 195-3549980204


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 196-2868220788


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 197-2470603325


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 198-1891052605


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 199-1712959735


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 200-525961076


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 201-1882424917


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 202-894860202


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 203-3748591974


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 204-2760085682


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 205-4143268086


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 206-909148095


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 207-2013949995


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 208-1688659726


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 209-1253339704


Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 210-4019045033

On the “Customers by Order” worksheet, use an Excel data tool to remove all records with duplicate
“CustomerID” values from the table. Do not remove any other records.
Select the answer
1 correct answer
A.
1. Select the cells in the “CustomerID” column which you want to have checked for duplicates. 2. Select Remove Duplicates from the Data tab. 4. Click OK.
B.
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.

Quiz

8/10
SIMULATION
Project 2 of 7: Donor List
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating


a workbook containing lists of donors.

Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 211-1886401222

Beginning at cell A5 of the “$5,000 Donors” worksheet, import the data from the tab-delimited
source file, contributors.txt, located in the Documents folder. (Accept all defaults.)
Select the answer
1 correct answer
A.
1. Select cell A5 of the “$5,000 Donors” worksheet where you want the source file to be imported to. 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.
B.
1. Select cell A5 of the “$8,000 Donors” worksheet where you want the source file to be imported to. 2. Click on File, then select Open. 3. Select Text Files from the Open dialog box. 4. Click Finish to complete the operation.

Quiz

9/10
SIMULATION
Project 2 of 7: Donor List
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating


a workbook containing lists of donors.

Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 212-626009245

Navigate to the range named “Oregon”, and remove the contents of the selected cells.
Select the answer
1 correct answer
A.
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.
B.
1. Click Find & Select from the Home tab then click on Go To. OR 1. Press Ctrl+G on the keyboard. 2. Delete the contents in the selected cells by pressing Delete on your keyboard.

Quiz

10/10
SIMULATION
Project 2 of 7: Donor List
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating


a workbook containing lists of donors.

Certification Exam Excel 2016: Core Data Analysis, Manipulation, and Presentation Microsoft Microsoft-77-727 213-279471908

Add a new worksheet named “$1,000 Donors” to the workbook.
Select the answer
1 correct answer
A.
1. Select the plus icon at the bottom of the screen. OR 1. Select Insert from the tab, then click Insert Sheet.
B.
1. Select the plus icon at the bottom of the screen. OR 1. Select Insert from the Home tab, then click Insert Sheet.
Looking for more questions?Buy now

Excel 2016: Core Data Analysis, Manipulation, and Presentation Practice test unlocks all online simulator questions

Thank you for choosing the free version of the Excel 2016: Core Data Analysis, Manipulation, and Presentation practice test! Further deepen your knowledge on Microsoft Simulator; by unlocking the full version of our Excel 2016: Core Data Analysis, Manipulation, and Presentation 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 2016: Core Data Analysis, Manipulation, and Presentation practice tests and how to prepare for any exam?

The Excel 2016: Core Data Analysis, Manipulation, and Presentation Simulator Practice Tests are part of the Microsoft Database and are the best way to prepare for any Excel 2016: Core Data Analysis, Manipulation, and Presentation exam. The Excel 2016: Core Data Analysis, Manipulation, and Presentation 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 2016: Core Data Analysis, Manipulation, and Presentation database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with Excel 2016: Core Data Analysis, Manipulation, and Presentation Simulator will also give you an idea of the time it will take to complete each section of the Excel 2016: Core Data Analysis, Manipulation, and Presentation practice test . It is important to note that the Excel 2016: Core Data Analysis, Manipulation, and Presentation Simulator does not replace the classic Excel 2016: Core Data Analysis, Manipulation, and Presentation 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 2016: Core Data Analysis, Manipulation, and Presentation exam.

BUY NOW

Excel 2016: Core Data Analysis, Manipulation, and Presentation Practice test therefore represents an excellent tool to prepare for the actual exam together with our Microsoft practice test . Our Excel 2016: Core Data Analysis, Manipulation, and Presentation 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 2016: Core Data Analysis, Manipulation, and Presentation Simulator and how our unique Excel 2016: Core Data Analysis, Manipulation, and Presentation Database made up of real questions:

Info quiz:

  • Quiz name:Excel 2016: Core Data Analysis, Manipulation, and Presentation
  • Total number of questions:35
  • Number of questions for the test:50
  • Pass score:80%

You can prepare for the Excel 2016: Core Data Analysis, Manipulation, and Presentation 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 2016: Core Data Analysis, Manipulation, and Presentation Simulator.

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

BUY NOW