MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5430 6.8 5436.8 5436.80 5430 6.8 5436.8 5436.80 ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must From Edit menu choose Clear and then Formats Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Delete Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Clear and then Formats Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Delete Double click the Format Painter and then press Esc key in keyboard ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet range is a A group of worksheets A group of cells A range of values such as from 23 to 234 A command used for data modeling A group of worksheets A group of cells A range of values such as from 23 to 234 A command used for data modeling ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Pmt Sum Average Max Pmt Sum Average Max ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply 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 Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in column then choose Paste Special, then click Transpose and OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS