UNIT - 4

1. What is the HLOOKUP() function in MS Excel? Give one example.

HLOOKUP (Horizontal Lookup) searches for a value in the first row of a table and returns a corresponding value from a specified row.

Syntax:
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Example:
=HLOOKUP("Maths", A1:F5, 3, FALSE)
(Searches "Maths" in first row and returns value from 3rd row.)

2. What is Filtering in MS Excel? State its purpose.

Filtering is a feature in Excel that allows users to display only selected data based on specific conditions.

Purpose:

  • To view specific data from a large dataset
  • To analyze selected records easily

3. State the components of a Pivot Table.

The four main components of a Pivot Table are:

  • Filters
  • Rows
  • Columns
  • Values

4. Data Validation in MS Excel with an example.

Data Validation is used to control what type of data can be entered in a cell.

Example:
Allow only numbers between 1 and 100 for marks entry.

5. Write any one Logical Function used in MS Excel and mention its purpose.

IF Function

Purpose:
Tests a condition and returns one value if TRUE and another if FALSE.

Example:
=IF(A1>=50,"Pass","Fail")

6. Text Functions in MS Excel with one example.

Text functions are used to manipulate and format text data.

Example:
=UPPER("excel")
Output: EXCEL

7. Role of Date and Time Functions in MS Excel.

Date and Time functions help manage dates, schedules, deadlines, and time calculations.

They are used for:

  • Tracking age and duration
  • Managing attendance and payroll
  • Calculating differences between dates


UNIT - 3

1. What is Microsoft Excel? State any two uses.

Microsoft Excel is a spreadsheet application used to organize, calculate, analyze, and present data in tabular form.

Any two uses:

  • Data entry and storage
  • Calculations using formulas and functions

2. Define Spreadsheet Addressing. Mention its types.

Spreadsheet addressing refers to identifying and locating data in a worksheet using cell addresses (column letter + row number, e.g., A1).

Types of cell references:

  • Relative Reference (A1)
  • Absolute Reference ($A$1)
  • Mixed Reference ($A1 or A$1)

3. Differentiate between rows and columns in MS Excel.

Rows Columns
Horizontal arrangement of cells Vertical arrangement of cells
Identified by numbers (1, 2, 3…) Identified by letters (A, B, C…)
Example: Row 1, Row 2 Example: Column A, Column B

4. Explain the steps involved in opening & saving a spreadsheet.

Opening Excel:

  • Click Start → Microsoft Excel
  • Select Blank Workbook or template

Saving a Spreadsheet:

  • Click File → Save / Save As
  • Choose location
  • Enter file name
  • Click Save

5. Explain the purpose of Microsoft Excel and mention two applications.

Purpose:
Microsoft Excel is used to organize, calculate, analyze, and present data efficiently.

Any two applications:

  • Financial calculations
  • Academic result processing

6. Differentiate between a workbook and a worksheet.

Workbook Worksheet
A file in Excel A single sheet inside a workbook
Contains multiple worksheets Contains rows and columns
Example: .xlsx file Example: Sheet1

7. Define Functions in MS Excel and write any two examples.

A function is a predefined formula in Excel used to perform specific calculations automatically.

Examples:

  • =SUM(A1:A5)
  • =AVERAGE(B1:B5)

8. Explain the importance of cell address in Excel.

Cell address identifies the exact location of data in a worksheet (e.g., A1, B5).

It is important because:

  • It helps in writing formulas
  • It allows referencing and calculating data accurately
  • It helps copy formulas correctly