MS Excel Which of following is Not one of Excel's what-if function? Solver Auto Outline Scenario manager Goal seek Solver Auto Outline Scenario manager Goal seek ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet range is a A group of cells A command used for data modeling A group of worksheets A range of values such as from 23 to 234 A group of cells A command used for data modeling A group of worksheets A range of values such as from 23 to 234 ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in column then choose Paste Special, then click Transpose and OK 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 in row, select the same number of cells in row and paste 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 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 in row, select the same number of cells in row and paste Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel The command Edit > Fill Across Worksheet is active only when None of the listed here When many sheets are selected One sheet is selected When no sheet is selected None of the listed here When many sheets are selected One sheet is selected When no sheet is selected ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which is used to perform what if analysis? Goal seek All of above Solver Scenario Manager Goal seek All of above Solver Scenario Manager ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + Shift + R Ctrl + H Ctrl + F Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F Ctrl + R ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS