DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
PAGE LAYOUT
|
|
|
REFERENCES
|
|
|
DESIGN
|
|
|
FORMULAS
|
|
|
THERE ISN’T ANY
|
Detailed explanation-1: –The seven tabs are Home, Insert, Page Layout, Formulas, Data, Review, View.-The above example uses the Home tab.
Detailed explanation-2: -If you’ve selected an Excel table, you’ll see the Table Tools with a Design tab. If you’ve selected a PivotTable, you’ll see the PivotTable Tools with an Analyze and a Design tab. The Table Tools aren’t available on the ribbon in Excel for the web, so you won’t be able to use them to make design changes to your table.
Detailed explanation-3: -Here this is is shown for the Home Tab. Eventually we want to get to commands that we use. Tabs:-The seven tabs are Home, Insert, Page Layout, Formulas, Data, Review, View.
Detailed explanation-4: -Go to File > Options > Customize Ribbon > Under the Customize Ribbon combo box on upper right, select “All Tabs” > Scroll down to Chart/Table/Pivot Table Tools and put a checkmark next to Design and click OK to apply the changes.