Basics of Excel

An Excel file is generally called a / an :

• E-Spreadsheet

• Worksheet

• Workbook

• Sheet

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

• cell

• table

• box

• column

Which one is not a Function in MS Excel ?

• SUM

• AVG

• MAX

• MIN

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

Functions in MS Excel must begin with ___

• An () sign

• An Equal Sign

• A Plus Sign

• A > Sign

In Excel, Columns are labelled as ___

• A, B, C, etc

• 1,2,3 etc

• A1, A2, etc.

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

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

• B1 - E5

• B1:E5

• B1 to E5

• B1$E5

In Excel, Auto Sum function is available location

• Formula Tab

• Home Tab

• Both Home & Formula Tab

• Neither Home nor Formula Tab

In Excel, Rows are labelled as ______

• A, B, C, etc

• 1,2,3 etc

• A1, A2, etc.

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