All Free Computer Science and IT MCQs with Answers

531. Which of following is not an element of computer spreadsheet interface?

• A. Pencil work
• B. Active cell
• C. Menu bar
• D. Workbook

Explanation: Pencil work is not a standard element of a spreadsheet interface. The active cell, menu bar, and workbook are all valid spreadsheet concepts or interface components.

532. Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as __________ ?

• A. Decoration
• B. Data appearance
• C. Functions
• D. Charting

Explanation: Charting is the spreadsheet capability of representing cell data graphically, including through pie charts. Decoration and data appearance do not name this specific spreadsheet function.

533. What is a cell in Excel?

• A. A row
• B. A column
• C. A unit of data
• D. A unit of formatting

Explanation: A cell is the basic unit at which a spreadsheet stores data, formed by the intersection of a row and a column. It is not itself an entire row, column, or merely a formatting unit.

534. In excel columns are labelled as____________?

• A. A, B, C, etc.
• B. 1, 2, 3, etc.
• C. A1, A2, A3, etc.
• D. $A$1, $A$2, etc.

Explanation: Excel labels columns with letters such as A, B, and C, while rows are labelled with numbers such as 1, 2, and 3. A1 is a cell reference combining a column letter with a row number.

535. which of the following is not a valid Zoom percentage in Excel?

• A. 10
• B. 100
• C. 300
• D. 500Spreadsheet Software

Explanation: Excel allows zoom levels from 10% to 400%, so 500% is outside the valid range. The other listed percentages fall within that range.

536. User developed instruction for excel are called__________?

• A. Progrms
• B. Macros
• C. Procedured
• D. All of these

Explanation: Macros are user-created instructions or small programs that automate repeated Excel tasks. “Programs” is too general, while the other spellings do not identify the Excel feature.

537. Which function calculates the largest value in a set of numbers in Excel?

• A. Average
• B. Count
• C. Minimum
• D. Maximum

Explanation: The MAX function returns the largest number in a selected set. MIN returns the smallest value, while AVERAGE calculates the mean and COUNT counts numeric entries.

538. What displays the content of active cell?

• A. Name box
• B. Row headings
• C. Formula bar
• D. None of these

Explanation: The formula bar shows the value or formula contained in the active cell and allows it to be edited. The Name Box identifies the cell address, such as A1.

539. In a computer spreadsheet, block of cells is called __________ ?

• A. Workbook
• B. Function
• C. Column
• D. Range

Explanation: A range is a group or block of cells, such as A1:C5. A workbook is the complete Excel file, not merely a selection of cells.

540. Microsoft Excel 2019 files have a default extension of___________?

• A. .Xlsx
• B. .Xls
• C. .excel
• D. .123Spreadsheet Software

Explanation: Excel 2019 uses the Office Open XML workbook format, whose default extension is .xlsx. The older .xls extension was mainly used by earlier Excel versions.