Excel Basics | MCQs

Explanation

MS-Excel is based on Windows.

MS-Excel is a spreadsheet

Developed by Microsoft for Windows.

It is a program that stores and retrieves numerical data in rows and columns of grid format.

Explanation

The active cell in MS-Excel is simply a rectangular box that highlights the sheet in excel.

Explanation

An apostrophe (') can be used to treat a numeric value as a label value.

When an apostrophe precedes a numeric value, Excel recognizes it as text instead of a number.

****

RY17-012-23

Explanation

A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet. 

For example, C1 refers to the cell at the intersection of column C and row 4; D5 refers to the second cell in column D, and so on.

It is basically a cell's column number and row number.

Explanation

Data form  effective ways to record time of data entry in Excel

****

ND20-1-2023

Explanation

• In a computer spreadsheet, cell range A3 through G3 should be keyed in as  A3:G3