77-727 Excel 2016: Core Data Analysis - Manipulation - Presentation

Loading demo links...

Showing 1–3 of 5 questions

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

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.

Answer is in the explanation below.

Question 2

SIMULATION

Project 4 of 7: Car Inventory

Overview

You manage the office of a used car business. You have been asked to prepare the inventory list for a big annual sale.

Apply the Rose, Table Style Light 17 (Table Style Light 17) to the “Inventory” table.

Answer is in the explanation below.

Question 3

SIMULATION

Project 7 of 7: Farmers Market

Overview

You are the Director of a local farmers’ market. You are creating and modifying charts for a report which shows the amounts and variety of products sold during the season.

On the “Spring Sales” worksheet, apply Style 3 and Monochromatic Color 2 (Monochromatic Palette 2) to the 3-D Pie chart.

Answer is in the explanation below.