MS Excel Which of the following option is not available in paste Special dialog box ? Divide Subtract SQRT Add Divide Subtract SQRT Add ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)-10 =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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can enter which types of data into worksheet cells? Formulas only Labels and values but not formulas Labels, values, and formulas Values and formulas but not labels Formulas only Labels and values but not formulas Labels, values, and formulas Values and formulas but not labels ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a range is selected, how can you activate the previous cell ? None Press Tab Press Enter Press the Alt key None Press Tab Press Enter Press the Alt key ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a way to complete a cell entry? Pressing spacebar Pressing any arrow key on the keyboard Clicking the Enter button on the Formula bar Pressing enter Pressing spacebar Pressing any arrow key on the keyboard Clicking the Enter button on the Formula bar Pressing enter ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: Multiply the selection by a copied value The resulting values of a formula instead of the actual formula Cell comments Formatting options Multiply the selection by a copied value The resulting values of a formula instead of the actual formula Cell comments Formatting options ANSWER DOWNLOAD EXAMIANS APP