MS Excel
Which of the following is a correct order of precedence in formula calculation?

Multiplication and division exponentiation positive and negative values
Multiplication and division, positive and negative values, addition and subtraction
None of the listed here
Addition and subtraction, positive and negative values, exponentiation

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?

Select Format > Money from the menu
None of the listed here
You have to retype everything and manually add the dollar signs, commas, and decimals
Click the Currency Style button on the formatting toolbar

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Which of the following is not true regarding Conditional Formatting?

You can set condition to look for Bold and apply Italics on them
You can delete any condition from Conditional Formatting dialog box if it is not requried
You can add more than one condition to check
You can apply Font, border and pattern formats that meets the specified conditions

ANSWER DOWNLOAD EXAMIANS APP