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 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 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 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 in row, select the same number of cells in row and paste ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? Logical Math & Trigonometry Statistical Financial Logical Math & Trigonometry Statistical Financial ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Goal seek Divide Percentage Square Goal seek Divide Percentage Square ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the drag and drop method to Add cell contents Copy cell contents & Move cell contents Copy cell contents Move cell contents Add cell contents Copy cell contents & Move cell contents Copy cell contents Move cell contents ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Chart wizard term data categories refers to; The organization of individual values with a chart’s data series A horizontal axis The data range that supply chart data A chart plot area The organization of individual values with a chart’s data series A horizontal axis The data range that supply chart data A chart plot area ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a term of MS-Excel? Cells Rows Columns Document Cells Rows Columns Document ANSWER DOWNLOAD EXAMIANS APP