MS Excel Long text can be broken down into many lines within a cell. You can do this through Justify in Edit > Cells Text Wrapping in Format > Cells All of above Wrap Text in Format > Cells Justify in Edit > Cells Text Wrapping in Format > Cells All of above Wrap Text in Format > Cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? % & $ * % & $ * ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Both of above None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar Both of above None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Click Gridline tool on Forms toolbar Both None Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar Both None Go to Tools > Options > View tab and mark or remove the check box named Gridline ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? None of the listed here Both Excel does not have option to match case for find You can Find and Replace within the sheet or workbook None of the listed here Both Excel does not have option to match case for find You can Find and Replace within the sheet or workbook ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use drag-and-drop to embed excel worksheet data in a word document None of the listed here By dragging a range of excel data to the word button on the taskbar while pressing Alt key By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing Shift key None of the listed here By dragging a range of excel data to the word button on the taskbar while pressing Alt key By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing Shift key ANSWER DOWNLOAD EXAMIANS APP