Ms Excel Flashcards
SpreadSheets Software
allows users to organize data in rows an columns and perform calculations on the data. These rows and columns collectively are called worksheet
Microsoft Excel
is a spread sheets developed by Microsoft for Windows, MacOs, Android and iOs. It features calculations, graphing, tools, pivot tables, and a macro programming language called Visual Basic for Application
Row
horizontal line of entries in a tables
Column
vertical line of entries in a table
Cell
the place where info is held in a spreadsheet
Active Cell
the selected cell
Column Heading
the box at the top of each column containing a letter
Row Heading
the row number
Cell Reference
the cell address of the cell usually combine letter and number (ex. A1, B4, C2)
Merge
combining or joining two or more cells
Functions Bar
the bar that displays the contents of a cell
=SUM(x,y) or =SUM(range)
returns the sum of x and y or all the numbers within the range
=PRODUCT(x,y)
returns the product of x and y
=QUOTIEN(x,y)
returns the quotient of x divided by y
=x-y
returns the difference of x subtracted by y
=x+y(x)
returns the sum of x and y
=x*y(x)
returns the product of x and y
=x / y
returns the quotient of divided by y
=x-y
returns the difference of x subtracted by y
=ABS( X )
returns the absolute value of x
=AVERAGE( x,y )
turns the average of x and y
=CONCATENATE( x,y ) -joins x and y
joins x and y
=IF( Condition x , y )
returns x if the condition is true , else it returns y
=ISEVEN( x )
returns true if x is an even number
=ISODD( x )
returns rue if x is an odd number
=COUNT( range )
counts the number of cell containing a number within a range
=COUNTIF( range , criteria )
count the number of cell that fits with the criteria within the range
=ISNUMBER( x )
returns true if x is a number
=ISTEXT( X )
returns true if x is a text
=LEN( X )
returns the length of characters in x
=PROPER( x )
returns the proper casing of x
=LEFT( x,y )
returns ( from the left ) the characters of x specified by y
=RIGHT( x,y )
returns the characters of x specified by y
( from the right )
=PI()
returns the value of pi
=MIN( x,y )
returns the smallest number between x and y
=MAX( x,y )
returns the largest number between x and y
=MAX( range )
returns the largest number within the range
=POWER( x , y )
returns the value of x raised to the power of y
=ROUND( x , y )
rounds x to a specified number of digits ( y )
=COLUMN( X )
returns the column number of x
=ROW( x )
returns the row number of x
=SQRT( X )
returns the square root of x
=TRIM( x )
removes extra spaces in x
=UPPER ( X )
returns x in all capital form
=LOWER( X )
returns x in non- capital form
=TODAY( )
returns the current date
=NOW( )
returns the current date and time
