COPA Module 7 : Spread Sheet Application

How Cells are named in MS Excel?

• Alphabetically

• Numerically

• Alphanumerically

• Special Character

Answer explanation

Cells in MS Excel are named alphanumerically, combining letters and numbers to form unique identifiers for each cell.

What is the maximum limit of rows in MS Excel 2010?

• 1084567

• 1048567

• 1048576

• 1084576

Answer explanation

The correct answer is 1048576 because that is the maximum limit of rows in MS Excel 2010.

What is the maximum limit of column in MS Excel 2010?

• 16384

• 16438

• 16843

• 16348

Answer explanation

The maximum limit of columns in MS Excel 2010 is 16384, which is the correct choice among the options provided.

Which bar lies top of the window in Excel Screen?

• Status Bar

• Ruler

• Title Bar

• Scroll Bar

Answer explanation

The Title Bar lies at the top of the window in Excel Screen, not the Status Bar, Ruler, or Scroll Bar.

How rows are numbered in MS Excel?

• Alphabetically

• Numerically

• Alphanumerically

• Special characters

Answer explanation

Rows in MS Excel are numbered numerically, starting from 1 and increasing sequentially. Each row is identified by a number rather than alphabetically or using special characters.

How columns are named in MS Excel?

• Alphabetically

• Numerically

• Alphanumerically

• Special characters

Answer explanation

Columns in MS Excel are named alphabetically, starting from column A and moving to the right with subsequent letters of the alphabet.

Which tab is used to include pivot table, charts and hyperlinks to a spread sheet?

• Insert

• Page Layout

• Data

• Review

Answer explanation

The tab used to include pivot table, charts, and hyperlinks to a spreadsheet is the Insert tab.

Which tab in Excel is used when importing, querying, outlining and subtotalling the data placed into a worksheet’s data list?

• Formula

• Data

• Review

• Insert

Answer explanation

The 'Data' tab in Excel is used when importing, querying, outlining, and subtotalling the data placed into a worksheet's data list.

Which tab in Excel is used for proofing, protecting, and marking up a spread sheet?

• Formula

• Data

• Review

• Insert

Answer explanation

The 'Review' tab in Excel is used for proofing, protecting, and marking up a spreadsheet, making it the correct choice.

What type of software is MS Office?

• Application Software

• Operating System

• Programming Language

• System Software

Answer explanation

MS Office is classified as Application Software because it is designed to perform specific tasks for the user, such as word processing, spreadsheet creation, and presentation design.