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 of the following is not a valid data type in Excel ? Character Number Label Date/Time Character Number Label Date/Time ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which setting you must modify to print a worksheet using letterhead? Margin Orientation Layout Paper Margin Orientation Layout Paper ANSWER DOWNLOAD EXAMIANS APP
MS Excel You cannot link excel worksheet data to a word document With the copy and paste special commands With the copy and paste buttons on the standard toolbar With the right drag method With a hyperlink With the copy and paste special commands With the copy and paste buttons on the standard toolbar With the right drag method With a hyperlink ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color on Fill Color tool in Formatting toolbar Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color on Fill Color tool in Formatting toolbar ANSWER DOWNLOAD EXAMIANS APP