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 What is the short cut key to highlight the entire column? Ctrl + Space Bar Ctrl + Page Up Ctrl + C Ctrl + Enter Ctrl + Space Bar Ctrl + Page Up Ctrl + C Ctrl + Enter ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy cell contents using drag and drop press the Shift key Esc key Ctrl key End key Shift key Esc key Ctrl key End key ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply 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 Apply Conditional Formatting command on Format menu All of above 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 Apply Conditional Formatting command on Format menu All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel adjusts absolute cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel To center worksheet titles across a range of cells, you must Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be centered Select the cells containing the title text plus the range over which the title text is to be enfettered Widen the columns Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be centered Select the cells containing the title text plus the range over which the title text is to be enfettered Widen the columns ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS