Weegy: here are many ways to share data between databases and spreadsheets. The most powerful way is to use ActiveX Data Objects and Visual Basic for Applications to program the exchange. [ Data transferred this way can be exchanged based on a schedule, it can be validated before the transfer is completed and it can ‘massaged’ by either the sending or receiving application ] (More)

Weegy: y using what-if analysis tools in Microsoft Office Excel, you can use several different sets of values in one or more formulas to explore all the various results. For example, [ you can do what-if analysis to build two budgets that each assumes a certain level of revenue. Or, you can specify a result that you want a formula to produce, and then determine what sets of values will produce that result. Excel provides several different ... (More)

Weegy: Microsoft Office Access and Microsoft Office Excel possess many similarities, which can make it difficult to decide which program you should use. [ For example, both programs can store large amounts of data, run powerful queries and analysis tools to slice and dice that data, and perform sophisticated calculations that return the data that you need. However, each program has clear advantages depending on the type of data that you are ... (More)

Weegy: To summarize and report results from separate worksheets, you can consolidate data from each separate worksheet into a master worksheet. The worksheets can be in the same workbook as the master worksheet or in other workbooks. [ When you consolidate data, you are assembling data so that you can more easily update and aggregate it on a regular or ad hoc basis. For example, if you have a worksheet of expense figures for each of your ... (More)

Weegy: Three kinds of what-if analysis tools come with Excel: scenarios, data tables, and Goal Seek. Scenarios and data tables take sets of input values and determine possible results. [ A data table works only with one or two variables, but it can accept many different values for those variables. A scenario can have multiple variables, but it can accommodate only up to 32 values. Goal Seek works differently from scenarios and data tables in ... (More)