Relacionar Columnas Spreadsheets KeywordsVersión en línea DESCRIPTIONS OF KEYWORDS por Jonathan Dunsby 1 BARCHART 2 MODEL 3 FORMATTING 4 EQUALSIGN 5 VARIABLE 6 COLUMN 7 SCENARIO 8 CELL 9 PIECHART 10 GRAPH 11 WHATIF 12 FUNCTION 13 ROW 14 CELLREFERENCE 15 PREDICTION 16 FORMULA 17 LINEGRAPH WAYS IN WHICH THE LOOK OR CONTENT OF THE CELL CAN BE CHANGED - HEIGHT, WIDTH, MERGE, BORDER, CURRENCY, NUMERIC, PERCENTAGE A PICTORIAL DATA REPRESENTATION OF PERCENTAGES PICTORIAL REPRESENTION OF DATA TO SHOW COMPARIONS OF VALUES OF DIFFERENT CATEGORIES OR GROUPS AND CHANGES OVER TIME. 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. A SPREADSHEET USED TO MAKE PREDICTIONS, CHECK WHATIF SCENARIO BY CHANGING VARIABLES. MORE COMPLEX FORMULAS WHICH ALLOWS YOU TO LOOK AT AVERAGES, MAX, MIN, GIVE STATEMENTS BASED ON DATA ETC. USES BRACKETS AND CELL REFERENCES. A COLLECTION OF CELLS - A LINE, WHICH GO ACROSS THE SPREADSHEET. A PICTORIAL REPRESENTATION TO SHOW CHANGES OF DATA OVER TIME. 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 DOWN THE SPREADSHEET. GOES AT THE BEGINNING OF A FORMULA AND FUNCTION. A NUMERIC VALUE THAT CAN BE CHANGED OF A CHOICE THAT CAN BE MADE. E.G. 1-10 OR BLUE - GREEN - RED. USE OF SCENARIOS TO GIVE PREDICTIONS SO THAT CAN DECIDE IF SOMETHING IS A GOOD IDEA, POSSIBLE USED IN FORMULAS AND FUNCTIONS SO THAT THE SPREADSHEET KNOWS WHERE THE DATA IS THAT NEEDS TO BE USED - EG. E17 A PICTORIAL REPRESENTATION OF NUMERIC DATA. A CONCLUSION MADE FOR THE FUTURE POSSIBILITY USING DATA/VARIABLES THAT HAS BEEN GATHERED/CHANGED IN SPECIFIC WAYS.
Crear