Module quiz: Excel fundamentals: Preparing Data for Analysis with Microsoft Excel (Microsoft Power BI Data Analyst Professional Certificate)

Question 1

True or False: When you select the Filter button on the Data tab, Excel automatically filters the data based on choices that you have already made in the drop-down menus next to each heading.

❌ True
✅ False

Explanation:
Filter button sirf filtering ko enable karta hai. Excel tab tak koi filter apply nahi karta jab tak user manually filter conditions select na kare.

Question 2

You want to identify all rows in the data that have a figure exceeding 500 in a specific column. Which of the following options can you use?

❌ Use Does not equal on the Number Filter sub-menu.
✅ Use Greater than on the Number Filter sub-menu.
❌ Use Equals on the Number Filter sub-menu.

Explanation:
“Greater than” option ka use karke aap kisi bhi specific value se zyada numbers ko easily filter kar sakte ho.

Question 3

True or False:
Sorting the Join Date column (Newest to Oldest) and then sorting the Department Name column (A–Z) will correctly apply a multi-level sort.

❌ True
✅ False

Explanation:
Multi-level sorting ke liye Excel me Custom Sort ka use karna hota hai. Alag-alag sorting karne se hierarchy maintain nahi hoti.

Question 4

You are having difficulty locating numbers in a large worksheet. You decide to name the cells. Which of the following are valid names?

✅ MonthlyProfit2
✅ Monthly_Profit
❌ Monthly Profit

Explanation:
Excel cell names me spaces allowed nahi hote. Letters, numbers aur underscore (_) valid hote hain.

Question 5

You use the New Window command to view two copies of your worksheet. Which ribbon do you select?

❌ The Home ribbon
❌ The Review ribbon
✅ The View ribbon

Explanation:
New Window command View ribbon me hota hai aur same workbook ki multiple views open karta hai.

Question 6

Which of the following tasks can you perform using the Search box on the Title bar?

❌ Search for text or number content in a worksheet
❌ Search for Names assigned to cells
✅ Search for text or number content across a whole workbook

Explanation:
Title bar ka Search (Microsoft Search) poore workbook level par content locate karne me use ho sakta hai. Worksheet-specific ya named cell search ke liye alag tools hote hain (Ctrl + F).

Question 7

You need to change the position of sheets in a workbook. Which steps can you take?

✅ Point at the sheet tab, right-click, and choose Move or Copy
❌ Hold down the Ctrl key and drag the sheet
✅ Click and drag the sheet tab to a new location

Explanation:
Sheet tab ko drag karna ya Move or Copy option use karna sheet ko move karta hai. Ctrl key dabane se sheet copy hoti hai.

Question 8

Mouse pointer shape for copying data using AutoFill:

❌ A white cross
❌ An arrow
✅ A narrow black cross

Explanation:
AutoFill tab kaam karta hai jab mouse pointer narrow black cross me change hota hai (fill handle par).

Question 9

Columns D and E contain confidential data. Which Home ribbon option can you use to hide them?

✅ Format drop-down
❌ Insert drop-down
❌ Delete drop-down

Explanation:
Home → Format → Hide & Unhide → Hide Columns ka use karke columns temporarily hide kiye ja sakte hain.

Question 10

You manually adjust column width and type long data. What happens when the adjacent cell contains data?

❌ Content wraps to a new line
❌ Content is replaced by ####
✅ Content becomes partially hidden

Explanation:
Jab adjacent cell me data hota hai, to pehle cell ka overflow text hide ho jata hai.

🧾 Summary Table