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

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


A

Computer Science & Information Technology

You might also like to view...

Write a DTD for an XML document that stores company profiles. Each company is represented by a company element. Profiles must contain a name element and a tour element. Element tour points to a .jpg image or to an HTML page that relates to the company. Element tour should specify the type of image or document to which it points. [Note: The type of image should be specified by a NOTATION type attribute.]. Also write an XML document and validate it against this DTD.

What will be an ideal response?

Computer Science & Information Technology

OneNote Online is Microsoft's cloud storage tool associated with your Microsoft account

Indicate whether the statement is true or false

Computer Science & Information Technology

Which of the following is the name for running the processor or memory at speeds faster than what is recommended?

a. CPU tweaking b. Overclocking c. Memory leak d. CPU duplicating

Computer Science & Information Technology

Java uses a technique called mixed-mode to convert one data type to another in arithmetic expressions.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology