MS Excel Which is used to perform what if analysis? Solver Scenario Manager Goal seek All of above Solver Scenario Manager Goal seek All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, a Data Series is defined as what? A division of results A cell reference A collection of related data A type of chart A division of results A cell reference A collection of related data A type of chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is called a workbook because It can be modified It can contain text and data You have to work hard to create it It can contain many sheets including worksheets and chart sheets It can be modified It can contain text and data You have to work hard to create it It can contain many sheets including worksheets and chart sheets ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can move a sheet from one workbook into new book by From Edit menu choose Move of Copy then choose (Move to end) and click OK None of the listed here From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK From Edit menu choose Move or Copy then select (new book) from To Book list and click OK From Edit menu choose Move of Copy then choose (Move to end) and click OK None of the listed here From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK From Edit menu choose Move or Copy then select (new book) from To Book list and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: Values or cell references although not both at the same time Cell references but not values Value and cell references Values but not cell references Values or cell references although not both at the same time Cell references but not values Value and cell references Values but not cell references 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