MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet1!A10 A10 Sheet3!A10 Sheet3.A10 Sheet1!A10 A10 Sheet3!A10 Sheet3.A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet can have a maximum of ________ number of rows. 256 65535 1024 1048576 256 65535 1024 1048576 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Getting data from a cell located in a different sheet is called ___ Updating Referencing Functioning Accessing Updating Referencing Functioning Accessing ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The sheet tab is changed The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true about Find and Replace in Excel You can decide whether to look for the whole word or not You can search for bold and replace with italics You can search by rows or columns or sheets You can search in formula too You can decide whether to look for the whole word or not You can search for bold and replace with italics You can search by rows or columns or sheets You can search in formula too ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS