MS Excel How do you rearrange the data in ascending or descending order? Data, Form Data, Table Data, Sort Data Subtotals Data, Form Data, Table Data, Sort Data Subtotals ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Double CAL indicator on status bar Both of above None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar Both of above None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button ANSWER DOWNLOAD EXAMIANS APP
MS Excel Data can be arranged in a worksheet in a easy to understand manner using Auto formatting Changing fonts All of the listed here Applying styles Auto formatting Changing fonts All of the listed here Applying styles ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is called a workbook because It can be modified You have to work hard to create it It can contain many sheets including worksheets and chart sheets It can contain text and data It can be modified You have to work hard to create it It can contain many sheets including worksheets and chart sheets It can contain text and data ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which would you choose to create a bar diagram? Insert, Chart Edit, Chart Format, Chart Tools, Chart Insert, Chart Edit, Chart Format, Chart Tools, Chart ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS