MS Excel Excel probably considers the cell entry January 1, 2020 to be a Formula Value Text string Label Formula Value Text string Label ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of following is Not one of Excel's what-if function? Scenario manager Goal seek Auto Outline Solver Scenario manager Goal seek Auto Outline Solver ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas is not entered correctly? =B7+14 =10+50 10+50 =B7*B1 =B7+14 =10+50 10+50 =B7*B1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel In EXCEL, you can sum a large range of data by simply selecting a tool button called ________. AutoFill Auto sum Auto correct Auto format AutoFill Auto sum Auto correct Auto format ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a correct order of precedence in formula calculation? Multiplication and division, positive and negative values, addition and subtraction None of the listed here Multiplication and division exponentiation positive and negative values Addition and subtraction, positive and negative values, exponentiation Multiplication and division, positive and negative values, addition and subtraction None of the listed here Multiplication and division exponentiation positive and negative values Addition and subtraction, positive and negative values, exponentiation ANSWER DOWNLOAD EXAMIANS APP