Scribd
Upload
3 views4 pages

Key Definitions

The document provides key definitions and concepts related to spreadsheets, including what a spreadsheet is and the types of cell referencing: relative, absolute, and mixed. It distinguishes between formulas and functions, explaining that formulas are user-defined calculations while functions are built-in calculations in Excel. Additionally, it lists common built-in functions and error messages encountered in spreadsheets.

Uploaded by

rakhee kar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views4 pages

Key Definitions

The document provides key definitions and concepts related to spreadsheets, including what a spreadsheet is and the types of cell referencing: relative, absolute, and mixed. It distinguishes between formulas and functions, explaining that formulas are user-defined calculations while functions are built-in calculations in Excel. Additionally, it lists common built-in functions and error messages encountered in spreadsheets.

Uploaded by

rakhee kar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Key Definitions & Concepts

 What is a Spreadsheet?
A spreadsheet is an interactive computer application used for organizing, analyzing, and
storing data in a tabular format consisting of rows and columns. [1]

 What is a Cell Reference?


The cell address in a formula is known as a cell reference. It allows you to use the data from
other cells to perform calculations. [1, 2, 3, 4]

 What are the Three Types of Cell Referencing?

o Relative Reference: A default reference that changes automatically when you copy
the formula to a new cell (e.g., A1).

o Absolute Reference: A reference that remains constant even if the formula is copied.
It uses the dollar sign, like $A$1.
o Mixed Reference: A combination where either the row or column is made absolute
(e.g., $A1 or A$1). [1, 2]

Formulas vs. Functions

 Formula: A user-defined instruction to perform calculations on data (e.g., =A1+B1). It always


starts with an equals sign (=).

 Function: Predefined, built-in formulas in Excel designed to perform complex or simple


calculations quickly (e.g., =SUM(A1:A5)). [1, 2, 3]

Common Built-in Functions

 SUM(): Adds all the numbers in a specified range of cells.

 AVERAGE(): Calculates the average/mean of numbers in a range.

 MAX(): Returns the largest numeric value in a range.

 MIN(): Returns the smallest numeric value in a range.

 COUNT(): Counts the number of cells that contain numeric values within a range. [1, 2]

Error Messages

 ### : The column is too narrow to display the complete numeric value.

 #DIV/0! : The formula is trying to divide a number by zero.

 #VALUE! : The formula contains an invalid operation, like adding text to a number. [1]

You might also like