Excel Setup & Interface
30 min5 lessons
Lessons
1. Excel vs Google Sheets vs LibreOffice5 min2. Ribbon, Quick Access Toolbar, Name Box, Formula Bar8 min3. Workbook, Worksheet, Cell, Range5 min4. Navigation Shortcuts7 min5. File Formats: .xlsx, .xlsm, .csv, .xlsb5 minPractice file
Download m1-interface-practice.xlsx3 sheets:
Sheet Practice
- A1:A100 me numbers 1-100, lekin A50 khali chhoda gaya hai (Lesson 4 exercise ke liye)
- C1:E200 me dummy data (Name, City, Amount) with a few random blanks
Sheet Raw Data
- B2 me value
500
Sheet Formats
- A1:
1250with number format#,##0 - A2:
0.85with percentage format - A3:
=A1*A2with currency format - Har row ke saath B column me note: "Formula bar me dekho, kya alag hai?"
Lesson 5 ke hard exercise ke liye woh test.csv file khud Notepad me banao — instructions lesson ke andar hain.
Module Quiz (10 questions)
1. Which tool has Power Query?
Excel
2. What does `Ctrl + F1` do?
Hides / shows the ribbon
3. Which shortcut triggers the third QAT button?
`Alt + 3`
4. A cell displays `₹5,000` and the formula bar shows `=B2*C2`. What does the cell actually contain?
The formula
5. How many cells in `C2:F8`?
28 (4 columns × 7 rows)
6. How do you reference B10 on the `Summary` sheet?
`=Summary!B10`
7. Shortcut to select a full column of data?
`Ctrl + Shift + ↓`
8. How do you select every blank cell?
`F5` → Special → Blanks
9. You saved a three-sheet file as CSV. How many survived?
1
10. How do you preserve the pincode `0110005` when importing a CSV?
Data → From Text/CSV with the column type set to Text