Lesson 4 Flashcards
- is the intersection between a row and a column on a spreadsheet that starts with
cell A1.
Cell
- A combination of a letter and a number that specifies the column and row in which a cell is located on a spreadsheet.
Cell address
- it is the heavy border around the selected cell.
Cell pointer
is a series of data banks laid out in a horizontal fashion in a spreadsheet.
Row
is a vertical series of cells in a spreadsheet.
Column
is an Excel file that contains one or more worksheets. It is another word for your Excel file.
Workbook
is a collection of cells on a single “sheet” where you actually keep and manipulate the data.
Worksheet
refers to the data in a spreadsheet. It can be in a form of text, dates, numbers and Boolean da
Values
is a customizable toolbar that contains or holds frequently used commands.
Quick access toolbar
It depicts all the features of Excel in easy to understand form. It is organized into a series of tabs - such as File, Home, and Formulas.
Ribbon
located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
Formula bar
the current worksheet that is being displayed.
Sheet tab
This shows the address of the current selection or active cell.
Name box
-contains commands which are mostly related to file management such as opening new or existing worksheet files, saving
and printing.
File tab
This tells us what is going on with Excel at any time
Status bar
is any equation entered into a cell on a Microsoft Excel spreadsheet. It is an expression which calculates the value of a cell and always starts with an equal sign (=).
Formula
are predefined formulas that perform a specific operation. Functions are typed alongside parenthesis, where in the arguments if any are listed in between.
Function
❑+ ❑- ❑*
❑/
❑ SUM
❑ SUMIF
❑ COUNT
❑ COUNTIF
❑ RANK
❑ AVERAGE
❑ AVERAGEIF ❑ IF
❑ PIVOT
Commonly Used Excel Operators and Functions
-use in a formula to add numbers.
+ (plus)
Use in a formula to subtract numbers or to signify a negative number.
-(minus)
Use in a formula to multiply number
- (asterisk; also called “star”)
Use in a formula to divide one number by another
/(forward slash)
-is a function used to compute for the summation of the number of a range.
Sum
a numeric value that you wish to sum
Number
the range of cells that you wish to sum.
Cell
is a function to sum the values in a range that meet criteria that you specify.
SUMIF
Required. The range of cells that you want to apply the criteria against.
Range
Required. The criteria used to determine which cells to add.
Criteria
Optional. It is the range of cells to sum together. If this parameter is omitted, it uses range as the
Sum range
is a function that returns the average (arithmetic mean) of the numbers provided.
Average
The first number, cell reference, or range for which you want the average.
Number 1
Additional numbers, cell references or ranges for which you want the average, up to a maximum of 255.
Number 2
- is a function that returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
Average if
it is a function used to count the cells with content in a range.
Count
it is a function that counts the number of cells in a range, that meets a given criteria.
Count if
it is a function that returns the rank of a number in a list of numbers.
Rank
it is a function that returns one value if the condition is TRUE, or another value if the condition is FALSE
IF
it is a function that returns one value if the condition is TRUE, or another value if the condition is FALSE
IF
