Create a formula to work out the wealth per year for each person. To do this you must divide wealth by age and then copy the formula down: 2 Use functions to work out the total and average wealth per year at the bottom of the list: NB: Use the SUM and AVERAGE functions to do this. 3 Adjust the Name Column so that the text is completely visible. 4 Format the Wealth ($bil) Column to display the figures in currency format
The 10 Richest People in the World 2023 |
|||||||||||||||
Rank |
Name |
Age |
Wealth ($bil) |
Wealth per year |
|||||||||||
1 |
Bernard Arnault & family |
74 |
211 |
||||||||||||
2 |
Elon Musk |
51 |
212 |
||||||||||||
3 |
Jeff Bezos |
59 |
213 |
||||||||||||
4 |
Larry Ellison |
78 |
214 |
||||||||||||
5 |
Warren Buffett |
92 |
215 |
||||||||||||
6 |
Bill Gates |
67 |
216 |
||||||||||||
7 |
Michael Bloomberg |
81 |
217 |
||||||||||||
8 |
Carlos Slim & family |
83 |
218 |
||||||||||||
9 |
Mukesh Ambani |
65 |
219 |
||||||||||||
10 |
Steve Ballmer |
67 |
220 |
||||||||||||
Total |
|||||||||||||||
Average |
|||||||||||||||
1 |
Create a formula to work out the wealth per year for each person. To do this you must divide wealth by age and then copy the formula down: |
|
|||||||||||||
2 |
Use functions to work out the total and average wealth per year at the bottom of the list: |
NB: Use the SUM and AVERAGE functions to do this. |
|
||||||||||||
3 |
Adjust the Name Column so that the text is completely visible. |
|
|||||||||||||
4 |
Format the Wealth ($bil) Column to display the figures in currency format |
|
|||||||||||||
Step by step
Solved in 6 steps with 7 images