DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
auto complete
|
|
|
auto correct
|
|
|
pick from list
|
|
|
value
|
Detailed explanation-1: -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-2: -To repeat something simple, such as a paste operation, press Ctrl+Y or F4 (If F4 doesn’t seem to work, you may need to press the F-Lock key or Fn Key, then F4). If you prefer to use the mouse, click Repeat on the Quick Access Toolbar.
Detailed explanation-3: -Alternatively, press the shortcut. read more keys “Alt+H+L+H+D” one by one. The “duplicate values” dialog box opens, as shown in the following image.
Detailed explanation-4: -Right-click the row or column label you want to repeat, and click Field Settings. Click the Layout & Print tab, and check the Repeat item labels box. Make sure Show item labels in tabular form is selected.
Detailed explanation-5: -Description. Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.