DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Click the Office button > Select New > Click Create
|
|
|
Click the Office button > Select Open > Click Create
|
|
|
Click the Office button > Select New > Click Open
|
|
|
Click the Office button > Select Save > Click Create
|
Detailed explanation-1: -Click the File tab. Click New. Under Available Templates, double-click Blank Workbook. Keyboard shortcut To quickly create a new, blank workbook, you can also press CTRL+N.
Detailed explanation-2: -There are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference.
Detailed explanation-3: -If the Forms toolbar is not visible, point to Toolbars on the View menu, and then click Forms. Click the worksheet location where you want the upper-left corner of the list box to appear, and then drag the list box to where you want the lower-right corner of the list box to be.
Detailed explanation-4: -Step 1: Open MS Excel. Step 2: Go to Menu and select New » click on the Blank workbook to create a simple worksheet. OR – Press Ctrl + N: To create a new spreadsheet. Step 3: By default, Sheet1 will be created as a worksheet in the spreadsheet.