MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? A10 Sheet3!A10 Sheet3.A10 Sheet1!A10 A10 Sheet3!A10 Sheet3.A10 Sheet1!A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you link data maintained in an excel workbook to a word document The word document contains a copy of the actual data The word document contains a reference to the original source application The word document cannot be edit The word document must contain a hyperlink The word document contains a copy of the actual data The word document contains a reference to the original source application The word document cannot be edit The word document must contain a hyperlink ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above Use =if() function to format the required numbers red ANSWER DOWNLOAD EXAMIANS APP
MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? FACT ( ) MOD ( ) ROUND ( ) Div ( ) FACT ( ) MOD ( ) ROUND ( ) Div ( ) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the cell pointer indicate that you can move the content to other cell? None of above Doctor’s symbol (Big Plus) Small thin plus icon Mouse Pointer with anchor at the tip None of above Doctor’s symbol (Big Plus) Small thin plus icon Mouse Pointer with anchor at the tip ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The cell content of selected cells disappear from cell and stored in clipboard The cells selected are marked for cutting The selected cells are deleted and the cells are shifted left The selected cells are deleted and cells are shifted up The cell content of selected cells disappear from cell and stored in clipboard The cells selected are marked for cutting The selected cells are deleted and the cells are shifted left The selected cells are deleted and cells are shifted up ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS