None of the Above
Formula C:=FILTER(Items,Items[category]>>"SUN"

Which formula would provide a dynamic array showing all columns of the Items table where the Categor...
None of the Above
Formula C:=FILTER(Items,Items[category]>>"SUN"

Which formula would provide a dynamic array showing all columns of the Items table where the Categor...
Which formula would provide a dynamic array showing all columns of the Items table where the Category equals “SUN”?

A gas is found to have the formula (CO)n. Its vapour density is 70. What must the value of n be
5
10
7
1
3

The molecular formula of a compound in (CO)x and its vapour density is 70. Then the possible value o...
2
10
5
9

Which of the following is a chemical formula of quicklime
Ca2O
Ca2CO3
CaO2
CaO

Formula palette is used to
format cells containing numbers
create and edit formulas containing functions
entered assumptions data
copy all cells

3-D reference in a formula
Spans worksheets
Can not be modified
Only appears on summary worksheets
Limits the formatting options

With which of the following all formulas in excel starts
/
*
$
=

A value used in a formula that does not change is called a
constant
Cell address
Varaible
static

When you use multiplication, division or exponentiation in a formula then there is chance of occurri...
True
False

Except which of the following function, a formula with a logical function shows the word "TRUE" or "...
NOT
OR
IF
AND

Which one among the following formulates the fiscal policy in India
Planning Commission
Finance Commission
The Reserve Bank of India
Ministry of Finance

- Try Automation
- About
- Signup for Free