Shared Flashcard Set

Details

Excel part 2
Terms
31
Business
12th Grade
01/26/2010

Additional Business Flashcards

 


 

Cards

Term
SELECT ENTIRE COLUMN
Definition
CTRL PLUS SPACEBAR
Term
SELECT ENTIRE ROW
Definition
SHIFT PLUS SPACEBAR
Term
SELECT ENTIRE WORKBOOK
Definition
CTRL PLUS A
Term
LIVE PREVIEW
Definition
ALLOWS YOU TO SEE HOW TEH STYLE FORMATTING AFFECTS CELLS IN YOUR WORKSHEET.
Term
DEFAULTS
Definition
THE STANDARD SETTINGS EXCEL USES IN ITS SOFTWARE, SUCH AS COLUMN WIDTH OR NUMBER OF WORKSHEETS IN A WORKBOOK.
Term
LABEL
Definition
TEXT IN THE FIRST ROW OR COLUMN OF A WORKSHEET THAT IDENTIFIES THE TYPE OF DATA CONTAINED THERE.
Term
VALUE
Definition
A NUMBER ENTRED IN THE WORKSHEET.
Term
NUMERIC LABEL
Definition
A NUMBER ENTERED IN THE WORKSHEET AS A LABEL, NOT AS A VALUE-SUCH AS THE YEAR 2005 USED AS A COLUMN LABEL.
Term
LABEL PREFIX
Definition
AN APOSTROPHE(') USED TO INDICATE THAT A NUMBER IS A LABEL AND NOT A VALUE.
Term
SERIES
Definition
A LIST OF SEQUENTIAL NUMBERS, DATES, TIMES, OR TEXT.
Term
STANDARD COLUMN WIDTH
Definition
THE DEFAULT NUMBER OF CHARACTERS THAT DISPLAY IN A COLUMN BASED ON THE DEFAULT FONT.
Term
RANGE
Definition
A BLOCK OF CELLS IN AN EXCEL WORKSHEET
Term
CONTIGUOUS RANGE
Definition
A BLOCK OF ADJACENT CELLS IN A WORKSHEET.
Term
NONCONTIGUOUS RANGE
Definition
CELLS IN A WORKSHEET THAT ACT AS A BLOCK, BUT ARE NOT NECESSARILY ADJACENT TO EACH OTHER.
Term
FILL
Definition
A COLOR THAT FILLS A CELL, APPEARING BEHIND THE DATA.
Term
THEME
Definition
A COLLECTION OF COORDINATED FONTS, COLORS, AND EFFECTS FOR GRAPHIC ELEMENTS SUCH AS CHARTS AND IMAGES THAT CAN BE QUICKLY APPLIED TO ALL SHEETS IN A WORKBOOK
Term
NUMBER FORMAT
Definition
A FORMAT THAT CONTROLS HOW NUMERICAL DATA IS DISPLAYED, INCLUDING THE USE OF COMMAS, DOLLAR SIGNS(OR OTHER SYMBOLS), AND THE NUMBER OF DECIMAL PLACES.
Term
ACCOUNTING FORMAT
Definition
A STYLE THAT VERTICALLY ALIGNS WITH DOLLAR SIGNS($), THOUSANDS SEPERATORS(,) AND DECIMAL POINTS.
Term
DRAG AND DROP FEATURE
Definition
A METHOD USED TO MOVE OR COPY THE CONTENTS OF A RANGE OF CELLS BY DRAGGING THE BORDER OF A SELECTION FROM ONE LOCATION IN A WORKSHEET AND DROPPING IT IN ANOTHER LOCATION.
Term
GROUPING
Definition
WORKSHEETS THAT ARE SELECTED AS A UNIT, ANY ACTION PERFORMED ON THIS UNIT WILL AFFECT ALL THE WORKSHEETS IN A GROUP
Term
ACTIVE SHEET
Definition
THE SELECTED WORKSHEET; THE TAB NAME OF AN ACTIVE SHEET IS BOLD.
Term
FUNCTION
Definition
A PREDEFINED FORMULA THAT USES THE VALUES IN THE CELLS YOU SELECT TO CALCULATE THE ANSWER.
Term
FUNCTION NAME
Definition
THE NAME GIVEN TO ONE OF EXCEL'S PREDEFINED FORMULAS.
Term
ARGUMENT
Definition
THE PARTS OF A FORMULA THAT ARE VARIABLE.  YOU SELECT THE CELL/CELLS FOR EACH ARGUMENT; AND EXCEL CALCULATES THE ANSWERS BASED ON TEHIR VALUES.
Term
NEST
Definition
TO USE A FUNCTION AS AN ARGUMENT WITHIN ANOTHER FUNCTION
Term
FORMULA AUTOCOMPLETE
Definition
A FEATURE THAT SPEEDS UP THE MANUAL ENTRY FUNCTIONS.
Term
AUTO CALCULATE
Definition
A FEATURE THAT TEMPORARILY PERFORMS THE FOLLOWING CALCULATIONS ON A RANGE OF CELLS WITHOUT MAKING YOU WRITE A FORMULA; AVERAGE, COUNT, COUNTA, MAX, MIN, AND SUM.
Term
COMMENT
Definition
A TEXT NOTE ATTACHED TO A WORKSHEET CELL
Term
RANGE NAME
Definition
AN IDENTIFICATION LABEL ASSIGNED TO A GROUP OF CELLS.
Term
EXPRESSION
Definition
A SORT OF EQUATION SUCH AS B6>25) THAT RETURNS A VALUE; SUCH AS TRUE / FALSE.
Term
ARGUMENT
Definition
A VARIABLE USED IN A FUNCTION.  IT CAN BE A NUMBER, TEXTS, FORMULA, OR A CELL REFERENCE, A COMMA SEPERATES EACH ARGUMENT IN A FUNCTION.
Supporting users have an ad free experience!