Microsoft 77-727 - Excel 2016: Core Data Analysis, Manipulation, and Presentation Exam
Page: 1 / 1
Total 4 questions
Question #1 (Topic: Topic 1)
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.
[Microsoft-77-727-1.0/xmlfile-3_1.jpg]
[Microsoft-77-727-1.0/xmlfile-4_1.jpg]
[Microsoft-77-727-1.0/xmlfile-5_1.jpg]
[Microsoft-77-727-1.0/xmlfile-6_1.jpg]
[Microsoft-77-727-1.0/xmlfile-7_1.jpg]
[Microsoft-77-727-1.0/xmlfile-8_1.jpg]
[Microsoft-77-727-1.0/xmlfile-9_1.png]
[Microsoft-77-727-1.0/xmlfile-10_1.jpg]
[Microsoft-77-727-1.0/xmlfile-11_1.jpg]
[Microsoft-77-727-1.0/xmlfile-12_1.png]
[Microsoft-77-727-1.0/xmlfile-13_1.jpg]
[Microsoft-77-727-1.0/xmlfile-14_1.jpg]
[Microsoft-77-727-1.0/xmlfile-15_1.jpg]
[Microsoft-77-727-1.0/xmlfile-16_1.jpg]
[Microsoft-77-727-1.0/xmlfile-17_1.jpg]
[Microsoft-77-727-1.0/xmlfile-18_1.jpg]
[Microsoft-77-727-1.0/xmlfile-19_1.jpg]
[Microsoft-77-727-1.0/xmlfile-20_1.jpg]
[Microsoft-77-727-1.0/xmlfile-21_1.jpg]
[Microsoft-77-727-1.0/xmlfile-22_1.jpg]
[Microsoft-77-727-1.0/xmlfile-23_1.jpg]
[Microsoft-77-727-1.0/xmlfile-24_1.jpg]
[Microsoft-77-727-1.0/xmlfile-25_1.jpg]
[Microsoft-77-727-1.0/xmlfile-26_1.jpg]
[Microsoft-77-727-1.0/xmlfile-27_1.jpg]
[Microsoft-77-727-1.0/xmlfile-28_1.jpg]
[Microsoft-77-727-1.0/xmlfile-29_1.jpg]
[Microsoft-77-727-1.0/xmlfile-30_1.jpg]
[Microsoft-77-727-1.0/xmlfile-31_1.jpg]
[Microsoft-77-727-1.0/xmlfile-32_1.jpg]
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.
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.
[Microsoft-77-727-1.0/xmlfile-3_1.jpg]
[Microsoft-77-727-1.0/xmlfile-4_1.jpg]
[Microsoft-77-727-1.0/xmlfile-5_1.jpg]
[Microsoft-77-727-1.0/xmlfile-6_1.jpg]
[Microsoft-77-727-1.0/xmlfile-7_1.jpg]
[Microsoft-77-727-1.0/xmlfile-8_1.jpg]
[Microsoft-77-727-1.0/xmlfile-9_1.png]
[Microsoft-77-727-1.0/xmlfile-10_1.jpg]
[Microsoft-77-727-1.0/xmlfile-11_1.jpg]
[Microsoft-77-727-1.0/xmlfile-12_1.png]
[Microsoft-77-727-1.0/xmlfile-13_1.jpg]
[Microsoft-77-727-1.0/xmlfile-14_1.jpg]
[Microsoft-77-727-1.0/xmlfile-15_1.jpg]
[Microsoft-77-727-1.0/xmlfile-16_1.jpg]
[Microsoft-77-727-1.0/xmlfile-17_1.jpg]
[Microsoft-77-727-1.0/xmlfile-18_1.jpg]
[Microsoft-77-727-1.0/xmlfile-19_1.jpg]
[Microsoft-77-727-1.0/xmlfile-20_1.jpg]
[Microsoft-77-727-1.0/xmlfile-21_1.jpg]
[Microsoft-77-727-1.0/xmlfile-22_1.jpg]
[Microsoft-77-727-1.0/xmlfile-23_1.jpg]
[Microsoft-77-727-1.0/xmlfile-24_1.jpg]
[Microsoft-77-727-1.0/xmlfile-25_1.jpg]
[Microsoft-77-727-1.0/xmlfile-26_1.jpg]
[Microsoft-77-727-1.0/xmlfile-27_1.jpg]
[Microsoft-77-727-1.0/xmlfile-28_1.jpg]
[Microsoft-77-727-1.0/xmlfile-29_1.jpg]
[Microsoft-77-727-1.0/xmlfile-30_1.jpg]
[Microsoft-77-727-1.0/xmlfile-31_1.jpg]
[Microsoft-77-727-1.0/xmlfile-32_1.jpg]
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.
Answer: See explanation below.
Question #2 (Topic: Topic 1)
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.
[Microsoft-77-727-1.0/xmlfile-34_1.jpg]
[Microsoft-77-727-1.0/xmlfile-35_1.jpg]
[Microsoft-77-727-1.0/xmlfile-36_1.jpg]
[Microsoft-77-727-1.0/xmlfile-37_1.jpg]
[Microsoft-77-727-1.0/xmlfile-38_1.jpg]
[Microsoft-77-727-1.0/xmlfile-39_1.jpg]
[Microsoft-77-727-1.0/xmlfile-40_1.png]
[Microsoft-77-727-1.0/xmlfile-41_1.jpg]
[Microsoft-77-727-1.0/xmlfile-42_1.jpg]
[Microsoft-77-727-1.0/xmlfile-43_1.png]
[Microsoft-77-727-1.0/xmlfile-44_1.jpg]
[Microsoft-77-727-1.0/xmlfile-45_1.jpg]
[Microsoft-77-727-1.0/xmlfile-46_1.jpg]
[Microsoft-77-727-1.0/xmlfile-47_1.jpg]
[Microsoft-77-727-1.0/xmlfile-48_1.jpg]
[Microsoft-77-727-1.0/xmlfile-49_1.jpg]
[Microsoft-77-727-1.0/xmlfile-50_1.jpg]
[Microsoft-77-727-1.0/xmlfile-51_1.jpg]
[Microsoft-77-727-1.0/xmlfile-52_1.jpg]
[Microsoft-77-727-1.0/xmlfile-53_1.jpg]
[Microsoft-77-727-1.0/xmlfile-54_1.jpg]
[Microsoft-77-727-1.0/xmlfile-55_1.jpg]
[Microsoft-77-727-1.0/xmlfile-56_1.jpg]
[Microsoft-77-727-1.0/xmlfile-57_1.jpg]
[Microsoft-77-727-1.0/xmlfile-58_1.jpg]
[Microsoft-77-727-1.0/xmlfile-59_1.jpg]
[Microsoft-77-727-1.0/xmlfile-60_1.jpg]
[Microsoft-77-727-1.0/xmlfile-61_1.jpg]
[Microsoft-77-727-1.0/xmlfile-62_1.jpg]
[Microsoft-77-727-1.0/xmlfile-63_1.jpg]
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.
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.
[Microsoft-77-727-1.0/xmlfile-34_1.jpg]
[Microsoft-77-727-1.0/xmlfile-35_1.jpg]
[Microsoft-77-727-1.0/xmlfile-36_1.jpg]
[Microsoft-77-727-1.0/xmlfile-37_1.jpg]
[Microsoft-77-727-1.0/xmlfile-38_1.jpg]
[Microsoft-77-727-1.0/xmlfile-39_1.jpg]
[Microsoft-77-727-1.0/xmlfile-40_1.png]
[Microsoft-77-727-1.0/xmlfile-41_1.jpg]
[Microsoft-77-727-1.0/xmlfile-42_1.jpg]
[Microsoft-77-727-1.0/xmlfile-43_1.png]
[Microsoft-77-727-1.0/xmlfile-44_1.jpg]
[Microsoft-77-727-1.0/xmlfile-45_1.jpg]
[Microsoft-77-727-1.0/xmlfile-46_1.jpg]
[Microsoft-77-727-1.0/xmlfile-47_1.jpg]
[Microsoft-77-727-1.0/xmlfile-48_1.jpg]
[Microsoft-77-727-1.0/xmlfile-49_1.jpg]
[Microsoft-77-727-1.0/xmlfile-50_1.jpg]
[Microsoft-77-727-1.0/xmlfile-51_1.jpg]
[Microsoft-77-727-1.0/xmlfile-52_1.jpg]
[Microsoft-77-727-1.0/xmlfile-53_1.jpg]
[Microsoft-77-727-1.0/xmlfile-54_1.jpg]
[Microsoft-77-727-1.0/xmlfile-55_1.jpg]
[Microsoft-77-727-1.0/xmlfile-56_1.jpg]
[Microsoft-77-727-1.0/xmlfile-57_1.jpg]
[Microsoft-77-727-1.0/xmlfile-58_1.jpg]
[Microsoft-77-727-1.0/xmlfile-59_1.jpg]
[Microsoft-77-727-1.0/xmlfile-60_1.jpg]
[Microsoft-77-727-1.0/xmlfile-61_1.jpg]
[Microsoft-77-727-1.0/xmlfile-62_1.jpg]
[Microsoft-77-727-1.0/xmlfile-63_1.jpg]
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.
Answer: See explanation below.
Question #3 (Topic: Topic 1)
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.
[Microsoft-77-727-1.0/xmlfile-65_1.jpg]
[Microsoft-77-727-1.0/xmlfile-66_1.jpg]
[Microsoft-77-727-1.0/xmlfile-67_1.jpg]
[Microsoft-77-727-1.0/xmlfile-68_1.jpg]
[Microsoft-77-727-1.0/xmlfile-69_1.jpg]
[Microsoft-77-727-1.0/xmlfile-70_1.jpg]
[Microsoft-77-727-1.0/xmlfile-71_1.png]
[Microsoft-77-727-1.0/xmlfile-72_1.jpg]
[Microsoft-77-727-1.0/xmlfile-73_1.jpg]
[Microsoft-77-727-1.0/xmlfile-74_1.png]
[Microsoft-77-727-1.0/xmlfile-75_1.jpg]
[Microsoft-77-727-1.0/xmlfile-76_1.jpg]
[Microsoft-77-727-1.0/xmlfile-77_1.jpg]
[Microsoft-77-727-1.0/xmlfile-78_1.jpg]
[Microsoft-77-727-1.0/xmlfile-79_1.jpg]
[Microsoft-77-727-1.0/xmlfile-80_1.jpg]
[Microsoft-77-727-1.0/xmlfile-81_1.jpg]
[Microsoft-77-727-1.0/xmlfile-82_1.jpg]
[Microsoft-77-727-1.0/xmlfile-83_1.jpg]
[Microsoft-77-727-1.0/xmlfile-84_1.jpg]
[Microsoft-77-727-1.0/xmlfile-85_1.jpg]
[Microsoft-77-727-1.0/xmlfile-86_1.jpg]
[Microsoft-77-727-1.0/xmlfile-87_1.jpg]
[Microsoft-77-727-1.0/xmlfile-88_1.jpg]
[Microsoft-77-727-1.0/xmlfile-89_1.jpg]
[Microsoft-77-727-1.0/xmlfile-90_1.jpg]
[Microsoft-77-727-1.0/xmlfile-91_1.jpg]
[Microsoft-77-727-1.0/xmlfile-92_1.jpg]
[Microsoft-77-727-1.0/xmlfile-93_1.jpg]
[Microsoft-77-727-1.0/xmlfile-94_1.jpg]
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.
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.
[Microsoft-77-727-1.0/xmlfile-65_1.jpg]
[Microsoft-77-727-1.0/xmlfile-66_1.jpg]
[Microsoft-77-727-1.0/xmlfile-67_1.jpg]
[Microsoft-77-727-1.0/xmlfile-68_1.jpg]
[Microsoft-77-727-1.0/xmlfile-69_1.jpg]
[Microsoft-77-727-1.0/xmlfile-70_1.jpg]
[Microsoft-77-727-1.0/xmlfile-71_1.png]
[Microsoft-77-727-1.0/xmlfile-72_1.jpg]
[Microsoft-77-727-1.0/xmlfile-73_1.jpg]
[Microsoft-77-727-1.0/xmlfile-74_1.png]
[Microsoft-77-727-1.0/xmlfile-75_1.jpg]
[Microsoft-77-727-1.0/xmlfile-76_1.jpg]
[Microsoft-77-727-1.0/xmlfile-77_1.jpg]
[Microsoft-77-727-1.0/xmlfile-78_1.jpg]
[Microsoft-77-727-1.0/xmlfile-79_1.jpg]
[Microsoft-77-727-1.0/xmlfile-80_1.jpg]
[Microsoft-77-727-1.0/xmlfile-81_1.jpg]
[Microsoft-77-727-1.0/xmlfile-82_1.jpg]
[Microsoft-77-727-1.0/xmlfile-83_1.jpg]
[Microsoft-77-727-1.0/xmlfile-84_1.jpg]
[Microsoft-77-727-1.0/xmlfile-85_1.jpg]
[Microsoft-77-727-1.0/xmlfile-86_1.jpg]
[Microsoft-77-727-1.0/xmlfile-87_1.jpg]
[Microsoft-77-727-1.0/xmlfile-88_1.jpg]
[Microsoft-77-727-1.0/xmlfile-89_1.jpg]
[Microsoft-77-727-1.0/xmlfile-90_1.jpg]
[Microsoft-77-727-1.0/xmlfile-91_1.jpg]
[Microsoft-77-727-1.0/xmlfile-92_1.jpg]
[Microsoft-77-727-1.0/xmlfile-93_1.jpg]
[Microsoft-77-727-1.0/xmlfile-94_1.jpg]
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.
Answer: See explanation below.
Question #4 (Topic: )
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.
[Microsoft-77-727-1.0/xmlfile-96_1.jpg]
[Microsoft-77-727-1.0/xmlfile-97_1.jpg]
[Microsoft-77-727-1.0/xmlfile-98_1.jpg]
[Microsoft-77-727-1.0/xmlfile-99_1.jpg]
[Microsoft-77-727-1.0/xmlfile-100_1.jpg]
[Microsoft-77-727-1.0/xmlfile-101_1.jpg]
[Microsoft-77-727-1.0/xmlfile-102_1.png]
[Microsoft-77-727-1.0/xmlfile-103_1.jpg]
[Microsoft-77-727-1.0/xmlfile-104_1.jpg]
[Microsoft-77-727-1.0/xmlfile-105_1.png]
[Microsoft-77-727-1.0/xmlfile-106_1.jpg]
[Microsoft-77-727-1.0/xmlfile-107_1.jpg]
[Microsoft-77-727-1.0/xmlfile-108_1.jpg]
[Microsoft-77-727-1.0/xmlfile-109_1.jpg]
[Microsoft-77-727-1.0/xmlfile-110_1.jpg]
[Microsoft-77-727-1.0/xmlfile-111_1.jpg]
[Microsoft-77-727-1.0/xmlfile-112_1.jpg]
[Microsoft-77-727-1.0/xmlfile-113_1.jpg]
[Microsoft-77-727-1.0/xmlfile-114_1.jpg]
[Microsoft-77-727-1.0/xmlfile-115_1.jpg]
[Microsoft-77-727-1.0/xmlfile-116_1.jpg]
[Microsoft-77-727-1.0/xmlfile-117_1.jpg]
[Microsoft-77-727-1.0/xmlfile-118_1.jpg]
[Microsoft-77-727-1.0/xmlfile-119_1.jpg]
[Microsoft-77-727-1.0/xmlfile-120_1.jpg]
[Microsoft-77-727-1.0/xmlfile-121_1.jpg]
[Microsoft-77-727-1.0/xmlfile-122_1.jpg]
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.
[Microsoft-77-727-1.0/xmlfile-96_1.jpg]
[Microsoft-77-727-1.0/xmlfile-97_1.jpg]
[Microsoft-77-727-1.0/xmlfile-98_1.jpg]
[Microsoft-77-727-1.0/xmlfile-99_1.jpg]
[Microsoft-77-727-1.0/xmlfile-100_1.jpg]
[Microsoft-77-727-1.0/xmlfile-101_1.jpg]
[Microsoft-77-727-1.0/xmlfile-102_1.png]
[Microsoft-77-727-1.0/xmlfile-103_1.jpg]
[Microsoft-77-727-1.0/xmlfile-104_1.jpg]
[Microsoft-77-727-1.0/xmlfile-105_1.png]
[Microsoft-77-727-1.0/xmlfile-106_1.jpg]
[Microsoft-77-727-1.0/xmlfile-107_1.jpg]
[Microsoft-77-727-1.0/xmlfile-108_1.jpg]
[Microsoft-77-727-1.0/xmlfile-109_1.jpg]
[Microsoft-77-727-1.0/xmlfile-110_1.jpg]
[Microsoft-77-727-1.0/xmlfile-111_1.jpg]
[Microsoft-77-727-1.0/xmlfile-112_1.jpg]
[Microsoft-77-727-1.0/xmlfile-113_1.jpg]
[Microsoft-77-727-1.0/xmlfile-114_1.jpg]
[Microsoft-77-727-1.0/xmlfile-115_1.jpg]
[Microsoft-77-727-1.0/xmlfile-116_1.jpg]
[Microsoft-77-727-1.0/xmlfile-117_1.jpg]
[Microsoft-77-727-1.0/xmlfile-118_1.jpg]
[Microsoft-77-727-1.0/xmlfile-119_1.jpg]
[Microsoft-77-727-1.0/xmlfile-120_1.jpg]
[Microsoft-77-727-1.0/xmlfile-121_1.jpg]
[Microsoft-77-727-1.0/xmlfile-122_1.jpg]
Answer: