MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) Cell address will change when it is copied to another cell The sheet tab is changed An absolute cell address is created The status bar does not display the cell address Cell address will change when it is copied to another cell The sheet tab is changed An absolute cell address is created The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Average Max Pmt Sum Average Max Pmt Sum ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can set Page Border in Excel from From Border tool in Formatting toolbar From Border tab in Farmat cells dialog box You can not set Page Border in Excel From Line style tool in Drawing toolbar From Border tool in Formatting toolbar From Border tab in Farmat cells dialog box You can not set Page Border in Excel From Line style tool in Drawing toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel It is acceptable to let long text flow into adjacent cells on a worksheet when Data will be entered in the adjacent cells There is not time to format the text There is no suitable abbreviation for the text No data will be entered in the adjacent cells Data will be entered in the adjacent cells There is not time to format the text There is no suitable abbreviation for the text No data will be entered in the adjacent cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel An excel workbook is a collection of Worksheets Workbooks Charts Worksheets and charts Worksheets Workbooks Charts Worksheets and charts ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you display current date only in MS Excel? Time () Today () Date () Now () Time () Today () Date () Now () ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS