Our Recommendation for You Search your Query, You can find easily. for example search by book name or course name or any other which is related to your education

Followers

Most Popular Free Games

How to calculate the most expensive and the cheapest game for PC and Mobile - popular PC games for kids

Using Excel very quickly, we can calculate the specific requirements for game prices

In this example, the tutorial will show how Excel can perform the calculation according to the specific application.
In the example below evident in column 'A' group games for computers and mobile phones. In column 'B' note the names of popular games PC and Mobiles for kids

  1. Most popular PC game
    • The Long Dark
    • Darkwood
    • Routine
    • Planetary Annihilation
    • Civilization: Beyond Earth
    • Dragon Age: Inquisition
    • Diablo 3: Reaper of Souls
    • Broken Age
    • Wolfenstein The New Order
    • Assassin's Creed: Unity
    • Everquest Next
    • Watch Dogs
    • Wasteland 2
    • South Park: The Stick of Truth
    • Hotline Miami 2: Wrong Number
    • Tropico 5
    • Lords of the Fallen
    • The Sims 4
    • Titanfall
    • The Elder Scrolls Online
    2. Popular Actions games
    • Gears of War - Xbox 360
    • Resident Evil 4 - Wii
    • God of War and God of War 2
    • Tools of Destruction
    • Ghost Recon Advanced Warfighter 2
    • Crackdown
    • Drake's Fortune
    3. Popular PC Games For Kids
    • World of ZOO
    • Nancy Drew
    • Itzabitza
    • Babysitting mania
    • Cake mania 3
    • Star Wars
    • Lucidity
    • My Sims
In Column 'C' note prices for each game without taxes.
ATTENTION! These prices are not real games, they are unrealistic and set of example only tutorials.

In column 'D' you see game prices with tax.


A
B
D
1
Most popular PC game
Price
Price with tax
2
The Long Dark$100,00$125,00
3
Darkwood$100,00$125,00
4
Routine$100,00$125,00
5
Planetary Annihilation$100,00$125,00
6
Civilization: Beyond Earth$170,00$212,50
7
Dragon Age: Inquisition$100,00$125,00
8
Diablo 3: Reaper of Souls$100,00$125,00
9
Broken Age$200,00$250,00
10
Wolfenstein The New Order$220,00$275,00
11
Assassin's Creed: Unity$100,00$125,00
12
Everquest Next$300,00$375,00
13
Watch Dogs$100,00$125,00
14
Wasteland 2$100,00$125,00
15
South Park: The Stick of Truth$380,00$475,00
16
Hotline Miami 2: Wrong Number$120,00$150,00
17
Tropico 5$100,00$125,00
18
Lords of the Fallen$150,00$187,50
19
The Sims 4$100,00$125,00
20
Titanfall$200,00$250,00
21
The Elder Scrolls Online$100,00$125,00
22
$147,00
23
Popular Actions games
Price
Price with tax
24
Gears of War - Xbox 360$100,00$125,00
25
Resident Evil 4 - Wii$100,00$125,00
26
God of War and God of War 2$100,00$125,00
27
Tools of Destruction$100,00$125,00
28
Ghost Recon Advanced Warfighter 2$170,00$212,50
29
Crackdown$100,00$125,00
30
Drake's Fortune$214,00$267,50
31
$126,29
32
Popular PC Games For Kids
Price
Price with tax
33
World of ZOO$7,00$8,75
34
Nancy Drew$420,00$525,00
35
Itzabitza$10,00$12,50
36
Babysitting mania$15,00$18,75
37
Cake mania 3$10,00$12,50
38
Star Wars$17,00$21,25
39
Lucidity$21,00$26,25
40
My Sims$10,00$12,50
41
$63,75
42
43
Name
The
cheapest
 game 
The most
 expensive game 
44
Games
World of ZOO
Nancy Drew
45
$7,00
$420,00

In the table you notice that the game is the most expensive and which game is the cheapest.

To calculate the price with tax for a single game using the following formula

=(C2*25/100)+C2

The average cost of all games by groups in cells C10, C19 and C29 using the AVERAGE Excel function to calculate using the following formula

=AVERAGE(C2:C9)

What is the cheapest game

To calculate which is the cheapest game use this formula using Excel function MIN
In cell C44 set the following formula

=INDEX(B2:B40;MATCH(MIN(C2:C40);C2:C40;0))

and in cell C45 the following formula

=MIN(C2:C9;C12:C18;C21:C28)

What is the most expensive game

To calculate the most expensive game use this formula using Excel function MAX 
In cell D44 set the following formula

=INDEX(B2:B40;MATCH(MAX(C2:C40);C2:C40;0))

and in cell D45 the following formula

=MAX(C2:C9;C12:C18;C21:C28)

ATTENTION! These prices are not real games, they are unrealistic and set of example only tutorials.