Computer (4th quarter)

• Formula- is an expression which calculates the value of cell in Excel
• Cell Reference- refers to a cell or cell range that can be used to solve a formula in a spreadsheet program
• AutoSum- allows you to add quickly a range of cells together
• Functions- are ready-made formulas that perform a series of operations on a specified range of values
• COUNT Function- is generally used to count a range of cells containing numbers or dates excluding blanks and texts
• TEXT Function- allow you to modify and format texts
• IF Function- checks whether a condition is met and returns one value if true and another value if false
• COUNTIF Function- is a function used to count cells that meet a single criterion
• Text Orientation- gives the options that can be used to fit text in a narrow column
• Applying Number Formatting- does not change the actual information in any way
• Themes- are formatting presets that you can apply to entire worksheet
• Gridlines- horizontal and vertical lines that divide the worksheet into cells
• Workbook- contains atleast one worksheet by default
• Orientation- is often used to fit text in a narrow column
• Excel- is best known for its feature of performing calculations
• Home Tab- are most commonly used formatting commands are shown
• Basic Formatting- can customize the look and feel of your workbook, allowing you to draw attention to specific sections and making your content easy to view and understand
• these rules are called the syntax of computer language
• these are functions allow you to modify and format texts in Excel: upper function, lower function, substitute function
• there are two types of cell reference: absolute reference and relative cell reference
• counta function, counts everythings: numbers, dates, texts, a range containing a mixture
• different ways to view a workbook: normal view, page layout view, page break view