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 Work sheet Data sheet Chart sheet Macro sheet Work sheet Data sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can set Page Border in Excel from You can not set Page Border in Excel From Border tab in Farmat cells dialog box From Line style tool in Drawing toolbar From Border tool in Formatting toolbar You can not set Page Border in Excel From Border tab in Farmat cells dialog box From Line style tool in Drawing toolbar From Border tool in Formatting toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must Double click the Format Painter and then press Esc key in keyboard Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Delete From Edit menu choose Clear and then Formats Double click the Format Painter and then press Esc key in keyboard Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Delete From Edit menu choose Clear and then Formats ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is represented by the small, black square in the lower-right corner of an active cell or range? Copy handle Insert handle Fill handle Border Copy handle Insert handle Fill handle Border 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 5436.8 5430 5436.80 6.8 5436.8 5430 5436.80 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS