What are the benefits of using 3-D formulas?

What will be an ideal response?


3-D formulas give the user the ability to perform basic aggregate calculation to the same cell across multiple workbooks while reducing the size of the required function. For example the function =SUM(QTR1!E3, QTR2!E3, QTR3!E3, QTR4!E3 ) would be replaced with =SUM('Qtr1:Qtr4'!E3).

Computer Science & Information Technology

You might also like to view...

The ____ variable is initialized before entering the loop.

A. loop-ending B. ending control C. interrupt control D. loop control

Computer Science & Information Technology

Which Windows Server 2016 installation option has a small footprint and does not support a local logon?

A. Nano Server B. Server Core C. Foundation Server D. Windows Containers

Computer Science & Information Technology

Which of the following connectors would Karen, a technician, use only for RG-6 cables?

A) RJ-45 B) MTRJ C) RS-232 D) F-connector

Computer Science & Information Technology

Once text is flowed into an object, you can no longer manipulate the object as you would have previously.

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

Computer Science & Information Technology