MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Edit > Copy Format and Edit>Paste Format commands form the menu There is no way to copy and apply formatting in Excel – You have to do it manually The Format Painter button on the standard toolbar The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Edit > Copy Format and Edit>Paste Format commands form the menu There is no way to copy and apply formatting in Excel – You have to do it manually The Format Painter button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Chart sheet Macro sheet Data sheet Work sheet Chart sheet Macro sheet Data sheet Work sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns 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 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 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 delete an embedded objects, first Select it and then press the delete key Double click the object Select the object by clicking it Press the Shift + Delete keys Select it and then press the delete key Double click the object Select the object by clicking it Press the Shift + Delete keys ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel files have a default extension of in Excel-2003 Xlw Wk1 123 Xls Xlw Wk1 123 Xls ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS