Formulas Flashcards

A _______ is a collection of cells.

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.

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

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.

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

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.

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

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.

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

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.

Which of the following comes first in the order of events?

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.

What does an Excel number format mean?

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.

What does Excel's "Custom" number format mean?

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.

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

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.

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

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.

What Excel multiplication symbol do you use?

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.

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

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.

How would you add several numerical values? Which function?

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.

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?

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.

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

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.

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

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.