Free Excel Formulas Questions and Answers

Question 1

A _______ is a collection of cells.

Accepted Answer

cell range

Answer

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.

Accepted Answer

FALSE

Answer

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?

Accepted Answer

=B2-B3

Answer

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?

Accepted Answer

$B$2

Answer

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.

Accepted Answer

=J5+C21/D21

Answer

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.

Excel Practice Test

Excel Practice Test

Free Excel Formulas Questions and Answers