Scenarios are a tool to test questions.

It refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want a formula to calculate.

______, totals/adds data arranged in an array—that is, a group of cells with labels for columns and/or rows Which step one must follow before using the Subtotal option?

A/An ______ hyperlink contains the full address of the destination file or web page.

Which of the following reflects the importance of Goal Seek?

______ means combining data in a spreadsheet from different worksheets into master worksheet

An __________ link will stop working only if the target is moved while a__________ link will stop working only if the start and target locations change relative to each other.

Seema holds the title of chartered accountant. On a daily basis, she used to keep track of the accounts on a spreadsheet. There are a number of steps that she must follow at all times. Can you recommend a spreadsheet feature that will allow her to complete these activities quickly and without having to repeat the processes each time?

Raju has produced a worksheet in which he has entered all of his employees’ details. He wants each employee to look over the spreadsheet and, if necessary, change their address and phone number. He’d also like to know what modifications his employees have made. Which aspect of the spreadsheet should he enable so that he can view the changes that his staff have made?

Shivani is working on a spreadsheet project. Her friend taught her how to rename a spreadsheet, which will make it easier for her to identify the worksheet data. She was excited and told her brother about it. A worksheet in spreadsheets can be renamed in ________different ways, according to her brother.

________is a spreadsheet function that is designed to minimize or maximize a result based on a set of rules that you describe.

The intersection point between a row and column is called _______

Formulas in a Spreadsheet must begin with a __________ sign.

______ is a tool to test “what-if” questions.

Rohit received a 25 out of 30 grade in English and a 22 out of 30 grade in Math. In order to calculate the score in IT, he needs to acquire an overall score of 85 percent. Provide him with the best selection from the list below.

As a school project, Krish and Kritika conducted a survey of their neighborhood’s literacy rates by age, which they recorded in a spreadsheet. They both want to work on it at the same time to finish it on time. Which option should they use to access the same Spreadsheet in order to save time?

You can use ________ to combine data from multiple worksheets into a master worksheet.

The Consolidated option is available under _________ menu.

We can consolidate data by ________

In the consolidate window, which of the following functions are available?

Which option should we use to define the target range? (Where we want the result to be displayed)

Which option is used to name a range of cells?

Define range option is available under the ________ menu.

SUBTOTALS _________ data arranged in an array (group of cells )

Subtotals are available in __________ menu.

In Subtotals we can select up to _______ groups of arrays.

Scenario option is available in ___________________ menu.

We can shift from one scenario to another by ____________

Which option is suitable to calculate the effect of different interest rates on an investment.

Default name of first scenario created in Sheet1 of Calc is _______

To select a random multiple cell hold down ________ key as you click on each cell.

Goal Seek Option available in __ menu.

______ is a more elaborate form of Goal Seek.

Solver option is available under _________ menu

Which feature of Calc helps to see the changes made in the shared worksheet?

Record Changes feature of Calc help