MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? A10 Sheet3!A10 Sheet1!A10 Sheet3.A10 A10 Sheet3!A10 Sheet1!A10 Sheet3.A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel The command Edit > Fill Across Worksheet is active only when When many sheets are selected None of the listed here When no sheet is selected One sheet is selected When many sheets are selected None of the listed here When no sheet is selected One sheet is selected ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, the Fill Color button on the Formatting toolbar is used for what? To add shading or color to a cell range To insert a background To add borders To select a distribution of figures To add shading or color to a cell range To insert a background To add borders To select a distribution of figures ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is the latest version of Excel Excel 365 Excel 2007 Excel 2016 Excel XP Excel 365 Excel 2007 Excel 2016 Excel XP ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data, Form Data, Sort Data, Table Data Subtotals Data, Form Data, Sort Data, Table Data Subtotals ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts empty cells Counts cells having number Counts cells having alphabets Counts non-empty cells Counts empty cells Counts cells having number Counts cells having alphabets Counts non-empty cells ANSWER DOWNLOAD EXAMIANS APP