Matching Pairs Spreadsheets KeywordsOnline version DESCRIPTIONS OF KEYWORDS by Jonathan Dunsby 1 BARCHART 2 WHATIF 3 PIECHART 4 CELLREFERENCE 5 FORMATTING 6 CELL 7 FORMULA 8 EQUALSIGN 9 LINEGRAPH 10 GRAPH 11 ROW 12 SCENARIO 13 FUNCTION 14 PREDICTION 15 COLUMN 16 VARIABLE 17 MODEL WAYS IN WHICH THE LOOK OR CONTENT OF THE CELL CAN BE CHANGED - HEIGHT, WIDTH, MERGE, BORDER, CURRENCY, NUMERIC, PERCENTAGE A SET OF VARIED VARIABLES USED TO LOOK AT A PARTICULAR CONTEXT - SO THAT PREDICTIONS AND DECISIONS CAN BE MADE. A COLLECTION OF CELLS - A LINE, WHICH GO ACROSS THE SPREADSHEET. A NUMERIC VALUE THAT CAN BE CHANGED OF A CHOICE THAT CAN BE MADE. E.G. 1-10 OR BLUE - GREEN - RED. A CONCLUSION MADE FOR THE FUTURE POSSIBILITY USING DATA/VARIABLES THAT HAS BEEN GATHERED/CHANGED IN SPECIFIC WAYS. PICTORIAL REPRESENTION OF DATA TO SHOW COMPARIONS OF VALUES OF DIFFERENT CATEGORIES OR GROUPS AND CHANGES OVER TIME. A PICTORIAL DATA REPRESENTATION OF PERCENTAGES A PICTORIAL REPRESENTATION TO SHOW CHANGES OF DATA OVER TIME. MORE COMPLEX FORMULAS WHICH ALLOWS YOU TO LOOK AT AVERAGES, MAX, MIN, GIVE STATEMENTS BASED ON DATA ETC. USES BRACKETS AND CELL REFERENCES. A PICTORIAL REPRESENTATION OF NUMERIC DATA. A SPREADSHEET USED TO MAKE PREDICTIONS, CHECK WHATIF SCENARIO BY CHANGING VARIABLES. USED IN FORMULAS AND FUNCTIONS SO THAT THE SPREADSHEET KNOWS WHERE THE DATA IS THAT NEEDS TO BE USED - EG. E17 THE BOXES WITHIN SPREADSHEETS IN WHICH YOU ENTER DATA, FORMULAS, FUNCTIONS, TEXT. USED TO PERFORM CALCULATIONS USING CELL REFERENCES AND RELATIVE MATHEMATICAL SYMBOLS - * / - +. START WITH AN EQUALS SIGN. USE OF SCENARIOS TO GIVE PREDICTIONS SO THAT CAN DECIDE IF SOMETHING IS A GOOD IDEA, POSSIBLE A COLLECTION OF CELLS - A LINE, WHICH GO DOWN THE SPREADSHEET. GOES AT THE BEGINNING OF A FORMULA AND FUNCTION.