In which of the Excel Tabs you can find Slicer and Timeline options?

• a) Insert Tab

• b) View Tab

• c) Pivot Table Analyze Tab

• Both a) and b)

• Both a) and c)

What will Ctrl + 1 do?

• It will opens the Go to dialog box

• It will select the column range

• It will bold the selected range

• It will opens the format cells dialog box

Total number of columns in Excel worksheet?

• 16,284

• 16,385

• 16,384

• 17,384

Study the screenshot above. To find the price for the selected product (coffee in the example above), what formula would you type into the highlighted cell (B19)?

• =VLOOKUP(A19,A2:C16,C,FALSE)

• =VLOOKUP(A19,A2:C16,3,FALSE)

• =VLOOKUP(B19,A2:C16,3,FALSE)

• =VLOOKUP(A19,A2:C16,1,TRUE)

The intersection of row and column is called as

• Row

• Column

• range

• Cell

what does "#######" in excel?

• column has missing numbers

• column is not wide enough

• column is showing error

• None of the above

What will Ctrl + Shift + 3 do to a certain numerical range?

• It will apply the date format to that range

• It will apply the time format to that range

• it will apply the scientific format to that range

• It will apply the percentage format to that range

I want to add a Scroll bar and Spin button in excel dashboard. In which tab I can find these features?

• View Tab

• Data Tab

• Developer Tab

• Page layout Tab

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 a numerical representation of the letters at the top of a worksheet. For example, A = 1, B = 2, etc.

• This is the number of the column within the selected table_array where the lookup result is located.

• I don't Know

What is a Pivot Table?

• A table containing data that is organized horizontally.

• A table containing only black, grey and white formatting

• A table used to calculate financial pivot values.

• A tool used to summarize data.