MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel probably considers the cell entry January 1, 2020 to be a Label Value Formula Text string Label Value Formula Text string ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a way to complete a cell entry? Pressing any arrow key on the keyboard Pressing spacebar Clicking the Enter button on the Formula bar Pressing enter Pressing any arrow key on the keyboard Pressing spacebar Clicking the Enter button on the Formula bar Pressing enter ANSWER DOWNLOAD EXAMIANS APP
MS Excel Multiple calculations can be made in a single formula using ___ Complex Formulas Standard Formulas Array formula Smart Formula Complex Formulas Standard Formulas Array formula Smart Formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the cell pointer indicates that you can fill series ? Doctor's symbol (Big Plus) Small thin plus icon Mouse pointer with anchor at the tip None of the listed here Doctor's symbol (Big Plus) Small thin plus icon Mouse pointer with anchor at the tip None of the listed here 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 =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 ANSWER DOWNLOAD EXAMIANS APP