Free Excel Trivia Questions and Answers — 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.

TRUE
FALSE (Correct answer)

Correct answer: FALSE

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.

sum
worksheet
cell (Correct answer)
chart

Correct answer: cell

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 ___.

cell cluster
chart
cell range (Correct answer)
multicell

Correct answer: cell range

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?

in the bottom-right corner of the selected cell (Correct answer)
in Backstage view
on the right side of the Home tab on the Ribbon
at the beginning of any formula or function

Correct answer: in the bottom-right corner of the selected cell

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?

It’s using conditional formatting.
It’s using a formula.
It’s using the Currency number format. (Correct answer)
It’s using an absolute cell reference.

Correct answer: It’s using the Currency number format.

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.

Question 6: To switch between Workbooks, click the tabs at the bottom of a workbook.

permissions
formulas
worksheets (Correct answer)
number formats

Correct answer: worksheets

To switch between different sheets within the same Excel workbook, you click on the worksheet tabs located at the bottom of the workbook window. Each tab represents a separate worksheet, allowing users to organize and access different sets of data or calculations within a single file. This provides an easy way to navigate through complex workbooks.

Question 7: Say you are looking for your average grade. What's wrong with the image's formula, exactly?

It should use the COUNT function instead.
It should use quotation marks instead of parentheses.
It should have an equals sign (=) at the beginning. (Correct answer)
There is nothing wrong with the formula.

Correct answer: It should have an equals sign (=) at the beginning.

In Excel, every formula or function must begin with an equals sign (=). This tells Excel that the cell contains a calculation rather than just text or a number. Without the leading equals sign, Excel would treat the input as a text string instead of executing the function to calculate the average grade.

Question 8: True or False: By double-clicking the cell that the formula is located in, you can view the formula.

TRUE (Correct answer)
FALSE

Correct answer: TRUE

True. Double-clicking on a cell that contains a formula is a quick and common way to view and edit the formula directly within the cell. This action puts the cell into edit mode, displaying the formula rather than its calculated result. It allows users to easily inspect the components and references used in the calculation.

Question 9: Which of the following is a reference to an absolute cell?

#A2
A:2
A2
$A$2 (Correct answer)

Correct answer: $A$2

An absolute cell reference in Excel is denoted by dollar signs ($) before both the column letter and the row number, such as $A$2. This type of reference ensures that when a formula is copied or filled to other cells, the reference to cell A2 remains fixed and does not change. This is crucial when you want a formula to always refer back to a specific cell, regardless of its new location.

Question 10: Which of the following formulas is true? Please check all that apply.

A3+100
=F2+F3+F4-53
=5B+6B
=R2*D2 (Correct answer)

Correct answer: =R2*D2

A valid Excel formula must begin with an equals sign (=) and correctly reference cells or values using appropriate operators. Option D, `=R2*D2`, is a valid formula because it starts with an equals sign and uses standard cell references (R2 and D2) with a multiplication operator (*). The other options are incorrect because they either lack the initial equals sign or use invalid cell reference formats.

Question 11: What result would this formula in Excel produce? =(82-32)/5+8*2

7.69
26 (Correct answer)
91.6
36

Correct answer: 26

Excel follows the standard order of operations (PEMDAS/BODMAS) to evaluate formulas. First, the operation inside the parentheses (82-32) is calculated, resulting in 50. Next, division (50/5) and multiplication (8*2) are performed, yielding 10 and 16 respectively. Finally, the addition (10+16) is completed, resulting in the final answer of 26.

Question 12: What tool did we employ in order to swiftly apply the formatting displayed in this picture?

PivotTables
Data scenario formatting
What-if analysis
Conditional formatting (Correct answer)

Correct answer: Conditional formatting

The formatting displayed in the picture, which often involves visual cues like color scales, data bars, or icon sets based on cell values, is achieved using Conditional Formatting. This Excel feature allows you to automatically apply specific formatting to cells that meet certain criteria or conditions. It helps to visually highlight important data, trends, or outliers within a dataset.

Question 13: What is the primary benefit of choosing Mark as Final?

It prevents other users from viewing the workbook.
It ensures that the workbook is free of errors.
It prevents other users from editing the workbook.
It discourages other users from editing the workbook. (Correct answer)

Correct answer: It discourages other users from editing the workbook.

Choosing 'Mark as Final' in Excel sets a read-only recommended flag on the workbook, signaling that the author considers it complete and final. While it doesn't strictly prevent editing, it discourages other users from making changes by displaying a warning message upon opening. This feature is primarily a communication tool to indicate the document's intended status.

Question 14: In this illustration, a _______ is made using the four areas.

subtotal
PivotTable (Correct answer)
complex formula
custom filter

Correct answer: PivotTable

The illustration shows the four distinct areas (Filters, Columns, Rows, and Values) used to organize and summarize data in Excel. These areas are fundamental components of a PivotTable, which is a powerful tool for analyzing and presenting large datasets. By dragging fields into these areas, users can dynamically create customized reports and insights from their data.

Question 15: Which feature determines the input value that will provide a desired outcome after starting with a desired result?

Reverse formula
Data validation
SmartArt
Goal seek (Correct answer)

Correct answer: Goal seek

Goal Seek is an Excel feature that determines the input value required to achieve a specific desired result (outcome) from a formula. Instead of manually adjusting input values, you tell Excel the target value you want for a formula and which input cell to change. Excel then iteratively calculates the necessary input to reach that goal.

Question 16: What does an Excel workbook mean?

a sheet of paper with printed data on it
a collection of files in a folder
a file that stores one or more worksheets (Correct answer)
a type of chart

Correct answer: a file that stores one or more worksheets

An Excel workbook is the primary file type in Microsoft Excel, serving as a container for your data. It is a single file that can store one or more individual worksheets (also known as spreadsheets). Worksheets are where you input, organize, and analyze your data using cells, rows, and columns.

Free Excel Trivia Questions and Answers

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.