WorksheetsLet's Play Excel Excel...!
Total questions: 15
Worksheet time: 12mins
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.
Short cut key for inserting Pivot Table
Alt + N + T
Alt + B + V
Alt + N + V
Ctrl + N + V
How will you able to add "Developer Tab" in excel ribbon?
Click on File Tab --> click on Options --> click on Advanced --> Developer Tab --> OK
File Tab --> Options --> Quick Access Tool Bar --> Developer Tab --> OK
File Tab --> Options --> Customize Ribbon --> Main Tabs --> Developer --> OK
File Tab --> Options --> Add-ins --> Developer Tab --> OK
When using VLookUp, use _______________ if you want to look for approximate matches rather than an exact match.
True
False
Which of these functions will you use if you wish to evaluate more than one condition?
IF()
IFELSE()
IFS()
IFELSES()
In the function =IF(SUM(B3:B6)>10, "Yes", "No"), which of the two functions will be evaluated first?
IF function
SUM function
