ICT

• Template- a formatted workbook or worksheet designed to help users fufill a specific need in Excel.
• Operator- these symbols or signs that indicate which calculation must be made in an expression.
• Formula- a sequence inside a cell that is used to produce a value. It must begin with an equal (=) sign. This could be a mathematical equation, cell references, functions or operator. A formula is also known as an expression.
• Formula bar- Nestled between the ribbon and workbook, the Formula Bar will display the contents of an active cell.
• Function- are formulas that are pre-built into Excel.
• Column and Row headings- these headings are lettered and numbered gray areas found just outside of columns and rows. Clicking on a heading will select the entire row or column.
• Ribbon- a section of command tabs above the workbook. A multitude of options are foumd behind each tab of the __.
• Cell reference- a set of coordinates that identifies a specific cell. It's a combination of letters and numbers, A5, for example, would point to the cell located where column Aa and row 5 intersect.
• Cell Range- a collection of cells that have been identified as a group based on a variety of criteria. By using a colon(:) between cell references, Excel can determine the range, also known as an array.
• Merged Cell- a combination of two or more cells.
• Workbook- refers to an Excel spreadsheet file. It houses all of the data that you have entered and allows you to sort or calculate the results.
• Worksheet- a document within the workbook. Also known as spreadsheets.
• Cell- a rectangle or block housed in a worksheet. Any data that you want to enter into your worksheet must be placed in a __.
• Active Cell- a cell that is currently opened for editing.
• Columns and Rows- Columns and Rows refer to how your cells are aligned. Columns are aligned vertically while rows are asigned horizontally.
• SUM- used to sum up a group of numbers in a particular cell. SUM(number1, [number2], ....)
• Average- returns thr average of its arguements. AVERAGE automatically ignores blank cell and text, but Zero Values are included
• Count- helps you to find out and count the number ot cells that contains numbers.
• Counta- Counts how many values are in the list of arguments. The Counta Functions does not count the empty cells. You can calculate the value of the Non-blank crll with the help of COUNTA Function. COUNTA(value1, [value2], ....)
• Concatenate - helps to combine numbers, text from different cells into one cells. CONCATENATE(text1, [text2], ....)
• IF - Specifies a logical test to perform IF(logical_test, [value_if_true], [value_if_false])
• = - equal to
• <> - not equal to
• > - greater than
• < - less than
• >= - greater than or equal to
• <= - less than or equal to
• RANK - returns the order( or rank) of a numeric value compared to other values in the same list. RANK(number, ref,[order])
• Number - the value whose rank you'd like to find
• Ref - a list of numeric values to rank against
• Order (optional) - a number that specifies how to rank values
• Cell array - Another word for using colon (:) or cell range.
• Absolute reference - The column and row coordinates stay constant while copying a formula. It uses a dollar sign ($)
• Freeze panes - allow an area of a worksheet to be visible while scrolling to another area, SELECT VIEW> Freeze Panes>...
• Exact - checks to see if two text values aee identical
• Lower - Converts text to lowercase
• Proper - Capitalizes the first letters in each word of a text value
• ISBLANK - Returns TRUE if the value is blank
• ISERROR - Returns TRUE if the value is any error value
• ISNONTEXT - Returns TRUE if the value  is not text