Answer:

1 ) Basic Components of Computer

Input Unit.

Output Unit.

Memory Unit.

Control Unit.

Arithmetical and Logical Unit.

2 )A cell REFERENCE in Excel refers to the value of a different cell or cell range on the current worksheet or a different worksheet within the spreadsheet. A cell reference can be used as a variable in a FORMULA

Explanation: To enter a formula that contains cell references, you have two choices. You can type cell references DIRECTLY, or you can point and click to cells to pick up their addresses. The most basic way to enter cell references in a formula is to just type in the references as you need them.

3 )Write an equation or formula

Choose Insert > Equation and choose the equation you want from the gallery.

After you insert the equation the Equation Tools Design tab opens with symbols and structures that can be added to your equation.

The formula will go in cell B2 -- that's the cell in row 2, in column B

First, select the cell where you want the formula -- cell B2

. Every Excel formula starts with an equal sign, so type an equal sign: =

. Then, type the first number: 1

. We want to add that to another number, so type a plus sign: +

. Type the next number for the formula: 2

. Press the Enter key, to complete the formula

4 )AutoSum is a Microsoft Excel and other spreadsheet program function that adds TOGETHER a range of cells and displays the total in the cell below the selected range. For example, if you wanted to add the values of cells between A1 and A5, highlight cells A1 through A5 and click the AutoSum button (shown right

5 )Function-Library

Insert Function

Autosum

Recently Used

Financial

Logical

Text

Date & Time

Lookup & Reference

Math & Trig

More Functions

Statistical

Engineering

Cube

Information

Compatibility

Web