Question
Which of the given options best describes the truth of
the following statements? i) If the values in cells A15, A16 are 3, 5 respectively, and formula = A15^A16 is entered in cell A17, then the value of the cell will be 243. ii) Function MATCH() of MS-Excel365 is used to search the specified item in a range of cells, and then returns the relative position of that item in the range. iii) Donut chart of MS-Excel365 is used to show proportions of categorical data, in which the size of each part represents the proportion of each category.Solution
The correct answer is D
More Previous year papers Questions
What is the simplified value of the given expression?
3(sin² 30° + sin² 60°) + 6sin 45° - (3sec 60° + cot 45°)
If x = r sin A cos B, y = r sin A sin B and z = r cos A, then find x² + y² + z².
- Find the maximum value of (7sin A + 24cos A).
Find the maximum value of 22 sin A + 16 cos A.
- If 4cos²A + 5sin²A = 4.5, then find the value of (sec²A - 1)
- If sin 2a = (7/9), then find the value of (sin a + cos a).
If sec a + tan a = 3/2, find the value of sin a.
- Find the maximum value of (12sin A + 16cos A).
If x tan 60° + cos 45° = sec 45° then the value of x2 + 1 is
