USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Use the format cells dialog box to change the cells number format to Portuguesse
|
|
|
Use the translate button on the review tab while in edit mode.
|
|
|
Use the Symbol button on the Insert tab while in edit mode.
|
|
|
Use the styles gallery on the home tab to change the cells style to Brazil
|
Detailed explanation-1: -The Developer tab is a very useful addition to the Excel ribbon that allows you to access a number of advanced features such as VBA macros, ActiveX and Form controls, XML commands, and more.
Detailed explanation-2: -As you already know, the validation criteria are defined on the Settings tab of the Data Validation dialog box (Data tab > Data Validation).
Detailed explanation-3: -Select the range that needs data bars. On the Home tab, in the Styles group, select Data Bars from the Conditional Formatting tool. From there you can select data bars of different colors and opacities (see Figure 3.19).
Detailed explanation-4: -Which of the following methods is used to display the Series dialog box that is used to fill data in a range? On the Home tab, in the Editing group, select Fill and then click Series.