Ninth Chapter Solved Exercise MCQs Of ICS First Year Computer Science

Ninth Chapter Solved Exercise MCQs of ICS First Year Computer Science offers a collection of multiple-choice questions with answers, tailored for ICS students. This resource helps students review key concepts, practice for exams, and improve their understanding of the second chapter in Computer Science.

Ninth chapter solved MCQs with explanation

1. Which of the following is a spreadsheet?

(a) MS Word

(b) MS Excel

(c) MS PowerPoint

(d) Both b&a

Explanation: MS Excel is a spreadsheet application used for creating, organizing, and analyzing data in tables. MS Word is a word processor, and MS PowerPoint is a presentation software.

2. The actual working area in Microsoft Excel is

(a) Workbook

(b) Worksheet

(c) Spreadsheet

(d) Note sheet

Explanation: A worksheet is the actual working area in Microsoft Excel where you enter data and create formulas. A workbook contains multiple worksheets.

3. Which of the following is an absolute address?

(a) Al

(b) A1S

(c) A$1$

(d) None of the above

Explanation: An absolute address is a cell reference that remains constant even when the formula is copied or moved. It is denoted by using the dollar sign ($) before the row or column number. None of the given options are absolute addresses.

4. Formula can only be applied on

(a) Values

(b) Labels

(c) Unmerged cells

(d) None of the above

Explanation: Formulas can be applied to a combination of values, labels, and merged cells. They are used to performing calculations and manipulate data.

5. Which of the following function is used to get the current date?

(a) Exact()

(b) Today()

(c) Month()

(d) Year()

Explanation: The TODAY() function is used to return the current date in Microsoft Excel. The other functions (EXACT(), MONTH(), and YEAR()) are used for different purposes.