DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
format cells containing numbers
|
|
|
create and edit formulas containing functions
|
|
|
entered assumptions data
|
|
|
copy all cells
|
Detailed explanation-1: -Formula palette is used to create and edit formula. Steps to use Formula Palette: Select the cell that will hold the formula. Click the Edit Formula button (the “=” sign to the left of the Formula bar) to open the Formula Palette.
Detailed explanation-2: -You can create a formula to calculate values in your worksheet by using a function. For example, the formulas =SUM(A1:A2) and SUM(A1, A2) both use the SUM function to add the values in cells A1 and A2. Formulas always start with an equal sign (=).
Detailed explanation-3: -Click the cell that contains the data that you want to edit, and then click anywhere in the formula bar. This starts Edit mode and positions the cursor in the formula bar at the location that you clicked. Click the cell that contains the data that you want to edit, and then press F2.
Detailed explanation-4: -The Formula Bar can be used for entering data into cells as well as for editing data that already exists in a cell.
Detailed explanation-5: -The Formula Bar is where data or formulas you enter into a worksheet appear for the active cell. The Formula Bar can also be used to edit data or formula in the active cell.