FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
where to write excel formulas is called ____
A
Menu bar
B
Title bar
C
Formula bar
D
Tool bar
E
bars function
Explanation: 

Detailed explanation-1: -Excel formula bar is a special toolbar at the top of the Excel worksheet window, labeled with function symbol (fx). You can use it to enter a new formula or copy an existing one.

Detailed explanation-2: -On the worksheet, click the cell in which you want to enter the formula. Type the = (equal sign) followed by the constants and operators (up to 8192 characters) that you want to use in the calculation. For our example, type =1+1.

Detailed explanation-3: -The formula bar is a toolbar that appears at the top of our worksheet, below the Ribbon in our workbook. The formulas bar, sometimes called fx bar, displays text or number data in active or current cells, formulas in an active cell or range of cells in place of a selected data series in an Excel chart.

Detailed explanation-4: -Formula bar method Review the formula bar to identify where you want the break to occur. Click on the space you want to input the line break. Press “Alt” with “Enter” on your keyboard. For different operating systems, you can press “Control, ” “Option” and “Enter” on your keyboard.

There is 1 question to complete.