Answer:
A. VLOOKUP
Explanation:
VLOOKUP is an Excel function to look up data in a table organized vertically. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. Lookup values must appear in the first column of the table passed into VLOOKUP.
Purpose
Lookup a value in a table by matching on the first column
Return value
The matched value from a table.
Syntax
=VLOOKUP (value, table, col_index, [range_lookup])
Arguments
value - The value to look for in the first column of a table.
table - The table from which to retrieve a value.
col_index - The column in the table from which to retrieve a value.
range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.
Answer:
1. Open the form in the standard form view.
2. Put the cursor in the field to use for sorting.
3. Open the Home tab
4. In the Sort & Filter group, click ascending or descending
Explanation:
Took the test :)
Answer:
D: 97
Explanation:
i watched this movie 3 times