FREE Excel Trivia Questions and Answers

Question 1

Click the worksheet tab of the sheet you wish to copy, hold down SHIFT, and then drag the chosen sheet along the row of sheet tabs to copy the complete worksheet and all of its data.

Accepted Answer

FALSE

Answer

The statement is false because holding down SHIFT while dragging a worksheet tab allows you to select multiple adjacent worksheets, not copy a single one. To copy a worksheet in Excel, you must hold down the CTRL key while dragging the sheet tab. This creates a duplicate of the entire worksheet.

Question 2

A _______ is the term for the point where a row and a column intersect.

Accepted Answer

cell

Answer

In Microsoft Excel, a cell is the fundamental building block of a worksheet. It is defined as the unique intersection point where a row and a column meet. Each cell has a unique address, such as A1 or B5, and can contain data, formulas, or functions.

Question 3

A cell cluster is referred to as a ___.

Accepted Answer

cell range

Answer

A cell range refers to a group or cluster of contiguous cells in an Excel worksheet. It is typically identified by the addresses of the top-left and bottom-right cells, separated by a colon (e.g., A1:C5). Cell ranges are frequently used when applying formatting, performing calculations, or defining data sets for functions.

Question 4

What location does the fill handle have?

Accepted Answer

in the bottom-right corner of the selected cell

Answer

The fill handle in Excel is a small square located in the bottom-right corner of the selected cell or range. It is a powerful tool used to quickly copy data, formulas, or extend a series of data (like numbers or dates) into adjacent cells. When you hover over it, your cursor changes to a thin black cross.

Question 5

Why does the value in cell G1 in this image appear to be somewhat different from the value in the formula bar?

Accepted Answer

It’s using the Currency number format.

Answer

The difference between the value displayed in cell G1 and the formula bar indicates that the cell's value is being presented with a specific number format. In this case, the Currency number format is applied, which typically adds a currency symbol (like '$') and formats the number to two decimal places. This makes it appear slightly different from the raw numerical value or formula shown in the formula bar.

Excel Practice Test

Excel Practice Test

FREE Excel Trivia Questions and Answers