MS Excel How do you rearrange the data in ascending or descending order? Data, Form Data Subtotals Data, Sort Data, Table Data, Form Data Subtotals Data, Sort Data, Table ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which chart can be created in Excel ? Pie All of the listed here Line Area Pie All of the listed here Line Area ANSWER DOWNLOAD EXAMIANS APP
MS Excel To edit in an embedded excel worksheet object in a word document Use the word menu bar and toolbars Edit the hyperlink Edit the data in a excel source application Use the excel menu bar and toolbars inside the word application Use the word menu bar and toolbars Edit the hyperlink Edit the data in a excel source application Use the excel menu bar and toolbars inside the word application ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply All of above Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, the Fill Color button on the Formatting toolbar is used for what? To insert a background To add borders To add shading or color to a cell range To select a distribution of figures To insert a background To add borders To add shading or color to a cell range To select a distribution of figures ANSWER DOWNLOAD EXAMIANS APP
MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Split command on the window menu Freeze panes command on the window menu Unfreeze panes command on the window menu Hold titles command on the edit menu Split command on the window menu Freeze panes command on the window menu Unfreeze panes command on the window menu Hold titles command on the edit menu ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS