MS Excel quiz

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

• Pie chart

• Column chart

• Line chart

• Dot graph

Which function excel tells how many numeric entries are there?

• Num

• Count

• Sum

• Chknum

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

• Column

• Value

• Address

• Cell

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

• Powerpoint

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 function 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