Advanced Features Of Spreadsheet Flashcards
What do you mean by data consolidation
Data consolidation refers to collecting and integrating data from multiple worksheets or workbooks into a single master worksheet
What do you mean by creatings sub total and also tell the steps
Sab total command is used to automatically create groups and apply inbuilt functions like some and count and average etc to summarise data the steps are go to data menu click Once Up total option
What do you mean by what if analysis and tell the names of different tools in it
It is the most powerful features in spreadsheet that helps to run reverse calculations analysis and scenarios comparison its tools are scenario and goal seek and solver
What do you mean by scenario
It is a tool to test what tough questions go to tools menu then click on scenarios
What do you mean by multiple operations tell the steps
It deals with lots of DATA so DATA menu
It is a tool for planning what if questions it creates a formula array which is the separate set of cells that give all the alternative results for formula used the steps are go to data menu click on multiple operations
What do you mean by goal seek tell the steps
Its a TOOL of what if ana
Tools menu is goal seek
It is basically used when our output is fixed and be have to make a change in any of the input cell values it reversive the usual order of formula the steps are go to tools menu and click on goal seek option
What do you mean by solver
Solver is a more scriptive form of goal seek goal seek is used to manipulate one input cell insolver we can manipulate a set of cells after knowing the output and we can estimate the minimum or maximum value that can be entered into those cells
What are the different ways and steps to insert new worksheets
Go to insert menu then click on cheat option or right click the sheet tab and click on new sheet
What do you mean by self cell reference
It refers to a cell or a range of cells on a worksheet that can be used to find the values a data
Write the syntax to give reference to an individual cell and reference to a range of cells
Sweet name.shell address
What is the hyperlink differentiate between relative and absolute hyperlink
Hyperlinks are widely used or internet to navigate between websites the advantage of relative hyperlink is that we don’t have to edit the link address then files are move to another location
Write the steps to share a document
Steps Trick: TU d(T)aS
Go to tools menu then click on options then click on user data and set up accordingly after that go to tools menu and then share the document
Write the steps to record changes
EaR - edit menu record changes
Click on edit menu then select changes option then click on record option
Write the steps to add a comment in a Cell
Select the cell then right click it and select insert comment option
What is a macro
Macros are the set of stored functions that can be used to automate processes that are repeated often
