MS Excel Text formulas: Concatenate and manipulate text Return ASCII values of characters Replace cell references Show formula error value Concatenate and manipulate text Return ASCII values of characters Replace cell references Show formula error value ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Enter Ctrl + C Ctrl + Page Up Ctrl + Space Bar Ctrl + Enter Ctrl + C Ctrl + Page Up Ctrl + Space Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is represented by the small, black square in the lower-right corner of an active cell or range? Fill handle Border Copy handle Insert handle Fill handle Border Copy handle Insert handle ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the cell pointer indicate that you can move the content to other cell? Doctor’s symbol (Big Plus) Mouse Pointer with anchor at the tip Small thin plus icon None of above Doctor’s symbol (Big Plus) Mouse Pointer with anchor at the tip Small thin plus icon None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3!A10 Sheet3.A10 Sheet1!A10 A10 Sheet3!A10 Sheet3.A10 Sheet1!A10 A10 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 Percentage Square Divide Goal seek Percentage Square Divide ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS