Match the following terms to their meanings:

I. Data validation rule
II. Error alert
III. Macro
IV. Protect sheet
V. Shared workbook

A. Data validation message indicating that invalid data has been entered
B. Places a restriction on the types of data that can be entered into cells
C. Stored set of instructions to automate a task
D. Prevents unauthorized users from making changes to a worksheet
E. Workbook in which multiple users can make changes at the same time


Answer: B, A, C, D, E

Computer Science & Information Technology

You might also like to view...

Explain how the Transport layer uses several reliability measures.

What will be an ideal response?

Computer Science & Information Technology

The ____________________ shows available calendars and the various categories available for each calendar.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

The DISTINCT operator is useful when used in conjunction with the COUNT function.

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

Computer Science & Information Technology

The numeric ________ area of a keyboard is very useful for numeric entry and calculations, as it contains the numbers 0 - 9 and four basic mathematical operators.

A. cursor B. keypad C. function D. modifier

Computer Science & Information Technology