MS Excel Which of following is Not one of Excel's what-if function? Goal seek Auto Outline Scenario manager Solver Goal seek Auto Outline Scenario manager Solver ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? None of the listed here You can Find and Replace within the sheet or workbook Both Excel does not have option to match case for find None of the listed here You can Find and Replace within the sheet or workbook Both Excel does not have option to match case for find ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by Dragging over the desired cells Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Pressing the Shift key and an arrow key Pressing the Ctrl key while dragging over the desired cells Dragging over the desired cells Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Pressing the Shift key and an arrow key Pressing the Ctrl key while dragging over the desired cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns 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 Copy the cells in row, select the same number of cells in row and paste ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a label is too long to fit within a worksheet cell, you typically must Adjust the row height Increase the column width Decrease the column width Shorten the label Adjust the row height Increase the column width Decrease the column width Shorten the label ANSWER DOWNLOAD EXAMIANS APP
MS Excel The chart wizard term data series refers to A chart legend A collection of chart data markers A set of values you plot in a chart A data label A chart legend A collection of chart data markers A set of values you plot in a chart A data label ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS