MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? 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 Excel does not have option to match case for find 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 the Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing Shift key By dragging a range of excel data to the word button on the taskbar while pressing Alt key None of the listed here 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 By dragging a range of excel data to the word button on the taskbar while pressing Alt key ANSWER DOWNLOAD EXAMIANS APP
MS Excel The autofill feature Extends a sequential series of data Automatically adds range of cell values All of the listed here Applies a boarder around the selected cells Extends a sequential series of data Automatically adds range of cell values All of the listed here Applies a boarder around the selected cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 6.8 5430 5436.80 5436.8 6.8 5430 5436.80 5436.8 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Select Edit > Select > Column from the menu Click the column heading letter Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column Select Edit > Select > Column from the menu Click the column heading letter Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Concatenate and manipulate text Return ASCII values of characters Replace cell references Show formula error value Concatenate and manipulate text Return ASCII values of characters Replace cell references Show formula error value ANSWER DOWNLOAD EXAMIANS APP