Spreadsheets for Business: MS Excel Basics, Formulas, Charts, Pivot Tables and Data Analysis Questions

Question 1

Define spreadsheet.

Accepted Answer

A spreadsheet is an electronic worksheet used to organise and analyse data in rows and columns.

Question 2

What is a workbook?

Accepted Answer

A workbook is an Excel file containing one or more worksheets.

Question 3

What is a cell?

Accepted Answer

A cell is the intersection of a row and a column (e.g., A1).

Question 4

What is a formula in Excel?

Accepted Answer

A formula is an expression starting with = used to calculate results in Excel.

Question 5

What is a pivot table?

Accepted Answer

A pivot table is a tool to summarise and analyse large data quickly.

Question 6

What is conditional formatting?

Accepted Answer

Conditional formatting highlights cells automatically based on rules/conditions.

Question 7

Differentiate between workbook and worksheet (any three points).

Accepted Answer

Workbook is the Excel file; worksheet is a sheet inside workbook. Workbook can contain multiple worksheets; worksheet is one page of data. Saving is done for workbook, not individual worksheet separately.

Question 8

Write any three uses of Excel in business.

Accepted Answer

Excel is used for budgeting, sales reports, inventory tracking, payroll calculations and data analysis (any three).

Question 9

Write any three common Excel functions used in business.

Accepted Answer

SUM, AVERAGE, IF, COUNTIF, SUMIF and VLOOKUP are common functions (any three).

Question 10

Differentiate between relative and absolute cell reference.

Accepted Answer

Relative reference changes when copied (A1). Absolute reference remains fixed using $ signs ($A$1). Absolute references are used when a fixed rate/value is required for many calculations.

Question 11

Write any three uses of charts in business reports.

Accepted Answer

Charts show trends over time, compare categories and show proportions; they make reports easier to understand and support decisions (any three).

Question 12

Write any three steps to create a pivot table.

Accepted Answer

Select data with headings, Insert → PivotTable, choose location, and drag fields to Rows/Columns/Values (any three).

Question 13

Explain formulas and cell references in Excel with examples.

Accepted Answer

In MS Excel, formulas are used to perform calculations and automate business work.

Basics:
- A formula always starts with '='.
- It can include numbers, cell references and operators (+, -, *, /).
- Example: =B2*C2 calculates Amount when B2 is quantity and C2 is rate.

Cell references:
- Relative reference (A1): changes when copied to another cell.
- Absolute reference ($A$1): remains fixed when copied (useful for tax rate, discount rate).

Using correct formulas and references reduces manual errors and speeds up calculations in business reports.

Question 14

Explain important Excel functions used for business analysis.

Accepted Answer

Excel functions are built-in formulas used for common calculations.

Important business functions:
- SUM(range): total sales/expenses.
- AVERAGE(range): average performance.
- IF(condition, value1, value2): decision-based results (e.g., pass/fail, bonus eligibility).
- COUNTIF(range, criteria): count matching records (e.g., count orders for a region).
- SUMIF(range, criteria, sum_range): sum only matching items (e.g., sales of one product).
- VLOOKUP(value, table, col, FALSE): fetch data from a table (e.g., price of item from price list).

These functions help prepare accurate and quick business reports and summaries.

Question 15

Explain pivot tables and charts and their business uses.

Accepted Answer

Pivot tables and charts help in analysing and presenting business data.

Pivot table:
- Summarises large data into totals and counts.
- Steps: select data with headings → Insert PivotTable → drag fields to Rows/Columns/Values.
- Uses: region-wise sales, product-wise totals, monthly performance.

Charts:
- Column chart: compares categories (sales by product).
- Line chart: shows trends over time (monthly sales).
- Pie chart: shows proportion (market share).

Together, pivot tables and charts support management decision-making by converting raw data into meaningful summaries and visuals.

Spreadsheets for Business: MS Excel Basics, Formulas, Charts, Pivot Tables and Data Analysis

8 more questions to unlock