NSDA Com L-3 Test-5

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

• Pie Chat

• Column Chart

• Line Chart

• Dot Graph

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

• 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

A computer on internet is identified by:

• E-mail address

• Street address

• IP address

• None of the above

Which one is not a Function in MS Excel?

• SUM

• MAX

• AVG

• MIN

Functions in MS Excel must begin with ____

• An () sign

• An Equal Sign

• A Plus Sign

• A>Sign

Which function in Excel checks whether a condition is true on 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