What is the result of creating worksheets that cache results?

• A. Data displayed is always real-time
• B. Data is calculated once and saved for future access
• C. Users can modify the cache anytime
• D. Format settings are not required

Answer: (B)

Creating worksheets that cache results means that the data within those worksheets is computed once and then stored for future reference. This caching process allows for faster access to this data, as it doesn’t require recalculation every time it is needed. This is especially beneficial in scenarios where complex computations could take a substantial amount of time; by caching the results, subsequent accesses can deliver immediate output without the overhead of recalculating.

The other options do not accurately represent the implications of caching results in worksheets. For instance, real-time data display would require constant recalculation and connectivity to live data sources, which contradicts the nature of caching. Additionally, caching does not permit users to modify the cached data directly; they would typically need to update or refresh the source data to change what's cached. Lastly, while format settings are unrelated to the caching functionality, they do play a role in how data is presented in worksheets, which is a separate concern from the caching process itself.