NEW
Font size
WorksheetsExcel Quiz 919
Total questions: 12
Worksheet time: 8mins
what does "#######" in excel?
Excel mein "#######" ka matlab kya hota hai?
column has missing numbers
column is not wide enough
column is showing error
None of the above
In a VLOOKUP formula, what does the argument column_index_number mean?
VLOOKUP formula में, argument column_index_number का क्या मतलब होता है?
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
How will you able to add "Developer Tab" in excel ribbon?
Excel ribbon mein "Developer Tab" ko kaise jodenge?
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.
VLOOKUP ka use karte time, yadi aap exact match ki jagah approximate match dhundna chahte hai to _______________ ka use krein
True
False
In the function =IF(SUM(B3:B6)>10, "Yes", "No"), which of the two functions will be evaluated first?
=IF(SUM(B3:B6)>10, "Yes", "No"), is function me do function hai to pehle konsa function eveluate hoga
IF function
SUM function
Identify the formula for
INDEX
=INDEX(array, row_num, [column_num])
=INDEX(row_num, array, [column_num])
=INDEX( [column_num], row_num, array)
=INDEX(array, [column_num], row_num)
Identify the Short Cut Key for fixing values (C4 --> $C$4)
C4 ko $C$4 bnane ke liye konsi shortcut key use hogi
F1
F2
F3
F4
Formulas can be copied to adjacent cells with the ____________.
______ ki madad se aap formula ko adjacent cell me copy kr skte hai
Fill handle
PgDn Key
Function key F4
None of the above
A _________ is a prewritten formula that is built into EXCEL.
________ ek pehle se bna hua formula hai jo excel me pehle se bna hua hai.
function
problem
equation
equal sign
to count any fields containing numbers we use:
jin cells me sirf numbers hai unhe ginne ke liye konsa function use hota hai
countIF function
counta function
count function
countIFs function
A company needs to highlight with red the salaries more than 8000
Ek company ko excell sheet me un cells ko red colour se highlight krna hai jaha salary ke column me cell values 8000 se jyada hai.
it should use the bucket filler
it should use the highlighter
it should use the conditional formatting
it uses the (A) button on top of the home tab
if statement structure is:
IF function ko likhne ka sahi tareeka hai:
if(value-if-true,logical-test,value-if-false)
if(logical-test,value-if-false-value-if-true)
if(logical-test,value-if-true,value-if-false)
