MS Excel Which of the following is not information you can specify using the solver? Constraints Target cell Input cells Changing cells Constraints Target cell Input cells Changing cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which button do you click to add up a series of numbers? The Formula button The autosum button The quicktotal button The total button The Formula button The autosum button The quicktotal button The total button ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which command will you choose to convert a column of data into row? None of above Paste Special > Transpose Both of above Cut and Paste None of above Paste Special > Transpose Both of above Cut and Paste ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Sheet tabs Location tabs Reference tabs Position tabs Sheet tabs Location tabs Reference tabs Position tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red All of above Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Ctrl+ D shortcut key in Excel will None of the listed here Apply double underline for the active cell Fill down in the selection Open the font dialog box None of the listed here Apply double underline for the active cell Fill down in the selection Open the font dialog box ANSWER DOWNLOAD EXAMIANS APP