The “Insert Cells” dialog box appear with four options. What are the options available in “Insert Cells” dialog box? The formula bar changes to have an entered and check mark. Press the F2 key, the cursor is placed at the end of the text.The cursor is placed where you double clicked. Double-click the cell you would like to edit.Yes, you can edit the contents of a cell in several distinct ways. What are the keyboard shortcuts to cut, copy and paste?Ĭells you want to cut the formula using Ctrl + X.Ĭan you edit the contents of a cell? If yes, explain any one of the method of editing the cell content? If you refer cell addresses directly while constructing formulae, it is called as “Relative Cell reference”. General Syntax of constructing a formula is: Write the general syntax of constructing a formula in Calc? An expression using the text operator has the following syntax: Joining two different texts is also known as “Text Concatenation”. In Calc, “&” is a text operator which is used to combine two or more texts as a single text. Write about the text operator in OpenOffice Calc? When you type any content, it will appear in the active cell. The cell in which the cell pointer is currently located is known as “Active cell”. They are:Ĭell pointer is a rectangle box which can be moved around the worksheet. Under the menu bar, there are three toolbars available by default. What are the types of toolbars available in OpenOffice Calc? Which of the following key combinations is used to increase the width of the current column? Which of the following symbol is used to make a cell address as an absolute reference? What will be the result from the following expression? (AssumeH1 = 12, H2 = 12)? = H1H2: What will be the result from the following formula? (Assume A1 = 5, B2 = 2)? + A1 B2: Which key is used to move the cell pointer in the forward direction within the worksheet? Grid of cells with a programmable calculator: Which of the following applications was the parent to OpenOffice Calc? Which is the first electronic spreadsheet? Tamilnadu Samacheer Kalvi 11th Computer Applications Solutions Chapter 7 Spreadsheets Basics (OpenOffice Calc) Samacheer Kalvi 11th Computer Applications Spreadsheets Basics (OpenOffice Calc) Text Book Back Questions and Answers

Students can Download Computer Applications Chapter 7 Spreadsheets Basics (OpenOffice Calc) Questions and Answers, Notes Pdf, Samacheer Kalvi 11th Computer Applications Book Solutions Guide Pdf helps you to revise the complete Tamilnadu State Board New Syllabus and score more marks in your examinations.

Openoffice calc absolute reference