Home
Q&A
Education
Technology
Credit
General
Health
Insurance
Questions
Ask a Question
formula for finding number of cells that contains number data in the selected range of cells from A1 to A4.
Home
Education
formula for finding number of cells that contains...
asked
Dec 14, 2021
in
Education
by
JackTerrance
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
computer-science-interview-questions
computer-science-questions
1
Answer
0
votes
answered
Dec 14, 2021
by
JackTerrance
Best answer
Answer: =ROWS(B5:C10)*COLUMNS(B5:C10) // returns 12
Related questions
0
votes
Q: Cell A1 contain the number 20 and B1 contain 3. What will be the content of cell C1, if the formula = A1 + B1 * 2^3 is entered in cell C1?
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
computer-science-interview-questions
computer-science-questions
0
votes
Q: The formula in cell A2 is B2+C2. If we copy this formula to cell A4, what will be the new formula?
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
computer-science-interview-questions
computer-science-questions
0
votes
Q: Cell D1 in a worksheet containsthe formula =A1*(B1+C1). Oncopying this formula to cell D2,
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
computer-science-interview-questions
computer-science-questions
0
votes
Q: helps to answerthese questions by making g iteasy to highlight interestingcells or range of cells. *Auto fill
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
computer-science-interview-questions
computer-science-questions
0
votes
Q: a.b.Any formula in Excel startssaluctangulshows the formula used in the selected cell.A formula which is used to perform mathematical calculation is calledformaC.
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
computer-science-interview-questions
computer-science-questions
0
votes
Q: Cell D3 contains the formula =B3+C3 and this formula is copied to cell E4
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
computer-science-interview-questions
computer-science-questions
0
votes
Q: The mathematics teacher has asked the monitor to create a worksheet that will calculate the simple interest for the principle amount ranging from 1000 to 8000. The interest rate and time are given in cells C1 and D1 respectively. Can you help the monitor in his task? How should he proceed
The mathematics teacher has asked the monitor to create a worksheet that will calculate the simple interest for the ... he proceed Select the correct answer from above options...
asked
Nov 27, 2021
in
Education
by
JackTerrance
computer-science-interview-questions
computer-science-questions
0
votes
Q: (a)Utility(b) Operating system(c) Both7.The horizontal line of boxes is called a(a) Column(b) Cell(c) Row8.An application software that can be used for different types of general andcommon tasks:(a) System software(b) Special purpose software(c) General purpose software9.The second generation computers used(a)Vacuum tube(b) Integrated circuit(c) Transistor10.Formula option is displayed undertab(a) Layout(b) Data(c) Table
(a)Utility (b) Operating system (c) Both 7. The horizontal line of boxes is called a (a) Column (b) Cell (c) ... (c) Table Section - B Select the correct answer from above options...
asked
Dec 5, 2021
in
Education
by
JackTerrance
computer-science-interview-questions
computer-science-questions
0
votes
Q: Finding covariance matrix in steps from the given below data.ABC =Math Physics English90 80 4090 60 8060 50 7030 40 70
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
computer-science-interview-questions
computer-science-questions
0
votes
Q: Which button places the contents in the centre of the cells across a number of columns
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
computer-science-interview-questions
computer-science-questions
0
votes
Q: in split cell window we can specify the number of(i) Rows and cells(ii) Rows and Columns(iii) Columns and Cells
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
computer-science-interview-questions
computer-science-questions
0
votes
Q: in split cell window we can specify the number of(i) Rows and cells(ii) Rows and Columns(iii) Columns and Cells
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
computer-science-interview-questions
computer-science-questions
0
votes
Q: in split cell window we can specify the number of(i) Rows and cells(ii) Rows and Columns(iii) Columns and Cells
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
computer-science-interview-questions
computer-science-questions
0
votes
Q: A __________is a grouping of cells that run from the left to right of a page.
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
computer-science-interview-questions
computer-science-questions
0
votes
Q: For the following data, what formula is to be used to add first name & Surname
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
computer-science-interview-questions
computer-science-questions
...