If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.

A. #NULL!
B. #DIV/0!
C. #N/A
D. #REF!


Answer: D

Computer Science & Information Technology

You might also like to view...

The Access database object, ________, displays a subset of the data in response to a specific question

A) query B) macro C) table D) form

Computer Science & Information Technology

In adding a code snippet, if you right-click outside the desired location for your code, the shortcut menu might list choices that are customized to that area of code and not include the code snippet for which you were searching.

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

Computer Science & Information Technology

________ is the standard character set on the Internet and includes codes for most of the world's written languages

Fill in the blank(s) with correct word

Computer Science & Information Technology

If you want to turn off grand totals for columns on a PivotTable, select this option in the Grand Totals options

A) On for Columns Only B) Off for Rows and Columns C) On for Rows Only D) On for Rows and Columns

Computer Science & Information Technology