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

                                              CELL

 

Definition:-

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 .

 

       

                                   WORKSHEET

 

Definition:-

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.

 

 

 

                                          WORKBOOK

Definition:-

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.

        

                                     

                                         FORMULA

Definition:-

 

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.

 

                                               FUNCTION

 

Definition:-

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 !!