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 When a row of data is to be converted into columns 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually ANSWER DOWNLOAD EXAMIANS APP
MS Excel Hyperlinks can be Drawing objects Text All of above Pictures Drawing objects Text All of above Pictures ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can copy data or formulas With buttons on the standard toolbars With the copy, paste and cut commands on the edit menu With commands on the shortcut menu All of these With buttons on the standard toolbars With the copy, paste and cut commands on the edit menu With commands on the shortcut menu All of these ANSWER DOWNLOAD EXAMIANS APP
MS Excel To edit in an embedded excel worksheet object in a word document Use the excel menu bar and toolbars inside the word application Edit the data in a excel source application Edit the hyperlink Use the word menu bar and toolbars Use the excel menu bar and toolbars inside the word application Edit the data in a excel source application Edit the hyperlink Use the word menu bar and toolbars ANSWER DOWNLOAD EXAMIANS APP