🚀 Excel Interview Questions with Answers — Part 2

11. How do you format numbers as currency, percentage, or date?
Excel provides different number formats to display data properly.

Steps:
1. Select the cells
2. Go to Home → Number Group
3. Choose the required format

Common Formats:
Currency → ₹25,000
Percentage → 85%
Date → 15-May-2026

Shortcuts:
Currency → Ctrl + Shift + $
Percentage → Ctrl + Shift + %
Date → Ctrl + Shift + #

📌 Example:
0.25 displayed as Percentage becomes 25%.

12. How do you wrap text and merge cells?

Wrap Text:
Used when text is too long for a cell.

Path: Home → Wrap Text

📌 It displays content in multiple lines inside the same cell.

Merge Cells:
Combines multiple cells into one larger cell.
Path: Home → Merge & Center

Common Merge Options:
- Merge & Center
- Merge Across
- Merge Cells

⚠️ Avoid excessive merging in data tables because it can create problems while sorting/filtering.

13. How do you resize columns and rows to fit content?

Manual Resize:
- Drag the column boundary
- Drag the row boundary

Auto Resize:
Double-click the boundary between columns or rows.

📌 Example:
If employee names are cut off, AutoFit adjusts width automatically.

14. How do you apply bold, italic, borders, and background colors?
These options improve readability and presentation.

Formatting Shortcuts:
Bold → Ctrl + B
Italic → Ctrl + I
Underline → Ctrl + U

Borders:
Home → Borders

Background Color:
Home → Fill Color

📌 Example:
Highlight KPI values using bold text and colored backgrounds.

15. How do you AutoFit column width and row height?

AutoFit Column Width:
1. Select columns
2. Go to: Home → Format → AutoFit Column Width

OR
Double-click the column edge.

AutoFit Row Height:
Home → Format → AutoFit Row Height

📌 Useful for reports containing long text or wrapped content.

16. How do you print and set page layout (margins, gridlines, headers/footers)?

Print:
Shortcut: Ctrl + P

Page Layout Settings:
Path: Page Layout
You can configure:
- Margins
- Orientation (Portrait/Landscape)
- Size
- Print Area

Gridlines:
Page Layout → Gridlines → Print

Headers & Footers:
Insert → Header & Footer

📌 Example:
Add page numbers and company name in reports.

17. How do you protect a sheet or workbook with a password?

Protect Worksheet:
1. Go to: Review → Protect Sheet
2. Enter password
3. Choose allowed actions

Protect Workbook:
Review → Protect Workbook

📌 Protection prevents:
- Editing formulas
- Deleting sheets
- Structural changes

⚠️ Always keep backup passwords securely stored.

18. How do you use “Format as Table” and why is it useful?

Steps:
1. Select data
2. Go to: Home → Format as Table

Benefits:
- Automatic filters
- Better formatting
- Dynamic ranges
- Structured references
- Easier PivotTables & charts

📌 Example:
Instead of:
=SUM(A2:A100)

You can use:
=SUM(Sales[Revenue])

This is easier to read and maintain.

19. How do you use conditional formatting (highlight cells, data bars, color scales, icons)?
Conditional formatting changes cell appearance based on conditions.

Path:
Home → Conditional Formatting

Common Options:
- Highlight Cell Rules
- Top/Bottom Rules
- Data Bars
- Color Scales
- Icon Sets

📌 Example:
- Highlight sales below target in red
- Use green/yellow/red color scales for performance metrics

Formula-Based Formatting Example:
=A1>100
Highlights cells greater than 100.

20. How do you apply custom number formats?
Custom formats control how data appears without changing actual values.

Path:
Format Cells → Number → Custom

Examples:
× 0 × → 25
0.00 → 25.00
₹#,##0 → ₹12,500
0% → 75%

Display Thousands as K:
0,"K"
Result: 25000 → 25K

📌 Useful in dashboards and executive reports for cleaner visuals.

Double Tap ❤️ For Part-3