MS EXCEL QUIZ

Which function is not available in the Consolidate dialog box ?

Average

Max

Pmt

Sum

TRUE ANSWER : ?
YOUR ANSWER : ?

Which would you choose to create a bar diagram?

Tools, Chart

Format, Chart

Edit, Chart

Insert, Chart

TRUE ANSWER : ?
YOUR ANSWER : ?

To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

Split command on the window menu

Hold titles command on the edit menu

Unfreeze panes command on the window menu

Freeze panes command on the window menu

TRUE ANSWER : ?
YOUR ANSWER : ?

What symbol is used before a number to make it a label ?

_ (underscore)

" (quote)

= (equal)

' (apostrophe)

TRUE ANSWER : ?
YOUR ANSWER : ?

To remove the content of selected cells you must issue ___ command

Clear Delete

Clear All

Clear Contents

Delete

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not an example of a value?

0.57

Serial Number 50771

350

May 10, 2001

TRUE ANSWER : ?
YOUR ANSWER : ?

In the formula, which symbol specifies the fixed columns or rows ?

%

*

&

$

TRUE ANSWER : ?
YOUR ANSWER : ?

To save a workbook, you:

Press Ctrl+ F5

Click Save on the Windows Start button

Select Edit > Save

Click the save button on the standard toolbar from the menu

TRUE ANSWER : ?
YOUR ANSWER : ?

Which command will you choose to convert a column of data into row?

None of above

Both of above

Cut and Paste

Paste Special > Transpose

TRUE ANSWER : ?
YOUR ANSWER : ?

You can use the drag and drop method to

Add cell contents

Move cell contents

Copy cell contents

Copy cell contents & Move cell contents

TRUE ANSWER : ?
YOUR ANSWER : ?

↑