MS EXCEL QUIZ

In Excel, a Data Series is defined as what?

A division of results

A collection of related data

A cell reference

A type of chart

TRUE ANSWER : ?
YOUR ANSWER : ?

Which button do you click to add up a series of numbers?

The quicktotal button

The total button

The Formula button

The autosum button

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Embedded

Linked

Use the word menu bar and toolbars

Hyperlinked placed in a word table

TRUE ANSWER : ?
YOUR ANSWER : ?

Paste special allows some operation while you paste to new cell. Which of the following operation is valid ?

Percentage

Divide

Goal seek

Square

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Doc

123

WK1

XLS

TRUE ANSWER : ?
YOUR ANSWER : ?

Comments can be added to cells using

Edit > Comments

File > Comments

Insert > Comments

View > Comments

TRUE ANSWER : ?
YOUR ANSWER : ?

What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ?

5436.8

5430

6.8

5436.80

TRUE ANSWER : ?
YOUR ANSWER : ?

A numeric value can be treated as label value if ___ precedes it.

Exclamation (!)

Apostrophe (')

Tilde (~)

Hash (#)

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not information you can specify using the solver?

Changing cells

Constraints

Input cells

Target cell

TRUE ANSWER : ?
YOUR ANSWER : ?

The Cancel and Enter buttons appear in the:

Title bar

Formula bar

Sheet tabs

Menu bar

TRUE ANSWER : ?
YOUR ANSWER : ?

↑