1.) Lookup functions allow spreadsheet users to:
a - show quantities of distinct, discrete categories of data.
b - present data that changes as a function of time.
c - keep track of IF statements and nested IF statements.
d - reduce the amount of manual searching and data entry.

2.) Which of the following statements best describes cell protection when it is first activated?
a - By default, cells are locked and not hidden.
b - The contents of an unlocked cell cannot be modified.
c - Cell protection is guaranteed.
d - Only cells in even-numbered columns can be protected.

3.) What are the two parts of a cell reference:
a - column intersection and row range
b - column range and row intersection
c - column letter and row number
d - column number and row letter

1-D by having a search selection, it greatly reduces the amount of search time for the user
2-B
3-D the column are labeled with numbers are the are positioned vertical
rows are labeled with letters they r positioned horizontally

Answer Link

andriansp andriansp · Answer 2 · 2019-01-30T12:22:03+01:00

1. d - reduce the amount of manual searching and data entry.

The lookup function allow the users to automatically search the type of information that they want by giving appropriate criteria in the formula. When reading data from a table, lookup function is divided into Vlookup and Hlookup. Vlookup is used to read the data from a table vertically and Hlookup is used to read the data from a table horizontally.

2. b - The contents of an unlocked cell cannot be modified.

Because of this feature, cell protection can be used to share the file with other users without giving them a chance to edit a certain cells. This help the original owners in limiting the things that non-authorized person can do to the file.

3. c. column letter and row number

Column letter is written from left to right and row number is written from top to bottom. The combination of a column letter and row number is called a cell reference. This cell reference is often used when writing formulas for the excel file.