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

MOAC Excel 2013: Lesson 5 - Vocabulary

AB
ArgumentThe parameters of a function.
AutoSumA formula that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function in its formula.
AVERAGE functionA function that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function in its formula.
COUNT functionA function that determines how many cells in a range contain a number.
COUNTA functionA function that returns the number of cells in the selected range that contain text or values, but not blank cells.
FunctionA predefined formula that performs a calculation.
MAX functionA function that returns the largest value in a set of values.
Merged cellsTwo or more cells combined into a single cell.
MIN functionA function that determines the minimum value in a range of cells.
NOW functionA function that returns today's date and the current time, in the default format of mm/dd/yyyy hh:mm.
PMT functionA function that requires a series of inputs regarding interest rate, loan amount (principal), and loan duration, and then calculates the resulting loan payment.
SUBTOTAL functionA function that returns a subtotal for a list.
SUM functionA function that totals all of the cells in a range.
TODAY functionA function that returns the current date in a worksheet.
Trace arrowAn arrow that shows the relationship between formulas and the cells they refer to in order to resolve a formula error.



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