Which Excel function totals only the cells in a range that meet given criteria?

The user reports when a laptop's power button is pushed there is no response. The FIRST step to address the issue would be which of the following?

A. Reseat the memory B. Plug in the external power supply C. Replace the battery D. Close the lid and reopen it

Which of the following allow users to arrange data in any way they choose?

A) pivot tables B) parameter queries C) natural language queries D) indirect manipulation interface