MS Excel Text formulas: Concatenate and manipulate text Show formula error value Return ASCII values of characters Replace cell references Concatenate and manipulate text Show formula error value Return ASCII values of characters Replace cell references 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 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 Split command on the window menu Freeze panes command on the window menu Unfreeze panes command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can auto fit the width of column by Double clicking on the column left border of column header Double clicking on column right border on column header Double click on the cell pointer in worksheet Double clicking on the column name on column header Double clicking on the column left border of column header Double clicking on column right border on column header Double click on the cell pointer in worksheet Double clicking on the column name on column header ANSWER DOWNLOAD EXAMIANS APP
MS Excel A typical worksheet has ___ number of columns. 128 256 16384 1024 128 256 16384 1024 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet1!A10 Sheet3!A10 Sheet3.A10 A10 Sheet1!A10 Sheet3!A10 Sheet3.A10 A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? Excel does not have option to match case for find Both You can Find and Replace within the sheet or workbook None of the listed here Excel does not have option to match case for find Both You can Find and Replace within the sheet or workbook None of the listed here ANSWER DOWNLOAD EXAMIANS APP