Java Games: Flashcards, matching, concentration, and word search.

02 EXCEL Lesson 4 Entering Worksheet Formulas

AB
formulaEquation used to calculate values in a cell
operandnumber in cell
operatorsymbol of mathematical operation like +,-, *, /
order of operationsmathematical operations must be done in a certain order to get the correct answer
relative cell referenceshift depending on location
absolute cell referenceremain unchanged in new location of copied formula
Sum ButtonButton on Home tab of ribbon used to calculate quickly
MAXmaximum (the most)
MINminimum (the least)
preview calculationsresults of calculation are shown on status bar


Instructor
City College of San Francisco
San Francisco, CA

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities