Questions and Answers
What is another term for 'Right Aligned'?
What is a workbook in Excel?
When using the 'Centered' setting, what happens to the text as you type?
What is the main characteristic of 'Justified' text?
Signup and view all the answers
What happens to the margin on the left when using the 'Right Aligned' setting?
Signup and view all the answers
What is the maximum number of rows in a worksheet?
Signup and view all the answers
How many worksheets can a workbook have?
Signup and view all the answers
How are cells identified in a worksheet?
Signup and view all the answers
How do you insert a shape in OpenOffice Calc?
Signup and view all the answers
What is the purpose of 'Number format'?
Signup and view all the answers
What happens to the space between words and characters in 'Justified' text?
Signup and view all the answers
What is the difference between a worksheet and a spreadsheet?
Signup and view all the answers
What is the maximum number of columns in a worksheet?
Signup and view all the answers
What is the default alignment option?
Signup and view all the answers
Where is the alignment option 'Bottom' commonly used?
Signup and view all the answers
What can cells in a worksheet hold?
Signup and view all the answers
What is the purpose of a text box in a spreadsheet file?
Signup and view all the answers
How can you insert a new worksheet?
Signup and view all the answers
What is the shortcut to insert a picture from a file in OpenOffice Calc?
Signup and view all the answers
What are special characters in OpenOffice Calc?
Signup and view all the answers
How do you insert a text box in a spreadsheet file?
Signup and view all the answers
What is the purpose of the Drawing toolbar in OpenOffice Calc?
Signup and view all the answers
How do you display the Form Control dialog box in OpenOffice Calc?
Signup and view all the answers
What is the result of selecting the Text Box option from the Form Control dialog box?
Signup and view all the answers
What is the shortcut key to spell-check your document?
Signup and view all the answers
What happens when you enable the Auto Spellcheck icon?
Signup and view all the answers
How do you get suggestions for misspelled words?
Signup and view all the answers
What is the purpose of the 'Replace' option?
Signup and view all the answers
What happens when you select 'Ignore All'?
Signup and view all the answers
How do you open the 'Spelling' window?
Signup and view all the answers
What is the result of selecting a suggested word?
Signup and view all the answers
What is the purpose of the Spelling utility?
Signup and view all the answers
What is the purpose of selecting the Separated by radio button in the Text to Columns window?
Signup and view all the answers
What is the default behavior of the Text to Columns feature when no separator is specified?
Signup and view all the answers
What is the purpose of the Fixed width option in the Text to Columns window?
Signup and view all the answers
What happens when you press the OK button after setting up the Text to Columns feature?
Signup and view all the answers
What is the advantage of using the Text to Columns feature?
Signup and view all the answers
What can you enter in the text box when selecting the Other check box in the Text to Columns window?
Signup and view all the answers
What is the result of selecting the Tab separator in the Text to Columns window?
Signup and view all the answers
What can you adjust in the preview window when using the Fixed width option?
Signup and view all the answers
Study Notes
Fundamentals of Worksheet
- A workbook is a collection of one or more spreadsheets, also called worksheets, in a single file.
- Each spreadsheet can have many sheets and each sheet can have many individual cells.
- Each sheet can have a maximum of 65,536 rows and a maximum of 1024 columns, for a total of over 67 million cells.
- A workbook can contain one or more different worksheets that can be accessed through the tabs at the bottom of the worksheet.
- A spreadsheet and worksheet mean the same thing.
- A particular cell is identified by its column letter and row number.
- These cells hold the individual elements—text, numbers, formulas, and so on—that make up the data to display and manipulate.
Adding Worksheet
- To insert new worksheets:
- Click on the Insert menu and select Sheet.
- Right-click on its tab and select Insert Sheet.
Text Alignment
- Left Aligned: Aligns the beginning of each line of text along the left margin of the cell.
- Right Aligned: Aligns the beginning of each line of text along the right margin of the cell.
- Centered: Places text in the center of each line.
- Justified: Combines left and right aligned text, filling the entire space from left to right.
Number Format
- Number formats are template strings consisting of format codes defining how numbers or text appear.
Inserting Elements
- Insert Image: To add any image from a file, select the Picture option from the Insert menu.
- Insert Shapes: To add any type of shape, select the VIEW menu -> TOOLBAR -> DRAWING option.
- Insert Textbox:
- Click on the VIEW menu -> TOOLBAR -> Form Control.
- Select the Text Box option.
- Insert Symbols:
- Special characters are not found on a standard English keyboard (e.g., © ¾ æ ç ñ ö ø ¢).
- To insert symbols, press Alt + T and then press Alt + S, or use the Spell-check window.
Spell Check
- Features of Spell Check utility:
- Enable Spell check: Click on the Auto Spellcheck icon from the standard toolbar.
- Suggestions: Right-click on the misspelled word to get suggested words.
- Ignore All: The misspelled word will be ignored by the spell checker.
- Replace: Select the misspelled word and click on the Spelling icon or right-click and select "Spellcheck..."
Text to Columns
- Used to split columns into smaller parts.
- Select the column and click on Data > Text to Columns.
- Select the Separated by radio button and choose a separator (e.g., Tab, Space, Comma, Merge delimiters, or Semicolon).
- The column will split at the specified separator.
- Alternatively, use the Fixed width option and adjust the ruler on the preview window to set a width for the column to split at.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Learn about the basics of worksheets, including their structure, components, and limitations. Understand how they are organized and accessed within a workbook.