Excel Ch. 2

What is a pre-written formula called?

• Feature

• Function

• Task

• Calculation

What is pressed to get a new line in a cell?

• Alt+Shift

• Ctrl+Enter

• Shift+Enter

• Alt+Enter

What is the correct order of arithmetic operations?

• NSADMEP

• NPEMDAS

• NEPDMSA

• PERMSAN

All of the following are arithmetic operators expect?

• <

• ^

• -

• %

Which one of the following is an arithmetic operator?

• #

• <

• =

• *

Calculate the following formula =6*(4-2)

• 24

• 6

• 12

• 4

Calculate the following formula =2^3/2

• 2

• 4

• 8

• 12

What is point mode?

• Edit contents into cells directly

• Select range from a worksheet

• Select cells using a mouse

• Select cells using a keyboard for formula

What character must be entered first for Excel to recognize a formula?

• -

• =

• $\ne$

• +

Which is NOT in the  $\Sigma$  menu?

• MIX

• SUM

• MAX

• MIN