MS EXCEL QUIZ | EXAMIANS

The auto calculate feature

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

Automatically creates formulas and adds them to a worksheet

Can only add values in a range of cells

A and C

TRUE ANSWER : ?
YOUR ANSWER : ?

You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

Column chart

Line chart

Row chart

Pie chart

TRUE ANSWER : ?
YOUR ANSWER : ?

When a range is selected, how can you activate the previous cell ?

Press the Alt key

Press Enter

None

Press Tab

TRUE ANSWER : ?
YOUR ANSWER : ?

A circular reference is

Always erroneous

Geometric modeling tool

A cell that points to a drawing object

A formula that either directly or indirectly depends on itself

TRUE ANSWER : ?
YOUR ANSWER : ?

When integrating word and excel, word is usually the

Server

Both b and c

Destination

Client

TRUE ANSWER : ?
YOUR ANSWER : ?

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ?

Press Ctrl + Home

Press Home

Press Alt + Home

Press Shift + Home

TRUE ANSWER : ?
YOUR ANSWER : ?

MS - EXCEL is based on ___

OS/2

UNIX

WINDOWS

DOS

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Linked

Use the word menu bar and toolbars

Hyperlinked placed in a word table

Embedded

TRUE ANSWER : ?
YOUR ANSWER : ?

How can you delete a record?

Delete the column from the worksheet

Select Data > Delete Record from the menu

Click the Delete button on the Standard toolbar

Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button

TRUE ANSWER : ?
YOUR ANSWER : ?

Which elements of a worksheet can be protected from accidental modification?

Contents

Scenarios

All of the listed here

Objects

TRUE ANSWER : ?
YOUR ANSWER : ?