EXCELCBT

MS Excel CBT Examination

Time Left: 30:00

Theory Questions

1. Explain absolute cell reference in Excel.

Absolute reference uses $ sign (e.g., $A$1) and does not change when copied.

2. Explain Pivot Table.

Pivot Table summarizes large data into totals, averages, and grouped analysis.

3. Explain VLOOKUP.

VLOOKUP searches vertically in a table and returns matching value.

4. Define Gross and Net Salary.

Gross Salary is total earnings before deductions. Net Salary is take-home pay after deductions.

5. Explain Goal Seek.

Goal Seek finds input value needed to achieve a specific result.