If you want to summarize data from multiple places and want to use formulas with cell references or 3-D references to the other worksheets that you are combining because you do not have a consistent position or category of data to use, you would use the ________ option

Which is the primary advantage of creating a new query based on an existing query?

A) It saves time if your new query uses the same fields as the existing query. B) It takes up less disk space to save an existing query with a new name. C) Because the new query is based on an existing query, both can share the same primary key. D) An additional subset of records is added to the database, increasing flexibility.

Name the three crucial steps that must occur in every loop.

What will be an ideal response?