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 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 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 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 Copy the cells in column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? Math & Trigonometry Statistical Financial Logical Math & Trigonometry Statistical Financial Logical ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Ctrl + Home Press Home Press Alt + Home Press Shift + Home Press Ctrl + Home Press Home Press Alt + Home Press Shift + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can enter which types of data into worksheet cells? Labels and values but not formulas Labels, values, and formulas Formulas only Values and formulas but not labels Labels and values but not formulas Labels, values, and formulas Formulas only Values and formulas but not labels ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can activate a cell by Clicking the cell Pressing an arrow key Pressing the Tab key All of these Clicking the cell Pressing an arrow key Pressing the Tab key All of these ANSWER DOWNLOAD EXAMIANS APP
MS Excel To remove the content of selected cells you must issue ___ command Clear Contents Clear All Clear Delete Delete Clear Contents Clear All Clear Delete Delete ANSWER DOWNLOAD EXAMIANS APP