Multiple Choice
Which of the following is true about constructing PivotTables?
A) It is not possible to construct the PivotTable in the same worksheet.
B) Dragging a field into the Report Filter area allows addition of a third dimension to the analysis.
C) Placing a field each in the row and column labels will automatically sum the variable values in the table.
D) PivotTables cannot be duplicated by copying and pasting an existing table.
Correct Answer:
Verified
Correct Answer:
Verified
Q2: Give the logical function for the following:
Q3: Explain the different Lookup functions in Excel.
Q4: Use the data given below to
Q5: To use the VLOOKUPlookup_value, table_array, col_index_num), the
Q6: ANDcondition 1, condition 2…) is a logical
Q7: In a database file, which is organized
Q8: In a MATCH function, if the match_type
Q9: In a MATCH function, if match_type =
Q10: is a logical function that returns one
Q11: Use the data given below to