Write about insetting columns and rows in Calc. Alternatively, we can enter data and then use Calc in a ‘What If…’ manner by changing some of the data and observing the results without having to retype the entire spreadsheet.We can enter any kind of data in a spreadsheet and then manipulate this data to produce certain results. OpenOffice Calc is the spreadsheet component of OpenOffice.OpenOffice Calc is a popular open source spreadsheet application maintained by Apache Foundation.The content will be available in destination location atone. While Cut-Paste, the content will shift from source location to the destination location, i.e., the content will change its position. While Copy-Paste, the content will be available in both source and destination locations. and the rows are numbered from 1, 2, 3….ĭifferentiate between Copy – Paste and Cut – Paste. Rows and Columns: The worksheet has number of rows and columns, where each column is labelled as A, B, C, D …. Text Operator: In Calc, “&” is a text operator which is used to combine two or more text, Joining two different texts is also known as “Text Concatenation” An expression using the text operator has the following syntax: The “Insert Cells” dialog box contains four options: What are the options available in “Insert Cells” dialog box? Press F2 function key and then use backspace to delete the unwanted and type the required.Click on the formula bar and use backspace to delete the unwanted and type the required.Place the cell pointer in the cell and type the new data which replaces the existing data.We can do It in any one of the following method: What are the keyboard shortcuts to cut, copy and paste?Ĭan you edit the contents of a cell? If yes, explain any one of the method of editing the cell content. 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 text. Write about the text operator in OpenOffice Calc. The cell in which the cell pointer is currently located is known as active cell. There are three toolbars available by default.Ĭell pointer is a rectangle box which can be moved around the worksheet. 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 (Assume H1 = 12, H2 = 12)? = H1H2 What wilt be the result from the following formula (Assume A1=5, 82=2)? + A1^B2 Which key is used to move the cell pointer in the forward direction within the worksheet?Ī formula in calc may begin with _. Grid of cells with a programmable calculator:Ī column heading in Calc is represented using _. Which of the following applications was the parent to OpenOffice Calc? Which is the first electronic spreadsheet?
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |