MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet1!A10 Sheet3.A10 A10 Sheet3!A10 Sheet1!A10 Sheet3.A10 A10 Sheet3!A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following option is not available in paste Special dialog box ? Divide SQRT Add Subtract Divide SQRT Add Subtract ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + F Ctrl + H Ctrl + Shift + R Ctrl + R Ctrl + F Ctrl + H Ctrl + Shift + R Ctrl + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can merge the main document with data source in Excel. In mail merge operation, Word is usually Client Server None of these Source Client Server None of these Source ANSWER DOWNLOAD EXAMIANS APP
MS Excel The autofill feature Automatically adds range of cell values All of the listed here Extends a sequential series of data Applies a boarder around the selected cells Automatically adds range of cell values All of the listed here Extends a sequential series of data Applies a boarder around the selected cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel To center worksheet titles across a range of cells, you must Select the cells containing the title text plus the range over which the title text is to be centered Widen the columns Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be enfettered Select the cells containing the title text plus the range over which the title text is to be centered Widen the columns Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be enfettered ANSWER DOWNLOAD EXAMIANS APP