MS Excel Which of following is Not one of Excel's what-if function? Solver Goal seek Scenario manager Auto Outline Solver Goal seek Scenario manager Auto Outline 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 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 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 Copy the cells in row, select the same number of cells in row and paste 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a correct order of precedence in formula calculation? Multiplication and division, positive and negative values, addition and subtraction Addition and subtraction, positive and negative values, exponentiation Multiplication and division exponentiation positive and negative values None of the listed here Multiplication and division, positive and negative values, addition and subtraction Addition and subtraction, positive and negative values, exponentiation Multiplication and division exponentiation positive and negative values None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet1!A10 Sheet3.A10 Sheet3!A10 A10 Sheet1!A10 Sheet3.A10 Sheet3!A10 A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To edit in an embedded excel worksheet object in a word document Edit the hyperlink Use the excel menu bar and toolbars inside the word application Use the word menu bar and toolbars Edit the data in a excel source application Edit the hyperlink Use the excel menu bar and toolbars inside the word application Use the word menu bar and toolbars Edit the data in a excel source application ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Chart wizard term data categories refers to; The data range that supply chart data A horizontal axis The organization of individual values with a chart’s data series A chart plot area The data range that supply chart data A horizontal axis The organization of individual values with a chart’s data series A chart plot area ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS