Advanced and Complex Formulas and Computations Flashcards
a tool that is used to
store, manipulate, and analyze data. Data in a spreadsheet is organized in a series of rows and columns and can be searched, sorted, calculated, and used in a variety of charts and graphs.
Spreadsheet Software
Spreadsheet Software Examples
*LibreOffice Calc
*OpenOffice.org Calc
*Google Sheets
*Apple iWork Numbers
*Kingsoft Office Spreadsheets
*StarOffice Calc
*Microsoft Excel
horizontal line of entries in a table
Row
vertical line of entries in a table
Column
the place where info. is held in a spreadsheet
Cell
the selected cell
Active Cell
the box at the top of each column containing a letter
Column Heading
the row number
Row Heading
the cell address of the cell usually combine letter and number (ex. A1, B4, C2)
Cell Reference
combining or joining two or more cells
Merge
is an expression that calculates the value of a cell.
- Cells Formula
are predefined formulas and are already available in Excel
Functions
the bar that displays the contents of a cell
Formula Bar
returns the sum of x and y or (all the numbers within the range)
Basic Math Operations (Functions)
=SUM(x,y) or =SUM(range)
returns the product of x and y
Basic Math Operations (Functions)
=PRODUCT(x,y)
returns the quotient of x divided by y
Basic Math Operations
=QUOTIENT(x,y)
returns the difference of x subtracted by y
Basic Math Operations
=x-y
returns the sum of x and y
Basic Math Operations
=x+y
returns the product of x and y
Basic Math Operations
=x*y
returns the quotient of x divided by y
Basic Math Operations
=x/y
returns the absolute value of x
Other Functions
=ABS(x)
returns the average of x and y
Other Functions
=AVERAGE(x,y)
joins x and y
Other Functions
=CONCATENATE(x,y)
returns x if the condition is true, else it returns y
=IF(Condition, x, y)
returns true if x is an even number
=ISEVEN(x)
returns true if x is an odd number
=ISODD(x)
counts the number of cells containing a number within a range
=COUNT(range)
count the number of cell that fits with the criteria within the range
=COUNTIF(range, criteria)
returns true if x is a number
=ISNUMBER(x)
returns true if x is a text
=ISTEXT(x)
returns the length of characters in x
=LEN(x)
returns the proper casing of x
=PROPER(x)
returns the characters of x specified by y (from the left)
=LEFT(x,y)
returns the characters of x specified by y (from the right)
=RIGHT(x,y)
returns the value of pi
=PI()
returns the smallest number between x and y
=MIN(x,y)
returns the largest number between x and y
=MAX(x,y)
returns the smallest number within the range
=MIN(range)
returns the largest number within the range
=MAX(range)
returns the value of x raised to the power of y
=POWER(x,y)
rounds x to a specified number of digits (y)
=ROUND(x,y)
returns the column number of x
=COLUMN(x)
returns the row number of x
=ROW(x)
returns the square root of x
=SQRT(x)
removes extra spaces in x
=TRIM(x)
returns x in all capital form
=UPPER(x)
returns x in non- capital form
=LOWER(x)
returns the current date
=TODAY()
returns the current date and time
=NOW()
is a special
feature (formatting feature) of Excel used to find unique and duplicate values by formatting the cells.
Conditional Formatting
As the name implies ________________ allows the users to format the cells and their data based on some conditions specified by the user. Using conditional formatting, you can highlight a cell with a certain color and its content with a different font.
Conditional Formatting
