Test: Excel Functions- 1 - Primary 6 MCQ

Column letters and row numbers in Excel uniquely identifies cells within a worksheet with a cell name.

We can use drag-and-drop to embed excel worksheet data in a word document by dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key.

An apostrophe before a cell value forces Excel to interpret the value as label. This is mostly useful for values that look like a number or date.

Tab scrolling button allow us to view additional sheets tabs.

A worksheet range is a group of cells.

The chart wizard term data series refers to a collection of chart data markers.

Excel 2003 and earlier 65,536 Rows.
Excel 2007 and higher 1,048,576 Rows.

Excel 2003 and earlier 256
(as label ‘IV’) columns.
Excel 2007 and higher 16,384 (as label ‘XFD’) columns.

A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.
Here in option D 10+50 there is no equal sign (=), so it is not correct.

An apostrophe before a cell value forces Excel to interpret the value as label. This is mostly useful for values that look like a number or date.