Question 1

The active cell is always highlighted in yellow.

Accepted Answer

The active cell is typically highlighted with a thicker border, not necessarily in yellow; the color can vary based on the software or settings used.

Question 2

Blank workbook is a type of Excel template you can choose.

Accepted Answer

A blank workbook is indeed a type of Excel template that you can choose. It opens with no pre-made worksheets or formatting, allowing you to create your own custom spreadsheet from scratch.

Question 3

E44 is an example of a cell pointer, also called a cell address.  _________________________

Accepted Answer

False

Question 4

When you type something in a cell and then press Enter, the cell pointer moves to the first cell of the next row. _________________________

Accepted Answer

When you press enter, the cell pointer moves to the first cell of the next row.

Question 5

A(n) value is text that describes data in a worksheet. _________________________

Accepted Answer

A label is text that describes data in a worksheet, not a value. Values typically refer to numerical data.

Question 6

Double-clicking a column boundary automatically widens the column to fit the longest entry in the column using a feature called AutoComplete. _________________________

Accepted Answer

Double-clicking a column boundary automatically widens the column to fit the longest entry in the column using a feature called AutoFit, not AutoComplete. AutoComplete is used for completing text entries based on previously entered values.

Question 7

You can add more worksheets to a workbook if you need more than the default number.

Accepted Answer

This is true, you can add additional worksheets to a workbook in Excel.

Question 8

The AVERAGE function is so common it has its own button on the Home tab. _________________________

Accepted Answer

The answer of The AVERAGE function is so common it...

Question 9

When Excel guesses which word you want to type after you enter the first letter, you are experiencing a feature known as AutoComplete.  _________________________

Accepted Answer

AutoComplete is the feature in Excel that guesses and completes a word for you after you enter the first letter.

Question 10

The name box shows the address of the selected cell.

Accepted Answer

The name box, also known as the cell address bar, displays the reference or address of the active or selected cell in a worksheet.

Question 11

The formula bar shows the address of the selected cell.

Accepted Answer

The formula bar in spreadsheet software displays the content or formula contained in the active cell, not the address of the selected cell.

Question 12

A worksheet is an electronic grid in which you can perform numeric calculations.

Accepted Answer

A worksheet is indeed an electronic grid in which you can perform numeric calculations. Common examples of electronic worksheets include Microsoft Excel and Google Sheets.

Question 13

Sometimes a worksheet or workbook is referred to as a spreadsheet.

Accepted Answer

This is true. The terms worksheet, workbook, and spreadsheet are often used interchangeably to refer to the same thing in Microsoft Excel and other similar programs.

Question 14

When you resize a row by dragging, the pointer becomes a two-headed arrow. _________________________

Accepted Answer

When resizing a row by dragging, the pointer does become a two-headed arrow.

Question 15

You can edit cell contents by double-clicking a cell. _________________________

Accepted Answer

Double-clicking a cell allows you to edit its contents directly.

Question 16

A1-C5 is an example of a cell range reference.

Accepted Answer

The answer of A1-C5 is an example of a cell...

Question 17

The active sheet in a workbook is in bold on the sheet tab.

Accepted Answer

The active sheet in a workbook is always displayed in bold on the sheet tab.

Question 18

Every cell in a worksheet has it own unique cell pointer.

Accepted Answer

Every cell in a worksheet has its own unique cell address, not a unique cell pointer. The cell pointer refers to the currently selected cell or the location of the cursor in the worksheet, which can only be in one place at a time.

Question 19

Labels are numeric data that can be used in calculations. _________________________

Accepted Answer

Labels typically refer to categorical data used for identification or classification, and are not used in mathematical calculations like numeric data.

Question 20

A group of selected cells that share boundaries is called a cell range. _________________________

Accepted Answer

A cell range is defined as a group of two or more cells within a spreadsheet that share a common boundary. These cells can be selected and manipulated as a group, allowing for quicker and more efficient data manipulation.

Quiz 4: Excel