## Computer Science MCQs Section 3

The answers of questions marked with * are subject to change with time

**To create a table of columns and rows for mathematical calculation or statistical representation which programme is used?**

A. WordPad**B. MS Excel**

C. MS Word

D. Auto CAD

**SI PCD-16/Asst Punjab Police-20**

**Which one is a spreadsheet program that belongs to MS Office?**

A. MS Word**B. MS Excel**

C. MS PowerPoint

D. MS Photo Editor

**Naib Tehsildar Paper II-20 (Lhr)**

**MS Excel is a ______ program.**

A. Document

B. Presentation**C. Spreadsheet**

D. All of above

**Labour Inspector-19**

**Latest version of MS Excel?***

A. Excel 2013

B. Excel 2007**C. Excel 2019**

D. Excel 2016

**Asst S&GAD-18/Punjab Treasury Deputy Acct-19 (M)**

**How many worksheets are there in Excel Workbook by default?**

A. One

B. Two**C. Three**

D. Four

**Lecturer (Urdu) Female PHED-21**

**_____ users can open MS Excel 2016 file at the same time.**

A. 100

B. 50**C. 256**

D. 305

**DEO Punjab Police-20**

**In MS Excel the intersection of columns and rows is called a:**

A. Data

B. Table**C. Cell**

D. Schema

**DEO PPD-20/Junior Clerk ATC-20**

**Rows in MS Excel are labelled as:**

A. A1, A2, etc**B. 1, 2, 3, etc**

C. A, B, C, etc

D. $A$1, $A$2, etc

**Junior Clerk LHC-18**

In MS Excel columns are labelled as A, B, C, etc.

**Maximum number of rows in MS Excel 2016 worksheet is:***

A. 364

B. 30,000**C. 1,048,576**

D. 10,024

**Zilladar-20**

Excel 2003 and earlier 65,536 rows.

Excel 2007 and higher 1,048,576 rows.

**Maximum number of columns in MS Excel 2019 worksheet is:**

A. 364

B. 30,000**C. 16,384**

D. 10,324

**Junior Clerk ATC-20**

**In MS Excel, a data series is defined as:**

A. A collection of results

B. A collection of metadata**C. A collection of related data**

D. A cell reference

**Naib Tehsildar Paper II-20 (Lhr)**

**To change one row to column and one column to row is called:**

A. Merging

B. Alternative**C. Transpose**

D. Addition

**Divisional Coach YASATD-19**

**In Excel, spacing in column is called as:**

A. Paper Size**B. Stirrups***

C. Page Layout

D. All of above

**Asst Punjab Employees Social Security LHRD-19 (2)**

**Which of the following are valid Minimum and Maximum zoom sizes in MS Excel?**

A. 25% to 100%**B. 10% to 400%**

C. 50% to 500%

D. 100% to 400%

**Asst Livestock Regular Basis-20/DEO PPD-20/Asst POPC S&GAD-20 (Contract Basis)/Junior Clerk ATC-20**

**Which of the following is NOT a valid Zoom percentage in Excel?**

A. 10

B. 100**C. 500**

D. 300

**Asst Punjab Police-20**

**Which of the following is NOT a valid zoom percentage in Excel?**

A. 20

B. 150**C. 600**

D. 200

**Asst PESSI LHRD-21**