MS EXCEL QUIZ

You can use the formula palette to

Enter assumptions data

Format cells containing numbers

Create and edit formula containing functions

Copy a range of cells

TRUE ANSWER : ?
YOUR ANSWER : ?

Multiple calculations can be made in a single formula using ___

Complex Formulas

Standard Formulas

Array formula

Smart Formula

TRUE ANSWER : ?
YOUR ANSWER : ?

Which menu option can be used to split windows into two ?

View > window > split

Review > window

View > split

Window > split

TRUE ANSWER : ?
YOUR ANSWER : ?

A worksheet can have a maximum of ________ number of rows.

1024

256

65535

1048576

TRUE ANSWER : ?
YOUR ANSWER : ?

The first cell in EXCEL worksheet is labeled as

A0

Aa

A1

AA

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is a popular DOS based spreadsheet package?

Word

Smart cell

Excel

Lotus 1-2-3

TRUE ANSWER : ?
YOUR ANSWER : ?

Excel probably considers the cell entry January 1, 2020 to be a

Label

Formula

Text string

Value

TRUE ANSWER : ?
YOUR ANSWER : ?

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

%

$

*

&

TRUE ANSWER : ?
YOUR ANSWER : ?

Which function is not available in the Consolidate dialog box ?

Max

Pmt

Sum

Average

TRUE ANSWER : ?
YOUR ANSWER : ?

Which key do you press to check spelling?

F7

F9

F3

F5

TRUE ANSWER : ?
YOUR ANSWER : ?

↑