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