NEW
Font size
WorksheetsICHEME - Excel Workshop
Total questions: 10
Worksheet time: 5mins
You created the bar chart below. If you click "Switch Row/Column", what will happen?
The bar chart will transform into a column chart.
The columns will be plotted on the y-axis and rows plotted on the x-axis.
The rows will be switched with the columns.The values of the rows will be switched with the columns.
None of the above.
If you accidentally delete a sheet that you wanted to keep, which action should you take?
It’s over.
Choose Undo or click Ctrl+Z
Click the File tab and then select Restore Deleted Sheet
Retrieve the sheet from a saved version of the file.
An Excel workbook tracks the sales data for a company. A pivot table is in the adjacent tab and provides a high level view of the sales by department. The sales numbers are updated in the workbook, but the pivot table is not reflecting these changes. What is most likely causing this problem?
You need to create a new pivot table to reflect the changes
There is an error that is preventing the pivot table from updating
You need to refresh the pivot table directly to include the updated data
You need to refresh the tab with the raw data to reflect the new changes
Which of the formulae below contain the correct syntax (formula arguments) for the VLOOKUP function?
=VLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
=VLOOKUP(table_array, lookup_value, col_index_num, [range_lookup])
=VLOOKUP(lookup_value, table_array, col_index_num, value)
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
What dialog box allows you to change a field name in a Pivot table?
Field Options
Field Settings
Field Pane
Field Structure
How can we provide a dynamic range in ‘data source’ of pivot tables?
I. Create a named range using Offset function
II. Base the pivot table using the Named range created in Option A.
III. Both I and II
Which XLOOKUP formula is correct to find the name of the employee whose ID appears in cell E2?
Hint: The lookup value remains the same. The XLOOKUP splits the referenced ranges to a range to search and one to find the returned value
=XLOOKUP(E2,B:B,A:A)
=XLOOKUP(E2,A:A,B:B)
=XLOOKUP(B:B,A:A)
=XLOOKUP(B:B,A:A,E2)
Which areas would you place fields to represent the Pivot Table below?
Filters: Buyer & Amount; Columns: Amount; Rows: N/A; Values: N/A
Filters: N/A; Columns: Buyer; Rows: N/A; Values: Amount
Filters: N/A; Columns: N/A; Rows: Buyer; Values: Amount
Filters: N/A; Columns: Buyer & Amount; Rows: N/A; Values: N/A
Which areas would you place fields to represent the Pivot Table below?
Filters: Type; Columns: Amount; Rows: Buyer; Values: N/A
Filters: N/A; Columns: Type; Rows: Buyer; Values: Amount
Filters: N/A; Columns: N/A; Rows: Buyer & Type; Values: Amount
Filters: N/A; Columns: Buyer & Type; Rows: N/A; Values: Amount
Which is the correct formula for obtaining the value of the 'amount of apples'?
=VLOOKUP(A7, A2:B5, 2, TRUE)
=VLOOKUP(A2, B2:B5, 1, FALSE)
=VLOOKUP(A7, A2:B5, 1, FALSE)
=VLOOKUP(A7, A2:B5, 2, FALSE)
