Explain "Multiple Operation" with suitable example
CBSE, JEE, NEET, CUET
Question Bank, Mock Tests, Exam Papers
NCERT Solutions, Sample Papers, Notes, Videos
Posted by Manas Ranjan 3 years, 9 months ago
- 2 answers
Yogita Ingle 3 years, 9 months ago
Multiple operation combines a series of formulas with a variable and a series of values. The results of each formula with each value is shown in the table. Additionally, it is possible to calculate a single formula with two variables using a 2-value series. The method set Table Operation() of the interface [IDL:com.sun.star.sheet. XMultiple Operation] inserts a multiple operation range.
The following example shows how to calculate the values 1 to 5 raised to the powers of 1 to 5 (each value to each power). The first column contains the base values, and the first row the exponents, for example, cell E3 contains the result of 24. Below there are three trigonometrical functions calculated based on a series of values, for example, cell C11 contains the result of cos(0.2).
Note that the value series have to be included in the multiple operations cell range, but not the formula cell range (in the second example). The references in the formulas address any cell outside of the area to be filled. The column cell and row cell parameter have to reference these cells exactly. In the second example, a row cell address does not have to be used, because the row contains the formulas.
Related Questions
Posted by Chandan Kedia 2 months, 2 weeks ago
- 0 answers
Posted by Hardika . 2 months, 2 weeks ago
- 0 answers
Posted by Manyata Mishra 2 months, 2 weeks ago
- 0 answers
Posted by Jatin Jaat 2 months, 1 week ago
- 0 answers
Posted by Sudharshini Kanthasamy 2 months ago
- 1 answers
Posted by Ritik Sirohi 2 months, 2 weeks ago
- 0 answers
Posted by Pavi S 2 months, 1 week ago
- 0 answers
Posted by Account Deleted 2 months, 1 week ago
- 0 answers
Posted by Ayushi Singh 2 months, 1 week ago
- 0 answers
myCBSEguide
Trusted by 1 Crore+ Students
Test Generator
Create papers online. It's FREE.
CUET Mock Tests
75,000+ questions to practice only on myCBSEguide app
Sniper Killer 3 years, 9 months ago
0Thank You