Page 28 - GE 10 Module Crim Midterm

QUIRINO STATE UNIVERSITY

COLLEGE OF PUBLIC SAFETY
Bachelor of Science in Criminology
…harmonizing ideals

2. Navigate to the desired worksheet. In
our example, we'll select the Catering
Invoice worksheet.

3. Locate and select the cell where you
want the value to appear. In our example,
we'll select cell C4.

4. Type the equals sign (=), the sheet
name followed by an exclamation point
(!), and the cell address. In our example,
we'll type ='Menu Order'!E14.

5. Press Enter on your keyboard. The
value of the referenced cell will appear.
Now, if the value of cell E14 changes on
the Menu Order worksheet, it will be
updated automatically on the Catering
Invoice worksheet.

* If you rename your worksheet at a
later point, the cell reference will be
updated automatically to reflect the new worksheet name.

Functions

A function is a predefined formula that performs calculations using specific values in a
particular order. Excel includes many common functions that can be used to quickly
find the sum, average, count, maximum value, and minimum value for a range of cells.
In order to use functions correctly, you'll need to understand the different parts of a
function and how to create arguments to calculate values and cell references.

The parts of a function

In order to work correctly, a function
must be written a specific way, which is
called the syntax. The basic syntax for a
function is the equals sign (=), the
function name (SUM, for example), and
one or more arguments. Arguments
contain the information you want to
calculate. The function in the example
below would add the values of the cell
range A1:A20.

VISION MISSION
The leading center for academic and technological excellence Develop competent and morally upright professionals and generate
and prime catalyst for a progressive and sustainable Quirino appropriate knowledge and technologies to meet the needs of Quirino
Province and Southern Cagayan Valley. Province and Southern Cagayan Valley.

“Molding Minds, Shaping Future”