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
Answer: D
You might also like to view...
What is a functional interface?
What will be an ideal response?
Design or modify the OUTSTANDING COMPUTER PURCHASE ORDERS REPORT. Refer to the repository entry for the data flow for the elements. This report would be produced for all PURCHASE ORDER records that have a purchase order code of M101, representing computers, with the additional condition that the QUANTITY ORDERED on the record must be greater than the QUANTITY RECEIVED. In a paragraph, state whether this report is a summary, exception, or detailed report. Explain.
What will be an ideal response?
COGNITIVE ASSESSMENT Which of the following has a port to which a cable connects in order to coordinate the transmission and receipt of data, instructions, and information to and from the computer or device containing it?
A. router B. transmitter C. network interface card D. connector
Each case clause within a switch statement contains a value followed by which punctuation mark?
A. comma B. colon C. period D. semicolon