If you see #NAME? in a cell, what does it refer to and how might it be avoided?

What will be an ideal response?


A cell with #NAME? means that you might have mistyped a function name. To avoid this, it is suggested that you select a function name from the Formula AutoComplete list as you type a function name or use the Insert Function dialog box.

Computer Science & Information Technology

You might also like to view...

To add or modify metadata, you can open the ____ dialog box from the File menu.

a. Update Metadata b. Mini Bridge c. File Properties d. File Info

Computer Science & Information Technology

The processing operation occurs any time the data, a change to a program, or the output is saved for future use.

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

Computer Science & Information Technology

In addition to the Zoom tool, you can use the ____ commands on the View menu.

A. Zoom Up and Zoom Down B. Enlarge and Reduce C. View More and View Less D. Zoom In and Zoom Out

Computer Science & Information Technology

For _________, the address field references a main memory address and the referenced register contains a positive displacement from that address.

A. indexing B. base-register addressing C. relative addressing D. all of the above

Computer Science & Information Technology