MS EXCEL QUIZ

A and C

Automatically creates formulas and adds them to a worksheet

Provides a quick way to view the result of an arithmetic operation on a range of cells

Can only add values in a range of cells

Choose the new command from the file menu

Enter the formula using any input values and the appropriate mathematical operators that make up your formula

Type the equals sign (=) to tell Excel that you’re about to enter a formula

Select the cell you want to place the formula into

Split command on the window menu

Freeze panes command on the window menu

Hold titles command on the edit menu

Unfreeze panes command on the window menu

Excel edits cell references in the newly copied formula

Excel erases the original copy of the formula

Excel adjusts absolute cell references

Excel doesn’t adjust relative cell references

When many sheets are selected

When no sheet is selected

One sheet is selected

None of the listed here

Java

Visual Basic

C

Visual C++

Click the object command on the insert menu

Click the create worksheet button on the formatting toolbar

Click the office links button on the standard toolbar

Click the import excel command on the file menu

=SUM(A1:A5)/(10-10)

=SUM(A1:A5)-10

=SUM(A1:A5)*0.5

=SUM(Sales)-A3

Embedded

Use the word menu bar and toolbars

Linked

Hyperlinked placed in a word table

AutoFill

Auto sum

Auto correct

Auto format