USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Currency format
|
|
|
Order of Precedence
|
|
|
Active cell
|
|
|
Value
|
Detailed explanation-1: -A worksheet (also known as a spreadsheet) consists of cells in which you can enter and calculate data. The cells are organized into columns and rows. A worksheet is always stored in a workbook.
Detailed explanation-2: -Using Keyboard Shortcuts (F4) If you want to repeat action in Excel, like inserting a column/row, formatting cells, copy & pasting, etc, then you can use the keyboard shortcut F4 which will repeat your last action (in most cases).
Detailed explanation-3: -You can use the shortcut to insert a line break to move the words to next line as you need. Click at the location where you want to move the last words to the next line, and hold Alt, and press Enter key, then the words behind the cursor will be moved to the next line in the cell.
Detailed explanation-4: -Borders may be placed on any or all sides of cell or range. A series of number signs (####) appearing in a cell indicates that the data is wider then the column.