MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F9 F8 F11 F10 F9 F8 F11 F10 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 Delete Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Clear and then Formats From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Clear and then Formats ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns 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 Copy the cells in column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which chart can be created in Excel ? Pie Line Area All of the listed here Pie Line Area All of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true about Find and Replace in Excel You can search by rows or columns or sheets You can search for bold and replace with italics You can decide whether to look for the whole word or not You can search in formula too You can search by rows or columns or sheets You can search for bold and replace with italics You can decide whether to look for the whole word or not You can search in formula too ANSWER DOWNLOAD EXAMIANS APP
MS Excel You cannot link excel worksheet data to a word document With the copy and paste special commands With a hyperlink With the copy and paste buttons on the standard toolbar With the right drag method With the copy and paste special commands With a hyperlink With the copy and paste buttons on the standard toolbar With the right drag method ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS