Spreadsheet for Data Analysis I

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

• Column

• Value

• Address

• Cell

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.

What do you use to create a chart?

• Pie Wizard

• Excel Wizard

• Data Wizard

• Chart Wizard

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 one is not a Function in MS Excel ?

• SUM

• AVG

• MAX

• MIN

____ appear at the bottom of the Excel window.

• Title bar

• Formula bar

• Work sheet tabs

• Name box