MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)-10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel In a worksheet you can select Rows The entire worksheet All of these Columns Rows The entire worksheet All of these Columns ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? & * % $ & * % $ ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a basic step in creating a worksheet? Copy the worksheet Modifiy the worksheet Save workbook Enter text and data Copy the worksheet Modifiy the worksheet Save workbook Enter text and data ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not the correct method of editing the cell content? Double click the cell Press the Alt key Press the F2 key Click the formula bar Double click the cell Press the Alt key Press the F2 key Click the formula bar ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS