More on Excel

Review: Excel is the Microsoft Office spreadsheet application for storing and analyzing data. It is used in many different ways, for payroll and inventory, for data collection, and for personal budgets and cost calculations. An Excel spreadsheet document is referred to as a “workbook”. An Excel workbook consists of individual worksheets (or sheets).

The Elements of an Excel Worksheet are: the Title Bar, the Menu Bar, the Standard Toolbar, the Formatting Toolbar, the Name Box, the Formula Bar, Sheet Tabs, Scroll Bars, Status Bar, and Worksheet Area. You should know what these elements are and where they are located.

Excel's Automatic Features are: AutoComplete, AutoCorrect, AutoFill, AutoCalculate, and AutoSum. You should also know and understand what these are.

Vocabulary: workbook, worksheet, cell, active cell, column, row, AutoFill handle, cell address or cell reference, cell pointer, absolute cell reference, relative cell reference.

You should be comfortable using the AutoSum function, and entering common formulas - like Addition (Sum), Subtraction, Average, Multiplication, Division, Percentage, and Today's Date. Remember: All formulas must start with an equal sign (=). If you type an equal sign into a cell, Excel assumes that you are about to enter a formula. Any expression in a formula that is enclosed within a parentheses is calculated first.