Spreadsheet | MCQs

Explanation

Manual calculation mode means that Excel will only recalculate all open workbooks when we request it by pressing F9.

Explanation

MS Excel is specifically designed to create and manage spreadsheets for data entry, calculation, and analysis.

It organizes data in rows and columns, and supports formulas, charts, and functions.

Explanation

A spreadsheet is also known as a workbook.

A workbook is a file that contains one or more spreadsheets, which are made up of cells, rows, and columns.

The terms "spreadsheet" and "workbook" are often used interchangeably, but a workbook can contain multiple spreadsheets, while a spreadsheet is a single sheet within a workbook.

Explanation

Cells are the basic building blocks of a worksheet.

Explanation

The Transpose() function in MS Excel, helps to interchange the values of rows to columns and vice versa.

It function returns a vertical range of cells as a horizontal range.

Explanation

A spreadsheet (Excel) is a computer application or program that enables the user to tabulate and collate data.

Explanation

Excel is a spreadsheet programme

Explanation

Explanation

Most databases and spreadsheets (like Excel or Google Sheets) allow users to freely add or delete rows and columns.

This flexibility helps in updating or organizing data as per requirements.

Explanation

A spreadsheet consists of a table of cells arranged into rows and columns and referred to by the X and Y locations

the columns are normally represented by letters, "A," "B," "C," etc.,

while

rows are normally represented by numbers, 1, 2, 3, etc.

SH31-07-2023