Free Excel Formulas Questions and Answers — Questions and Answers

Question 1: A _______ is a collection of cells.

chart
cell cluster
multicell
cell range (Correct answer)

Correct answer: cell range

A cell range in Excel refers to a collection of two or more cells that are selected or referenced together. It can be a contiguous block of cells, a single row, a single column, or even non-contiguous cells. Cell ranges are fundamental for applying formulas, formatting, or performing operations on multiple cells simultaneously.

Question 2: True or False: Excel will always let you know if a formula you've constructed has a flaw.

TRUE
FALSE (Correct answer)

Correct answer: FALSE

Excel can identify syntax errors in formulas, such as missing parentheses or incorrect function names, and will often display an error message. However, it cannot detect logical flaws or incorrect calculations if the formula is syntactically correct but produces an unintended result. Users must carefully review their formulas to ensure they accurately reflect their desired calculations.

Question 3: Which formula might you apply to the following graphic to deduct the inventory expenses from the monthly budget?

=B3/B2
=B2-B3 (Correct answer)
=SUM(B2:B3)
=B3=B2

Correct answer: =B2-B3

To deduct inventory expenses from the monthly budget, you need to subtract the value in the cell representing expenses from the value in the cell representing the budget. Assuming B2 contains the monthly budget and B3 contains the inventory expenses, the formula `=B2-B3` correctly performs this subtraction. This will give you the remaining budget after expenses.

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

$B2$
B2
B$2$
$B$2 (Correct answer)

Correct answer: $B$2

An absolute cell reference in Excel is used to keep a cell reference constant when a formula is copied or filled to other cells. It is denoted by placing a dollar sign ($) before both the column letter and the row number, such as `$B$2`. This ensures that the formula always refers back to the exact same cell, regardless of where it is moved.

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

C8+C7
=J5+C21/D21 (Correct answer)
=A+B+C
=1-M2 (Correct answer)

Correct answer: =J5+C21/D21

In Excel, a valid formula must begin with an equals sign (=). Both `=J5+C21/D21` and `=1-M2` correctly start with an equals sign and use valid cell references and arithmetic operators. Options A and C are not valid formulas because they lack the initial equals sign, which tells Excel to perform a calculation.

Question 6: Which of the following comes first in the order of events?

Operations enclosed in parentheses (Correct answer)
Operations involving large numbers
Exponential calculations
Multiplication

Correct answer: Operations enclosed in parentheses

Excel follows the standard order of operations, often remembered by the acronym PEMDAS/BODMAS. This dictates that operations enclosed in parentheses are always performed first. This allows users to control the sequence of calculations within a complex formula, ensuring specific parts are evaluated before others.

Question 7: What does an Excel number format mean?

A feature that automatically adds numbers in Excel
A format that tells Excel how to display data in a cell (Correct answer)
A formula that performs mathematical calculations in Excel
A function that rounds numbers up or down in Excel

Correct answer: A format that tells Excel how to display data in a cell

An Excel number format dictates how numerical data is visually presented in a cell, without changing the underlying value. For example, you can format a number as currency, a percentage, a date, or with a specific number of decimal places. This feature helps make data more readable and understandable for users.

Question 8: What does Excel's "Custom" number format mean?

A number format that you create to fit your specific needs (Correct answer)
A number format that only displays negative numbers
A number format that is automatically applied to every cell in a worksheet
A number format that rounds numbers up or down

Correct answer: A number format that you create to fit your specific needs

Excel's 'Custom' number format allows users to define their own specific rules for how numbers, dates, and text are displayed in cells. This provides a high degree of flexibility, enabling you to create unique display formats that are not available in the standard options. You can use special codes to control decimal places, currency symbols, text placement, and more.

Question 9: What is the purpose of Excel's "General" number format?

It displays numbers as text.
It displays numbers as dates.
It displays numbers with no decimal places.
It applies the default number format to a cell. (Correct answer)

Correct answer: It applies the default number format to a cell.

The 'General' number format is the default format applied to cells in Excel. When a cell is formatted as General, Excel automatically determines the best way to display the number, often removing trailing zeros and not applying any specific currency, date, or percentage formatting. It essentially displays numbers as they are entered, without any special styling.

Question 10: How would you calculate the average of the data in cells A1 through A10?

=AVG(A1:A10)
=MEAN(A1:A10)
=TOTAL/A10
=AVERAGE(A1:A10) (Correct answer)

Correct answer: =AVERAGE(A1:A10)

To calculate the average of a range of cells in Excel, you use the `AVERAGE` function. The correct syntax involves specifying the range of cells you want to average within the parentheses. Therefore, `=AVERAGE(A1:A10)` will correctly compute the arithmetic mean of all numerical values from cell A1 through A10.

Question 11: What Excel multiplication symbol do you use?

-
* (Correct answer)
x
+

Correct answer: *

In Excel, the asterisk symbol `*` is universally used to perform multiplication. When creating formulas, you would place this symbol between the numbers or cell references you wish to multiply. For example, `=A1*B1` would multiply the values in cells A1 and B1.

Question 12: The numbers 75 and 75% are identical in Excel, correct or incorrect.

TRUE
FALSE (Correct answer)

Correct answer: FALSE

The numbers 75 and 75% are not identical in Excel. While 75 represents the integer value seventy-five, 75% represents seventy-five hundredths, which is equivalent to the decimal value 0.75. Excel interprets percentages as fractions of 1, so entering 75% is the same as entering 0.75.

Question 13: How would you add several numerical values? Which function?

SUM (Correct answer)
AVERAGE
TOTAL
COUNTA

Correct answer: SUM

To add several numerical values in Excel, the `SUM` function is the most appropriate and commonly used function. You can specify a range of cells, individual cells, or a combination, and the `SUM` function will calculate their total. For example, `=SUM(A1:A10)` would add all numbers in that range.

Question 14: Let's say you want to replicate a formula but lock one of the cell references to the original cell. Which option from the list would you choose?

Relative reference
PivotTable
Absolute reference (Correct answer)
ReferenceLock

Correct answer: Absolute reference

To replicate a formula while ensuring one of the cell references remains fixed on the original cell, you would use an absolute reference. An absolute reference is created by placing dollar signs ($) before the column letter and row number (e.g., `$B$2`). This prevents the cell reference from changing when the formula is copied to other locations.

Question 15: Which function can locate a cell range's highest value?

MAX (Correct answer)
HIGHEST
TOP
MAXVALUE

Correct answer: MAX

The `MAX` function in Excel is used to find the largest numerical value within a specified range of cells. You simply provide the cell range as an argument to the function, for example, `=MAX(A1:A10)`. Excel will then return the highest number found within that range.

Question 16: Which formula would we use to display the text Waffles: rabbit in this image?

=COMBINE(A2, B2)
=CONCATENATE(A2:B2)
=COMBINE(A:B)
=CONCATENATE(A2, ": ", B2) (Correct answer)

Correct answer: =CONCATENATE(A2, ": ", B2)

To display the text 'Waffles: rabbit' by combining the contents of cells A2 and B2 with a colon and space in between, you would use the `CONCATENATE` function. The correct formula is `=CONCATENATE(A2, ": ", B2)`. This joins the text from A2, the literal string ": ", and the text from B2 into a single string.

Free Excel Formulas Questions and Answers

A _______ is a collection of cells.