MS Excel Which is used to perform what if analysis? Solver Goal seek Scenario Manager All of above Solver Goal seek Scenario Manager All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel To delete an embedded objects, first Select the object by clicking it Select it and then press the delete key Double click the object Press the Shift + Delete keys Select the object by clicking it Select it and then press the delete key Double click the object Press the Shift + Delete keys ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Work sheet Macro sheet Data sheet Chart sheet Work sheet Macro sheet Data sheet Chart sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click 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 in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Space Bar Ctrl + Enter Ctrl + Page Up Ctrl + C Ctrl + Space Bar Ctrl + Enter Ctrl + Page Up Ctrl + C ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as a label value if it precedes with Ampersand (&) Apostrophe (') Exclamation (!) Hash (#) Ampersand (&) Apostrophe (') Exclamation (!) Hash (#) ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS