MS Excel When a range is selected, how can you activate the previous cell ? None Press Enter Press Tab Press the Alt key None Press Enter Press Tab Press the Alt key ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you remove borders applied in cells ? Choose None on Border tab of Format cells Both Open the list on Border tool in Format Cell toolbar then choose first tool (none)) None Choose None on Border tab of Format cells Both Open the list on Border tool in Format Cell toolbar then choose first tool (none)) None ANSWER DOWNLOAD EXAMIANS APP
MS Excel The chart wizard term data series refers to A chart legend A set of values you plot in a chart A collection of chart data markers A data label A chart legend A set of values you plot in a chart A collection of chart data markers A data label ANSWER DOWNLOAD EXAMIANS APP
MS Excel The numbers in our worksheet look like this 1000: You want them to look like this: $1,000.How can you accomplish this? You have to retype everything and manually add the dollar signs, commas, and decimals None of the listed here Click the Currency Style button on the formatting toolbar Select Format > Money from the menu You have to retype everything and manually add the dollar signs, commas, and decimals None of the listed here Click the Currency Style button on the formatting toolbar Select Format > Money from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can add more than one condition to check You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can add more than one condition to check 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 use addition and subtraction in a formula When you show the results of formulas with different decimal places that the calculated results When you use multiplication, division, or exponentiation in a formula Because excel uses hidden decimal places in computation When you use addition and subtraction in a formula When you show the results of formulas with different decimal places that the calculated results ANSWER DOWNLOAD EXAMIANS APP