MS Excel Concatenation of text can be done using Exclamation (!) Apostrophe (') Hash (#) Ampersand (&) Exclamation (!) Apostrophe (') Hash (#) Ampersand (&) ANSWER DOWNLOAD EXAMIANS APP
MS Excel To select an entire column in MS - EXCEL, press ? CTRL + C CTRL + Arrow key CTRL + S None of the listed here CTRL + C CTRL + Arrow key CTRL + S None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel files have a default extension of in Excel-2003 Xlw Wk1 Xls 123 Xlw Wk1 Xls 123 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a way to complete a cell entry? Pressing any arrow key on the keyboard Pressing enter Clicking the Enter button on the Formula bar Pressing spacebar Pressing any arrow key on the keyboard Pressing enter Clicking the Enter button on the Formula bar Pressing spacebar 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
EXAMIANS