Question

I.FILLINTHEBLANKS: 10X1=10
1.___________ collates the data from different ranges and places it in a worksheet
2.__________is the elaborate form of GoalSeek
3.__________is used to set a goal to find the optimum value for one or more target
variables
4.It is a good practice to use ________ data while applying the subtotal command to it
5.A scenario is a _________ that you enter in a worksheet to perform calculations.
6.To remove sub totals from your worksheet ,click on a cell with inarange and choose
________ from the subtotal dialog box.
7.The________ tools of excel allow you to use different sets of values in one or more
formulas to explore all the various results.
8.InExcel,__________ is away to see different results by altering an input cell in your
formula
9.Linking spreadsheet data enables you to keep the information ________ without
editing multiple locations every time the data changes
10.______ and _________ are the two ways to link the contents of cells in different work books

Answer 1

Answer:

a) Microsoft Excel

b) answered is given in the above picture

c) optimization analysis

d) 2nd picture is the answer of this question

Explanation:

I will hope this 4 answer will help u pls mark me brilliant pls only one request