DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Insert, Table
|
|
|
Insert, Row
|
|
|
Insert, Column
|
|
|
Delete, Row
|
Detailed explanation-1: -To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break. Double-click the cell in which you want to insert a line break (or select the cell and then press F2).
Detailed explanation-2: -The insertion of an excel row is simply the addition of a new (blank) row to the worksheet. The insertion of a row is eased with the help of shortcuts. A shortcut reduces the time taken to perform a task. This is because pressing a single key or combinations of keys help shorten an otherwise lengthy process.
Detailed explanation-3: -The SQL INSERT INTO Statement is used to add new rows of data to a table in the database.
Detailed explanation-4: -To sum a row of numbers, select the cell immediately to the right. AutoSum is in two locations: Home > AutoSum, and Formulas > AutoSum. Once you create a formula, you can copy it to other cells instead of typing it over and over.