Question

Q3.
Answer any 5 out of the given 6 questions
(1 x 5 = 5 marks)
i. Sree wants to combine data from different spreadsheets. Which process should he
use for the purpose?
1
a. Consolidating
c. Exporting
b. Importing
d. Summarizing
ii. Which of the following menu provides the Subtotals option for calculating the
subtotal in a cell range?
1
a. Insert
c. Tools
b. Format
d. Data
iii. In OpenOffice Calc, you can create, edit, and manage scenarios with the help of the
tool.
1
a. If-What
c. What
b. What-If
d. If
iv. Madhuri wants to take a loan of 30,00,000. She wants to know the total amount of
loan with different monthly payments and with the same interest rate and time
period. Which tool should she use to fulfill her requirement?
1
a. Goal Seek
c. What-if
b. Macro
d. None of these
-key from the
1
v. You can open the data source in a spreadsheet by pressing the
keyboard.
a. F1
c. F3
b. F2
d. F4
1
yi Which option would you use to record the changes made in the spreadsheet?
econd​

Answer 1

Answer:

Yes

Explanation:

No longer has to go through all this stuff so you could use