MS EXCEL QUIZ

Use =if() function to format the required numbers red

Select the cells that contain number between 0 and 100 then click Red color on Text Color tool

All of above

Apply Conditional Formatting command on Format menu

When you use addition and subtraction in a formula

When you use multiplication, division, or exponentiation in a formula

When you show the results of formulas with different decimal places that the calculated results

Because excel uses hidden decimal places in computation

Select Format > Money from the menu

You have to retype everything and manually add the dollar signs, commas, and decimals

Click the Currency Style button on the formatting toolbar

None of the listed here

Both of above

Select the sheet, then choose Edit > Delete Sheet

None of above

Select the sheet then choose Format > Sheet > Hide

None of the listed here

Doctor's symbol (Big Plus)

Mouse pointer with anchor at the tip

Small thin plus icon

Allow you to view a different worksheet

Allow you to view additional worksheet columns to the right

Allow you to view additional worksheet rows down

Allow you to view additional sheets tabs

A horizontal axis

A chart plot area

The data range that supply chart data

The organization of individual values with a chart’s data series

Name Box

Title Bar

Status Bar

Formula Bar

None of above

Both of above

Cut and Paste

Paste Special > Transpose

A1

#a#1

!A!1

$A$1