Which mode reduces power consumption by turning the monitor off?

The ________ functions provide added flexibility of multiple data ranges that can be located throughout an Excel spreadsheet

A) SUM and AVERAGE B) VLOOKUP and HLOOKUP C) IF and COUNTIF D) MATCH and INDEX

When the _________ keyword is left out, the database system automatically eliminates any duplicate rows.

a. DISTINCT b. ANY c. ALL d. EXCEPT