G4-Computer-4th QA

It is the address of each cell in a worksheet.

• Cell Reference

• Relative referencing

• Absolute referencing

It refers to cells using only their column and row labels. 

• Cell Reference

• Relative Referencing

• Absolute Referencing

If you want to copy a formula to another cell but do not want the cell references to change, you must add a dollar sign ($) before the cell addresses in the formula that you do not want to change.

• Cell Reference

• Relative Referencing

• Absolute Referencing

It enables Excel to locate data that will be used in a formula. 

• Cell Referencing

• Absolute Referencing

• Relative Referencing

It uses symbols for a variety of operation.  They can also be edited and copied to other cells in the worksheet. 

• Lines

• Formula

• Connector

It is used when you want either the row or the column to be relative or absolute.

• Absolute Referencing

• Cell Referencing

• Mixed Referencing

It gives you quick access to shapes you have just used.

• Recently Used Shapes

• Lines

• Connectors

It lets you draw straight or curved lines, single or double arrows, elbow or curved connectors, freeform lines, and scribbles.

• Rectangles

• Lines

• Connectors

These are used to connect elements in a flowchart.

• Lines

• Triangles

• Connectors

It lets you draw different types of rectangles, be they regular, rounded, or with snipped corners.

• Rectangles

• Basic Shapes

• Connectors