MS Excell MCQS

Which of the following isn’t a part of a spreadsheet?

A. a) row number
B. b) column number
C. c) column letter
D. d) cell address
Correct answer is: B. b) column number
Column numbers are not typically used in spreadsheets. They rely on column letters (A, B, C, ..., Z, AA, AB, ...) to identify columns.

A numeric data analysis tool that allows us to create a computerized ledger.

A. a) Word processing package
B. b) Spreadsheet package
C. c) Graphics package
D. d) Mathematical Package
Correct answer is: B. b) Spreadsheet package
Spreadsheet package: This type of software is specifically designed for working with numerical data. It allows you to create a computerized ledger by organizing data into rows and columns, similar to a traditional paper ledger. You can perform calculations, create formulas, and manipulate data in various ways.

Word processing package: This software is primarily used for creating and editing text documents. While it can handle some basic numerical data, it's not well-suited for in-depth numerical analysis or creating complex ledgers.

Graphics package: This software focuses on creating and manipulating visual elements like images, drawings, and charts. While it can be used to represent numerical data visually, it doesn't offer the functionalities needed for a computerized ledger.

Mathematical Package: This type of software provides advanced mathematical tools for complex calculations and analyses. While it can be used with numerical data, it's not specifically designed for creating ledgers.

Therefore, spreadsheet software is the best choice for creating a computerized ledger due to its ability to organize, manipulate, and analyze numerical data in a tabular format.

 In a spreadsheet, letters are used to represent _

A. a) Cells
B. b) Rows
C. c) Columns
D. d) Blocks
Correct answer is: D. d) Blocks
In a spreadsheet, letters are used to represent columns. Numbers are used to represent rows. For example, cell C3 refers to the cell that is in column C and row 3.

A combination of a row and a column in a spreadsheet is called a?

A. (A) Line
B. (B) Column
C. (C) Row
D. (D) Cell
Correct answer is: D. (D) Cell

_________ allows to enter new data at the current position of the cursor?

A. Word Wrap
B. Insert Text
C. insertion Mode
D. Over-type Mode
Correct answer is: D. Over-type Mode
null

Scroll to Top