MS Excel You can use the horizontal and vertical scroll bars to View different rows and columns edit the contents of a cell View different worksheets Split a worksheet into two panes Edit the contents of a cell View different rows and columns edit the contents of a cell View different worksheets Split a worksheet into two panes Edit the contents of a cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you link data maintained in an excel workbook to a word document The word document contains a reference to the original source application The word document must contain a hyperlink The word document contains a copy of the actual data The word document cannot be edit The word document contains a reference to the original source application The word document must contain a hyperlink The word document contains a copy of the actual data The word document cannot be edit ANSWER DOWNLOAD EXAMIANS APP
MS Excel To activate the previous cell in a pre-selected range, press The Enter key None of these The Tab key The Alt key The Enter key None of these The Tab key The Alt key ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a valid data type in Excel ? Character Date/Time Number Label Character Date/Time Number Label ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells in row, select the same number of cells in row and paste 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 column then choose Paste Special, then click Transpose and OK Copy the cells in row, select the same number of cells in row and paste Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK 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 Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Clear and then Formats Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS