Font size
WorksheetsUSE EXCEL LIKE A PRO
Total questions: 8
Worksheet time: 5mins
Key-in (a) (symbol) to start create a formula
All the descriptions are correct about sorting function, except:
Sorting function able to hide data as well as can sort
Sorting function applies for alphabetical and numerical
Sorting function can handle multiple criteria
The arrangement of data in Z to A will arrange the data in __________ order.
Ascending
Descending
Which of the formulas below contain the correct syntax (formula arguments) for the VLOOKUP function?
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
=VLOOKUP(table_array, lookup_value, col_index_num, range_lookup)
=VLOOKUP(lookup_value, table_array, col_index_num, value)
What is a Pivot Table?
A table containing data that is organized horizontally.
A table used to calculate financial pivot values.
A tool used to summarize data.
A table containing only black, grey and white formatting
In a VLOOKUP formula, what does the argument column_index_number mean?
This is the secret INDEX number that each column in an Excel worksheet has.
This is the number of the column within the selected table_array where the lookup result is located.
This is a numerical representation of the letters at the top of a worksheet. For example, A = 1, B = 2, etc.
How many types of analytics?
7
6
5
4
Prescriptive Analytics is focusing on forecast future decision from predictive model (trends, historical data)
Yes
No
