EXCEL - TEST 1

Which function in Excel tells how many numeric entries are there ?

• NUM

• SUM

• COUNT

• CHKNUM

A features that displays only the data in column (s) according to specified criteria

• Formula

• Filtering

• Sorting

• Pivot

Statistical calculations and preparation of tables and graphs can be done using

• Power Point

• Notepad

• Adobe Photoshop

• Excel

Which one is not a Function in MS Excel ?

• SUM

• AVG

• MIN

• MAX

Functions in MS Excel must begin with ___

• An () sign

• An Equal Sign

• A Plus Sign

• A > Sign

In Excel, Columns are labelled as ___

• A, B, C, etc

• 1,2,3 etc

• A1, A2, etc.

• $A$1, $A$2, etc.

The process of arranging the items of a column in some sequence or order is known as :

• Arrangin

• Autofill

• Sorting

• Filtering

The ____ feature of MS Excel quickly completes a series of data

• Auto Complete

• Auto Fill

• Sorting

• Fill Handle

The basic unit of a worksheet into which you enter data in Excel is called a

• cell

• Box

• Column

• Table

What is the intersection of a column and a row on a worksheet called ?

• Column

• Value

• Address

• Cell