Chapter 7 Case study: monthly sales report ・ MISSION 28

Mission 28: Share of sales

📋 Mission list

Task

In G2:G4, show each salesperson's sales as a percentage of the total (F5), rounded to 1 decimal place.

Select a range by dragging with the mouse or with the arrow keys while typing a formula. Type part of a function name and press Tab to complete it.

Chapter 7 ・ MISSION 28

Share of sales

In G2:G4, show each salesperson's sales as a percentage of the total (F5), rounded to 1 decimal place.

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =ROUND(F2/$F$5*100,1)

The divisor (the total) is the same on every row, so lock it with $. ROUND(value, 1) rounds to 1 decimal place.

To practice one function at a time:Function drillExcel function list

* This is a simulation of Excel calculations and may differ in some ways from how Excel actually behaves.

* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).