in Education by
formula for finding number of cells that contains number data in the selected range of cells from A1 to A4. please dont spam Select the correct answer from above options

1 Answer

0 votes
by
 
Best answer
Answer: =ROWS(B5:C10)*COLUMNS(B5:C10) // returns 12

Related questions

0 votes
    Cell A1 contain the number 20 and B1 contain 3. What will be the content of cell C1, if the formula = A1 + ... is entered in cell C1? Select the correct answer from above options...
asked Nov 29, 2021 in Education by JackTerrance
0 votes
    The formula in cell A2 is B2+C2. If we copy this formula to cell A4, what will be the new formula? Select the correct answer from above options...
asked Dec 25, 2021 in Education by JackTerrance
0 votes
    Cell D1 in a worksheet contains the formula = A 1*(B1+C1). On copying this formula to cell D2, the formula will be: Select the correct answer from above options...
asked Dec 19, 2021 in Education by JackTerrance
0 votes
    helps to answer these questions by making g it easy to highlight interesting cells or range of cells. * Auto fill Auto correct Select the correct answer from above options...
asked Dec 25, 2021 in Education by JackTerrance
0 votes
    a. b. Any formula in Excel starts saluctangulshows the formula used in the selected cell. A formula which is ... forma C. onerator Select the correct answer from above options...
asked Dec 14, 2021 in Education by JackTerrance
0 votes
    Cell D3 contains the formula = B3+C 3 and this formula is copied to cell E4 what will be the copied formula in cell E4? Select the correct answer from above options...
asked Dec 31, 2021 in Education by JackTerrance
0 votes
    Finding covariance matrix in steps from the given below data. ABC = Math Physics English 90 80 40 90 60 80 60 50 70 30 40 70 30 20 90 Select the correct answer from above options...
asked Nov 28, 2021 in Education by JackTerrance
0 votes
    Which button places the contents in the centre of the cells across a number of columns Select the correct answer from above options...
asked Dec 30, 2021 in Education by JackTerrance
0 votes
    in split cell window we can specify the number of (i) Rows and cells (ii) Rows and Columns (iii) Columns and ... (iv) Tables and Cells Select the correct answer from above options...
asked Dec 5, 2021 in Education by JackTerrance
0 votes
    in split cell window we can specify the number of (i) Rows and cells (ii) Rows and Columns (iii) Columns and ... (iv) Tables and Cells Select the correct answer from above options...
asked Nov 26, 2021 in Education by JackTerrance
0 votes
    in split cell window we can specify the number of (i) Rows and cells (ii) Rows and Columns (iii) Columns and ... (iv) Tables and Cells Select the correct answer from above options...
asked Nov 25, 2021 in Education by JackTerrance
0 votes
    A __________is a grouping of cells that run from the left to right of a page. Select the correct answer from above options...
asked Dec 1, 2021 in Education by JackTerrance
0 votes
    For the following data, what formula is to be used to add first name & Surname Select the correct answer from above options...
asked Dec 1, 2021 in Education by JackTerrance
...