When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?

A. Cell references are not affected.
B. The user must insert new cell references.
C. The user is prompted to enter new cell references.
D. Cell references are automatically adjusted.


Answer: D

Computer Science & Information Technology

You might also like to view...

Forward and Back buttons work the same way as browser tabs.

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

Computer Science & Information Technology

Show the output of the following code

``` public class Test1 { public static void main(String[] args) { System.out.println(f2(2, 0)); } public static int f2(int n, int result) { if (n == 0) return 0; else return f2(n - 1, n + result); } } ``` a. 0 b. 1 c. 2 d. 3

Computer Science & Information Technology

This word describes a function that is updated each time the workbook is opened

A) Unstable B) Volatile C) Changeable

Computer Science & Information Technology

Each pie slice displayed on a pie chart is an example of a:

A) data marker. B) chart sheet. C) legend. D) data point.

Computer Science & Information Technology