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