MS EXCEL

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

• Column

• Value

• Address

• Cell

What type of chart is useful for comparing values over categories ?

• Pie Chart

• Column Chart

• Line Chart

• Dot Graph

Which functionin Excel tells how many numeric entries are there ?

• NUM

• COUNT

• SUM

• CHKNUM

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

• Formula

• Sorting

• Filtering

• Pivot

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

• Adobe Photoshop

• Excel

• Notepad

• Power Point

What type of chart will you use to compare performance of two employees in the year 2016 ?

• Column Chart

• Line Chart

• Pie Chart

• Dot Chart

Which one is not a Function in MS Excel ?

• SUM

• AVG

• MAX

• MIN

Functions in MS Excel must begin with ___

• An () sign

• An Equal Sign

• A Plus Sign

• A > Sign

Which functionin Excel checks whether a condition is true or not ?

• SUM

• COUNT

• IF

• AVERAGE

In Excel, Columns are labelled as ___

• A, B, C, etc

• 1,2,3 etc

• A1, A2, etc.

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