![]() ![]()
Sravan wants to do the same set of tasks to be done repeatedly like formatting or applying a similar formula in a similar range of data.Suggest him a suitable tool for that.Ĥ5. What referencing he will use to get the correct result.Ĥ4. Rakesh wants to apply a formula in the entire column of the spreadsheet,with respect to only one cell. Which of the following tools is best suited for him?Ĥ3. The data is stored in various sheets of a workbook. Shovit wants to combine and find the sum/average of marks obtained by the students in the previous three periodic tests. Ramesh wants to solve one variable problem, Suggest him which of the data analysis tools is best suited for him.Ĥ2. ![]() In a spreadsheet,absolute reference will be referred to.Ĥ1. _is the default extension of Openoffice calc.Ĥ0. What are the operation we can do on the shared documentsģ9. In Oo Calc, Which options should be used to accept/reject the changes in the shared sheet.ģ8. In spreadsheet, to apply Goal Seek your cell pointer must be inĪ) The Changing cell whose value you need to find.ī) The Result Cell where formula is entered ✓Ĭ) The cell where your targeted value is enteredģ6.Which of the following tools deals with multiple unknown values?ģ7. Which tool you can use in Calc to make an estimate of output values for different input values?ģ5. #OPENOFFICE CALC ABSOLUTE REFERENCE SOFTWARE#Spreadsheet software can find the changes by_ sheets.ģ4. Which of the following option tells a summary of a macro in the macro dialog box?ģ3. ![]() _ tab in the Accept or Reject changes dialog box is used to specify the filter criteria.ģ2. Solved Sample Paper Class 10 IT(402) Set-1 Solved Sample Paper Class 10 IT(402) Set-2ģ1. Name the menu which is used to create scenarios.ģ0. To delete a Scenario, right click the name in the _ window and select Delete.Ģ9. #OPENOFFICE CALC ABSOLUTE REFERENCE SERIES#You can save time by_ a series of action to create macro.Ģ8. The Record Macro option is present under _menu.ĭ) Insert Electronic Spreadsheet Class 10 MCQĢ6. Compare Document option is present under _menu.Ģ5. Comment option is present under_ menu.Ģ4. #OPENOFFICE CALC ABSOLUTE REFERENCE PASSWORD#To password protect a worksheet, click on Edit → Changes →_Ģ3. To _ the comment, hover the mouse pointer over the cell that has comment.Ģ2. Important MCQ on Digital Documentation Class 10 IT Imp0rtant MCQ on Database Management System Class 10 ITĢ1. The Share Document option is present under _menu. ![]() To remove a hyperlink, right- click on the hyperlink and selectĢ0. Hyperlink icon is present in _toolbar.ġ9. To create a hyperlink to a webpage, FTP server of Telnet connection, click on_icon.ġ8. To refer a cell from another worksheet, use worksheet number followed by_ sign and cell address.ġ7. Rename option is present under Sheet option of_ menu.ġ6. Just hit F2 to enter into the edit mode of a cell and keep pressing F4.15. This is much faster when you are working with a huge set of worksheets and formulas. You can toggle between relative and absolute reference using F4. The more you use mixed reference, the more you can make your worksheet robust and automated. #OPENOFFICE CALC ABSOLUTE REFERENCE MANUAL#Mixed reference can easily be copied to other cells without any manual formula modification and it reduces manual or typo errors. Mixed reference is a bit tricky to set up initially in your worksheet, but they are very useful. Mixed references can be used to set up formulas that can be copied across rows or columns without the need for manual editing. For example, the following references have both relative and absolute components: =$A1 // column locked A column locked but the row varies =A$1 // row locked Column A varies but row is fixed =$A$1:A2 // first cell locked but A2 can vary Mixed reference in Calc is a reference where both absolute and relative reference exists. Hence when you copy down the formula from B2 to B5, the first part A2 changes but the absolute reference remains same for all. In the above temperature conversion example, where centigrade is converted to ferenheit – the cell B2 contains the absolute reference of the conversion formula / factor of this calculation. For example, an absolute reference to A1 looks like this: =$A$1Īn absolute reference for the range A1:A10 looks like this: =$A$1:$A$10 Absolute Reference in Calc Example of Absolute Reference To create an absolute reference in Calc, add a dollar ($) sign before the row and column identifier. In contrast to relative reference, an absolute reference refers to a cell or a range that is “locked” and it won’t change when you copy or drag the Calc cell handle in consecutive cells or ranges.Īn absolute reference refers to an actual fixed location in Calc. In the example shown above, the formula in D2 contains two relative references that will change as follows when copied down column D: =C2*B2 Relative Reference in Calc Example of Relative reference ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |