MS Excel Which function is not available in the Consolidate dialog box ? Average Max Sum Pmt Average Max Sum Pmt 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 How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F8 F9 F10 F11 F8 F9 F10 F11 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which command will you choose to convert a column of data into row? Cut and Paste None of above Both of above Paste Special > Transpose Cut and Paste None of above Both of above Paste Special > Transpose ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? Goal seek Square Divide Percentage Goal seek Square Divide Percentage ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet range is a A group of cells A range of values such as from 23 to 234 A group of worksheets A command used for data modeling A group of cells A range of values such as from 23 to 234 A group of worksheets A command used for data modeling ANSWER DOWNLOAD EXAMIANS APP