USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Home
|
|
|
Insert
|
|
|
Page Layout
|
|
|
Formulas
|
Detailed explanation-1: -We can also INSERT FUNCTION under the FORMULA tab. We can INSERT FUNCTION under Autosum drop down by clicking on “More Functions.” The shortcut key to INSERT FUNCTION in Excel is “Shift + F3.”
Detailed explanation-2: -Go to the Formulas ribbon – choose either the Insert Function icon to bring up the Insert Function dialog box (same dialog box you would get with the first method), or click the arrow next to the correct category in the Function Library Group, and then choose the desired function.
Detailed explanation-3: -If you’re having trouble finding the right function, the Insert Function command lets you search for the function you want. It also guides you through inserting the arguments, which is helpful for complex functions. Click the cell where you want to add a formula.
Detailed explanation-4: -To show the Formula Bar, click the View tab, and then click to select the Formula Bar check box. Tip: If you want to expand the Formula Bar to show more of the formula, press CONTROL+SHIFT+U.
Detailed explanation-5: -Display formulas using the Show Formulas command To show formulas in Excel, you can click on the Formulas tab and then click Show Formulas. This will show all formulas in the Excel worksheet.