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 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 Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following series type is not valid for Fill Series dialog box ? Linear Growth Autofill Time Linear Growth Autofill Time ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ? Press Alt + Home Press Shift + Home Press Home Press Ctrl + Home Press Alt + Home Press Shift + Home Press Home Press Ctrl + Home ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS