MS EXCEL QUIZ

65535

256

1024

1048576

There is no way to copy and apply formatting in Excel – You have to do it manually

The Edit > Copy Format and Edit>Paste Format commands form the menu

The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu

The Format Painter button on the standard toolbar

It is the formula bar

Is defined by a bold border around the cell

Only A and B

Receives the data the user enters

Replace cell references

Concatenate and manipulate text

Show formula error value

Return ASCII values of characters

Delete

Clear Delete

Clear Contents

Clear All

Excel adjusts absolute cell references

Excel doesn’t adjust relative cell references

Excel edits cell references in the newly copied formula

Excel erases the original copy of the formula

Functioning

Referencing

Updating

Accessing

You have to work hard to create it

It can contain many sheets including worksheets and chart sheets

It can be modified

It can contain text and data

Area

All of the listed here

Line

Pie

A chart legend

A set of values you plot in a chart

A data label

A collection of chart data markers