MS Excel Basics

Front

____________is the electronic spreadsheet program.

Back

MS Excel

Answer explanation

MS Excel is the electronic spreadsheet program used for calculations, data analysis, and visualization. In contrast, MS Word is for word processing, MS PowerPoint for presentations, and MS Teams for collaboration.

Front

A _________ is the intersection of a row and column.

Back

cell

Answer explanation

A cell is the specific point where a row and a column intersect in a table or spreadsheet. It is the correct term for this intersection, while 'box' and 'pointer' do not accurately describe this concept.

Front

In Excel, a row is denoted by ________

Back

Numbers

Answer explanation

In Excel, rows are identified by numbers (1, 2, 3, etc.), while columns are identified by letters (A, B, C, etc.). Therefore, the correct answer is 'Numbers'.

Front

In Excel, Column is denoted by ___________

Back

Letters

Answer explanation

In Excel, columns are represented by letters (A, B, C, etc.), while rows are represented by numbers. Therefore, the correct answer is 'Letters'.

Front

Which of the following is not a correct cell address? 2D, A27, BB15, All of the above

Back

2D

Answer explanation

The correct cell addresses must consist of a letter followed by a number. '2D' does not follow this format, making it an incorrect cell address. 'A27' and 'BB15' are valid addresses.

Front

Which feature automatically fills in values?

Back

AutoFill

Answer explanation

The AutoFill feature automatically fills in values based on a pattern or data in adjacent cells, making it the correct choice. Other options like Paste, Wrap Text, and Merge and Center do not provide this functionality.

Front

This is the name of the cell in the worksheet that is currently selected.

Back

Active cell

Answer explanation

The correct answer is 'Active cell' because it refers to the currently selected cell in a worksheet, which is highlighted for user interaction. Other options do not accurately describe this concept.

Front

Tabs on the Ribbon are divided into _____?

Back

Groups

Answer explanation

Tabs on the Ribbon in applications like Microsoft Office are organized into 'Groups'. Each group contains related commands, making it easier for users to find and use the tools they need.

Front

A group of selected cells is called the

Back

Range

Answer explanation

A group of selected cells in a spreadsheet is referred to as a 'Range'. This term is commonly used in applications like Excel to denote multiple cells that can be manipulated together.

Front

____________ allows you to click and drag it to fill in cells that follow a known pattern; you know you're using this tool when your cursor is on the bottom right of a cell and is a skinny plus sign.

Back

autofill, auto-fill

Answer explanation

The correct answer is 'autofill'. This feature allows users to click and drag the fill handle (the skinny plus sign) at the bottom right of a cell to automatically fill adjacent cells following a pattern.