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

Excel 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
AVERAGE functionA function that calculates the average from the adjacent cell through the first nonnumeric cell
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


NC

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