Explain the following:-1) Cell 2) Worksheet 3) Workbook 4) Formula 5) Function




Spreadsheets can have multiple sheets, with each sheet having any number of rows or columns. A cell is a location at the intersection of a particular row and column, and may contain a data value.

  • Cells are the boxes you see in the grid of an Excel worksheet.
  • like this one Each cell is identified on a worksheet by its reference.
  • The column letter and row number that intersect at the cell’s location. This cell is in column D and row 5, so it is cell D5.
  • The column always comes first in a cell reference.
  • Cell address and cell Reference is an alphanumeric value used to identified specific cell in spreadsheet .






The term Worksheet used in Excel documents is a collection of cells organized in rows and columns. It is the working surface you interact with to enter data. Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.

  • MS Excel is  also known as spreadsheet.
  • A worksheet is a components of workbook.
  • In the simple word’s the original meaning of a worksheet is a sheet of paper on which one performs work.
  • A worksheet is a single spreadsheet of data.






A workbook is an Excel file with one or more worksheets. A worksheet is a single spreadsheet of data. A workbook would be the entire binder, with everything in it. A worksheet would be like one section in that binder.

  • In Excel ,a workbook is a collection of one or more spreadsheet, also called worksheet ,in single file.
  • A workbook is a file that contains one or more worksheets to help us organize data.
  • You can the rename the sheet names to more meaningful name i.e. Daily expenses, monthly budget, etc.
  • For example a spreadsheet called “Sheet1” in an Excel workbook file called “Book1.” Or example also has the “Sheet2” and “Sheet3” sheet tabs, which are also part of the same workbook.






The formula tab allows us  to select from over 300 Excel functions. These functions are grouped into these categories: financial, logical, text, date & time, lookup and reference, math & trig, statistical, engineering, cube, information and compatibility.

A formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.

These formulas return a result, even when it is an error. Excel formulas enable you to perform calculations such as addition, subtraction, multiplication, and division.





Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations. You can find all of Excel’s functions on the Formulas tab on the Ribbon: Excel function syntax.


The most frequently used functions in Excel are:

  • AutoSum:

If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done.

Example: Autosum   [=sum(b2:c3)]


  • MATCH function:

The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range.


example, if the range A1:A3 contains the values 5, 25, and 38, then the formula =MATCH(25,A1:A3,0) returns the number 2, because 25 is the second item in the range.

-By Arti Rathia

Speak Your Mind


error: Content is protected !!