Using formulas is a basic part of Microsoft Excel. Please describe a formula and a cell reference and how they interact.
What will be an ideal response?
- A formula specifies how to add, subtract, multiply, divide, or otherwise calculate the values in worksheet cells. A formula always begins with an equal sign (=) and can use cell references that point to the contents of other cells.
- A cell reference is the column and row location of a cell, for example, B1 and B2.
- How a formula uses cell references: The formula =B1-B2 subtracts the contents of cell B2 from the contents of cell B1 and displays the results in the active cell, for example, B3.
You might also like to view...
Some software includes a setup module that guides you through the installation process.
Answer the following statement true (T) or false (F)
The Exact Fit option of the Scale attribute of a Flash movie scales the movie to the exact dimensions set in W and H, regardless of the aspect ratio of the movie.
Answer the following statement true (T) or false (F)
A(n) ________ is a replica of a table or query's Datasheet view that maintains some form properties although the form is limited in design and control options?
A) Subform B) Split form C) Datasheet form D) Multiple Items form
The new Language Conversion feature can be used to translate entire documents instantly, using machine translation services available over the Internet.
Answer the following statement true (T) or false (F)