MS Excel
When a range is selected, how can you activate the previous cell ?

None
Press Enter
Press Tab
Press the Alt key

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

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

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

ANSWER DOWNLOAD EXAMIANS APP