MS Excel Which of the following is not a basic step in creating a worksheet? Modifiy the worksheet Enter text and data Copy the worksheet Save workbook Modifiy the worksheet Enter text and data Copy the worksheet Save workbook ANSWER DOWNLOAD EXAMIANS APP
MS Excel MS Excel provides the default value for step in fill Series dialog box 5 1 10 O 5 1 10 O 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 An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Rounding errors can occur When you use multiplication, division, or exponentiation in a formula Because excel uses hidden decimal places in computation When you show the results of formulas with different decimal places that the calculated results When you use addition and subtraction in a formula When you use multiplication, division, or exponentiation in a formula Because excel uses hidden decimal places in computation When you show the results of formulas with different decimal places that the calculated results When you use addition and subtraction in a formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? Both You can Find and Replace within the sheet or workbook None of the listed here Excel does not have option to match case for find Both You can Find and Replace within the sheet or workbook None of the listed here Excel does not have option to match case for find ANSWER DOWNLOAD EXAMIANS APP