City Introduction to Excel
User Interface of MS Excel
Title bar Column Heading
Quick Access Tool Bar Row Heading
File Name Scroll Bar
Tabs Minimize
Ribbon/Command Bar Maximize
Name Box Close
Select all button Sheets
Insert Function button Status Bar
Formula Bar Page view button
Window/File button Zoom Slider
Enter data City Jan
Edit Data Pune 3
Ctrl Enter Mumbai 18
Tab Chennai 25
Shift Tab Goa 21
Data
Shift Data
Feb Mar Overwriting/Editing cell content
35 23 Editing Formula/Functions
18 22 Using Undo/Redo
28 22 Find and Replace
17 25 GoTo
Add row/add column
delete row/delete column
F2
Ctrl Z/Ctrl Y
Ctrl F and Ctrl H
Ctrl G
ctrl+shift++
ctrl+-
Copy Ctrl+c
Paste Ctrl+v
Cut Ctrl+x
City Jan Feb Mar
Pune 3 35 23
Mumbai 18 18 22
Chennai 25 28 22
Goa 21 17 25
City Jan Feb Mar
Pune 3 35 23
Mumbai 18 18 22
Chennai 25 28 22
Goa 21 17 25
Superstore Sales She
Date Product Discount
10/1/2019 Custard Powder 10%
9/30/2019 Baking Powder 20%
4/16/2019 Cornflour 40%
1/21/2020 Vegetarian Jelly 30%
3/12/2020 Cremelle Pudding Mix 60%
12/6/2020 Freeze Ice Cream Mix 20%
8/14/2020 Cocoa Powder 22%
8/16/2020 Icing Sugar 12%
7/7/2019 Vanilla Powder 15%
5/12/2020 Sweet Corn kernels 10%
Sales Sheet
Qty Profit
13 ₹ 11.23 ₹ 2,517.00
4 ₹ 975.00 ₹ -3,682.00
18 ₹ 833.00 ₹ 2,955.00
13 ₹ 486.00 ₹ -3,347.00
11 ₹ 99.77 ₹ 1,610.00
12 ₹ 862.00 ₹ 3,090.00
18 ₹ 453.00 ₹ -3,615.00
19 ₹ 22.66 ₹ 2,499.00
3 ₹ 584.00 ₹ 4,817.00
17 ₹ 738.00 ₹ 3,301.00
