Practice: Formatting
Merge and Center
Tensile Strength of Cement*
1 13 13.3 11.8
2 21.9 24.5 24.7
3 29.8 28 24.1 24.2 26.2
7 32.4 30.4 34.5 33.1 35.7
28 41.8 42.6 40.3 35.7 37.3
Apply Formatting
€ 100.00 Currency
10000% Percentage
1,000,000.00 Thousands comma separator
100.000 Increase decimals
100.0 Decrease decimals
Apply Borders
Create a Text Box
my text box
my text box
Use the Format Painter
Sales
January $5,400.00
February $3,152.00
March $6,582.00
Sales
January $5,400.00
February $3,152.00
March $6,582.00
Practice: Charting
Generate a Quick Chart
Sales
Sales
Quarter 1 $500
Quarter 2 $550
Quarter 3 $650
Quarter 1 Quarter 2 Quarter 3
Chart Title
Use the Chart Wizard to Create a Chart
$600
March April May $500
Marketing $350 $400 $325
Overhead $100 $100 $110 $400
R&D $500 $550 $525
$300
$200
$100
$0
March April
Marketing Overhead R&D
Y
700000
Create a Scatter Plot (XY Chart)
600000
X 5000 10000 15000 500000
Y 200000 400000 600000
400000
300000
200000
100000
0
4000 6000 8000 10000 12000
500000
400000
300000
200000
100000
0
4000 6000 8000 10000 12000
Sales
Quarter 1 Quarter 2 Quarter 3
Chart Title
April May
Marketing Overhead R&D
8000 10000 12000 14000 16000
8000 10000 12000 14000 16000
1 Highlight all the dates after October 06, 2018:
Date
11/3/2018
5/11/2019
12/3/2018
9/26/2019
4/12/2018
1/3/2019
5/6/2018
6/21/2019
7/24/2019
4/22/2018
6/8/2019
10/17/2017
1/28/2018
3/19/2019
8/18/2019
10/19/2017
2 Highlight all grades above average:
Grades
59
56
75
99
86
72
89
67
76
80
71
56
63
100
100
3 Highlight all the duplicate names:
John
Danny
Dean
Donny
Jake
Jill
Hannah
Jake
John
Danny
Dean
4 Highlight all cells greater than the MEDIAN of the range:
79
59
60
78
87 78
88
71
78
99
54
57
95
55
91
76
79
1. Split the following column to columns:
Name~Age~Favorite Color
Dan~33~Yellow
Gil~27~Red
Tom~33~Blue
Sammy~28~Black
Sharon~22~Pink
2. Convert the American Dates to European Dates:
Date
5/20/15
3/15/17
4/16/2016
9/30/2015
5/4/2017
3. Convert the following values from numbers to text:
ID Is it text?
3435 0
3245 0
2346 0
5635 0
1 Apply Filtering on the table below
2 Filter by the City "New York"
3 Filter by dates between October 15, 2020 until December 15, 2020
4 Filter by Oven and Food Processor
5 Filter by the Red Color in the Date column
Date Customer Name Product Price City
11/16/2020 John Washing Machine 348 New Delhi
12/20/2020 Dina Dish Washer 272 Amsterdam
11/2/2020 Ralph Oven 342 New Delhi
1/15/2021 Samuel Microwave 346 New York
10/4/2020 Terry Food Processor 259 New-Delhi
11/13/2020 Benjamin Dish Washer 232 Tel Aviv
11/6/2020 Tal Washing Machine 265 Jerusalem
8/14/2020 Yifat Oven 242 Mumbai
10/21/2020 Tina Dish Washer 282 Dubai
1/14/2021 Simona Food Processor 305 Abu Dhabi
8/20/2020 Jenna Microwave 376 Shanghai
9/7/2020 Donald Washing Machine 360 Hong Kong
1/15/2021 Joe Oven 302 New Delhi
1/27/2021 Julius Dish Washer 236 New-Delhi
9/6/2020 Kobe Microwave 255 Austin
10/25/2020 Lawrence Washing Machine 315 New York
10/22/2020 Drake Dish Washer 331 London
11/17/2020 Kirk Washing Machine 386 Moscow
All rights reserved
www.excel-practice-online.com
Practice SUM Function
Name No. of Apples
Guy 3
Lev 5
Yoav 2
Yossi 6
Dana 8
Total < - Insert formula here!
Practice AVERAGE function
What is the average age of the following people?
Name Age
Danny 20
Becky 16
John 19
Paul 3
Dean 9
Jack 7
Dina 12
Averge: < - Insert formula here!
Practice DAY, MONTH & YEAR functions
Extract the day, month and year from the following date:
Date: 4/18/2019
Day <= Insert formula here
Month <= Insert formula here
Year <= Insert formula here
Typing in Excel
What is your name?
<= Type your name here
What is your favorite pet?
<= Type your pet here
What is your favroite movie?
<= Type your movie here
What is your lucky number?
<= Type your lucky number here
Practice DATE function
Create a valid date from the following values:
Day Month Year
11 12 2020 <= Insert formula here
25 1 2019 <= Insert formula here
Practice SEARCH function
Find the position of the following texts:
Find Within:
PEPPER Blue Cold Cayenne P <= Insert formula here
maid Iron Maiden <= Insert formula here
