DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Currency format
|
|
|
Order of Precedence
|
|
|
Active cell
|
|
|
Value
|
Detailed explanation-1: -Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.
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.