Excel Setup & Interface
30 मिनट5 पाठ10 प्रश्न
पाठ
अभ्यास फ़ाइल
⬇ डाउनलोड करें 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.
मॉड्यूल प्रश्नोत्तरी (10)
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