MS EXCEL QUIZ

The command Edit > Fill Across Worksheet is active only when

When no sheet is selected

One sheet is selected

When many sheets are selected

None of the listed here

TRUE ANSWER : ?
YOUR ANSWER : ?

Concatenation of text can be done using

Exclamation (!)

Hash (#)

Ampersand (&)

Apostrophe (')

TRUE ANSWER : ?
YOUR ANSWER : ?

Files created with Lotus 1-2-3 have an extension

XLS

123

WK1

Doc

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following options is not located in the page setup dialog box ?

Margins

Headers and Footers

Page Orientation

Page Break Preview

TRUE ANSWER : ?
YOUR ANSWER : ?

To create a formula, you can use:

Value and cell references

Cell references but not values

Values or cell references although not both at the same time

Values but not cell references

TRUE ANSWER : ?
YOUR ANSWER : ?

Edit > Delete command

Deletes the comment of cell

Deletes Formats of cell

Deletes selected cells

Deletes the content of a cell

TRUE ANSWER : ?
YOUR ANSWER : ?

Which symbol must all formula begin with?

(

+

@

=

TRUE ANSWER : ?
YOUR ANSWER : ?

Which is not the function of "Edit, Clear" command?

Delete formats

Delete contents

Delete cells

Delete notes

TRUE ANSWER : ?
YOUR ANSWER : ?

When you insert an excel file into a word document. The data are

Embedded

Linked

Hyperlinked placed in a word table

Use the word menu bar and toolbars

TRUE ANSWER : ?
YOUR ANSWER : ?

You cannot link excel worksheet data to a word document

With the copy and paste special commands

With the copy and paste buttons on the standard toolbar

With the right drag method

With a hyperlink

TRUE ANSWER : ?
YOUR ANSWER : ?

↑