a) What is a spreadsheet? Write any four advantages of a spreadsheet. [1+4] b) Write any four formulas used in MS Excel. [4]

a) What is a spreadsheet? Write any four advantages of a spreadsheet.

Spreadsheet: A spreadsheet is an electronic document that organizes data in rows and columns, allowing users to perform calculations, analyze data, and visualize information efficiently. It is widely used in business, finance, education, and personal tasks for tasks like budgeting, inventory management, and data analysis. Microsoft Excel and Google Sheets are popular spreadsheet applications.

Advantages of a Spreadsheet:

1. Data Organization: Spreadsheets allow users to arrange data systematically in rows and columns, making it easy to sort, filter, and retrieve information.
2. Automatic Calculations: Spreadsheets perform complex calculations instantly using built-in formulas, reducing manual errors and saving time.
3. Data Visualization: Users can create charts, graphs, and pivot tables to represent data visually, aiding in better decision-making.
4. Collaboration: Modern spreadsheets support real-time collaboration, allowing multiple users to edit and review data simultaneously from different locations.

---

b) Write any four formulas used in MS Excel.

1. SUM Formula: Used to add up a range of numbers.

   =SUM(A1:A10)
   

   This adds all values from cell A1 to A10.

2. AVERAGE Formula: Calculates the average (mean) of a set of numbers.

   =AVERAGE(B1:B20)
   

   This computes the average of values from B1 to B20.

3. IF Formula: Performs a logical test and returns one value if true and another if false.

   =IF(C1>50, "Pass", "Fail")
   

   If the value in C1 is greater than 50, it returns "Pass"; otherwise, it returns "Fail."

4. VLOOKUP Formula: Searches for a value in the first column of a table and returns a value in the same row from a specified column.

   =VLOOKUP(D2, E2:F10, 2, FALSE)
   

   This looks up the value in D2 within the range E2:F10 and returns the corresponding value from the second column (F).