CPDS Quiz 1

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

• Column
• Value
• Address
• Cell

Which functionin Excel tells how many numeric entries are there ?

• NUM
• COUNT
• SUM
• CHKNUM

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

• Adobe Photoshop
• Excel
• Notepad
• Power Point

In Excel, Rows are labelled as ______

• A, B, C, etc
• 1,2,3 etc
• A1, A2, etc.
• $A$1, $A$2, etc.

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

• cell
• table
• box
• column

The Greater Than sign (>) is an example of _____ operator.

• Arithmatic
• Conditional
• Logical
• Greater

In Excel, which one denoted a range from B1 through E5

• B1 - E5
• B1 to E5
• B1$E5
• B1:E5

Functions in MS Excel must begin with ___

• An () sign
• An Equal Sign
• A Plus Sign
• A > Sign

 Which function is used to create a date with year, month, and day?

• DATE()
• DATEDIF()
• DATEVALUE()
• CURDATE()

Which one is not a Function in MS Excel ?

• SUM
• AVG
• MAX
• MIN