A BUTTON THAT QUICKLY INSERTS EXCEL FUNCTIONS THAT SUMMARIZE ALL THE VALUES IN A COLUMN OR ROW, USING A SINGLE STATISTIC.
What is:
AutoSum
100
THE ADDRESS OF A CELL, INDICATING ITS COLUMN AND ROW LOCATION.
What is:
CELL REFERENCE
100
IN EXCEL, THE PART OF THE WORKSHEET THAT IDENTIFIES EACH COLUMN BY A DIFFERENT LETTER.
What is:
COLUMN HEADING
100
A VALUE IN A RECOGNIZED DATE FORMAT.
What is:
DATE DATA
200
TO MOVE AN ITEM BY SELECTING IT; AND, THEN DRAGGING IT WITH THE MOUSE.
What is:
DRAG AND DROP
200
THE BAR LOCATED ABOVE THE WORKBOOK WINDOW IN WHICH THE CONTENTS OF A CELL ARE DISPLAYED.
What is:
FORMULA BAR
200
THE BOX LOCATED IN THE FAR LEFT OF THE FORMULA BAR IN WHICH THE CELL REFERENCE TO THE ACTIVE CELL IS ALSO DISPLAYED.
What is:
NAME BOX
200
THE UNIT USED TO MEASURE THE SIZE OF THE CHARACTER IN A FONT.
What is:
POINT
200
A FEATURE THAT CHECKS THE WORDS IN A DOCUMENT AGAINST THE PROGRAM'S BUILT-IN DICTIONARY AND HELPS YOU AVOID TYPOGRAPHICAL ERRORS.
What is:
SPELLING CHECKER
300
A MODE IN WHICH YOU CAN EDIT PART OF AN ENTRY RATHER THAN THE ENTIRE CONTENTS OF A CELL.
What is:
EDITING MODE
300
EXCEL VIEW IN WHICH CELL FORMULAS ARE DISPLAYED, RATHER THAN THE VALUES RETURNED BY THE FORMULAS.
What is:
FORMULA VIEW
300
A SET OF PREDETERMINED RULES THAT EXCEL FOLLOWS UNAMBIGULOUSLY CALCULATE A FORMULA BY DETERMINING WHICH OPERATOR IS APPLIED FIRST; WHICH OPERATOR IS APPLIED SECOND; ETC..
What is:
ORDER OF PRECEDENCE
300
A TYPE OF PAGE ORIENTATION IN WHICH THE PAGE IS TALLER THAN IT IS WIDE.
What is:
PORTRAIT ORIENTATION
300
A TOOL USED IN BUSINESS FOR BUDGETING, INVENTORY MANAGEMENT, AND DECISION MAKING FOR ANALYZING AND REPORTING INFORMATION.
What is:
SPREADSHEET
400
THE COMMAND TO LOCATE SPECIFIC LETTERS AND NUMBERS IN A WORKBOOK.
What is:
FIND
400
A PREDETERMINED FORMULA THAT PERFORMS CALCULATIONS USING SPECIFIC VALUES CALLED ARGUMENTS.
What is:
FUNCTION
400
IN EXCEL, A VIEW THAT SHOWS HOW THE WORKSHEET WILL BE LAID OUT ON THE PAGES SENT TO THE PRINTER.
What is:
PAGE LAYOUT VIEW
400
A GROUP OF WORKSHEET CELLS, WHICH CAN BE ADJACENT, OR NONADJACEN.
What is:
RANGE (or CELL RANGE)
400
TO CUT OFF, OR HIDE, THE PART OF AN ENTRY THAT DOES NOT FIT IN A CELL.
What is:
TRUNCATE
500
A MATHEMATICAL EXPRESSION THAT CALCULATES A VALUE; IT ALWAYS BEGIN WITH AN = SIGN, FOLLOWED BY AN EXPRESSION THAT DESCRIBES THE CALCULATION TO BE DONE.
What is:
FORMULA
500
A TYPE OF PAGE ORIENTATION IN WHICH THE PAGE IS WIDER THAN IT IS TALL.
What is:
LANDSCAPE ORIENTATION
500
A WORKSHEET THAT INCLUDES QUESTIONS TO HELP YOU DEFINE THE PURPOSE AND OBJECTIVES OF A WORKBOOK.
What is:
PLANNING ANALYSIS SHEET
500
THE AREA AT THE BOTTOM OF A WORKSHEET THAT IDENTIFIES THE WORKSHEET.
What is:
SHEET TAB
500
AN APPROACH USING AN ELECTRONIC SPREADSHEET IN WHICH YOU CHANGE ONE OR MORE OF THE VALUES IN THE WORKSHEET; AND, THEN EXAMINE THE RECALCULATED VALUES TO DETERMINE THE EFFECT OF THE CHANGE.