Functions Flashcards

Excel formulae all start with the same symbol.

Answer: +

In Microsoft Excel, every formula must begin with an equals sign (=). This symbol signals to Excel that the cell contains a calculation or a function rather than just text or a numerical value. Without the equals sign, Excel would treat the input as plain text.

A selection of several cells is referred to as a

Answer: Range

In Excel, a 'range' refers to a group of two or more cells that are selected or referenced together. Ranges can be contiguous (adjacent) or non-contiguous and are fundamental for applying functions, formatting, or performing calculations across multiple cells simultaneously. For example, A1:C5 denotes a range of cells.

Worksheets are a type of ___.

Answer: A single page in a workbook

An Excel file is called a workbook, and within each workbook, there can be multiple individual 'worksheets' (also known as spreadsheets). Each worksheet is a grid of cells where data is entered and manipulated. This structure allows for organizing different sets of data or analyses within a single file.

Which of the following formulas will add B2's value to C3's value?

Answer: =B2+C3

To perform an addition in Excel, you start with an equals sign (=) followed by the cell references you want to add, separated by a plus sign (+). Therefore, '=B2+C3' correctly instructs Excel to take the value from cell B2 and add it to the value from cell C3.

Which of the following formulations for the IF function is correct?

Answer: =IF(condition, condition if true, condition if false)

The IF function in Excel evaluates a logical test (condition) and returns one value if the condition is true, and another value if the condition is false. Its correct syntax is =IF(condition, value_if_true, value_if_false). This structure allows for conditional logic within spreadsheets, making it a powerful tool for decision-making.

This is an equation.

Answer: =SUM(A1:A5)

In Excel, an equation or formula always starts with an equals sign (=). '=SUM(A1:A5)' is a valid Excel formula that uses the SUM function to add up all the numerical values within the range of cells from A1 to A5. This is a common and correct way to perform calculations in a spreadsheet.

Which view of a worksheet displays the worksheet's header and footer sections?

Answer: Page layout view

Page Layout view in Excel is specifically designed to show how a worksheet will look when printed, including margins, headers, and footers. This view allows users to easily add, edit, and preview these elements directly on the page. It provides a 'what you see is what you get' perspective for print preparation.

The purpose of the word "=SUM" at the start of an Excel spreadsheet formula is

Answer: To add all the data together using addition only.

The 'SUM' function in Excel is specifically designed to calculate the total of a range of numbers. When used in a formula like '=SUM(A1:A5)', it instructs Excel to add up all the numerical values within the specified range. This is a fundamental function for aggregation and basic arithmetic in spreadsheets.

Which of the following calculations uses an Excel spreadsheet the most frequently?

Answer: All of the above

Excel spreadsheets are versatile tools used across various domains. They are extensively used for managing and analyzing data, performing complex numerical calculations, and particularly for financial modeling, budgeting, and accounting. Therefore, all these applications represent frequent and core uses of Excel.

Cell addresses are used in formulas as:

Answer: Cell referencing

When you use a cell address (like A1, B5, or C10) within an Excel formula, you are performing 'cell referencing.' This means the formula will use the value currently stored in that specific cell to perform its calculation. Cell referencing is crucial for creating dynamic and interconnected spreadsheets, allowing formulas to update automatically when referenced cell values change.

Which function is capable of displaying various values according to various conditions?

Answer: IF

The IF function is Excel's primary tool for conditional logic. It allows you to specify a condition and then return one value if that condition is true, and a different value if the condition is false. This enables the spreadsheet to display different outputs based on varying criteria, making it highly flexible for decision-making.

What are the parenthesis for in an Excel formula like =(A1+A2)*B1?

Answer: They indicate the order in which operations should be performed.

In Excel formulas, just like in standard mathematics, parentheses are used to define the order of operations. Operations within parentheses are calculated first. In the example '=(A1+A2)*B1', the sum of A1 and A2 is calculated before the result is multiplied by B1, ensuring the correct mathematical sequence and precedence.

What VLOOKUP function is using the right arguments out of the following list?

Answer: =VLOOKUP(G5, Products!$A$2:$C$20, 3, FALSE)

The VLOOKUP function has a specific syntax: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). Option A correctly provides all four arguments: G5 as the lookup value, Products!$A$2:$C$20 as the table array (with absolute references for stability), 3 as the column index from which to return a value, and FALSE for an exact match. This structure is essential for accurate data retrieval.

What is the purpose of data validation? Please check all that apply.

Answer: Prevent inconsistent data from being entered

Data validation in Excel is a powerful feature used to control and restrict the type of data or values that users can enter into a cell. It helps maintain data integrity by preventing inconsistent entries, can be used to create drop-down lists for predefined choices, and generally ensures that data adheres to specified rules, thereby improving accuracy and consistency. Applying colors and formatting based on cell values is Conditional Formatting, not Data Validation.

What is the Excel formula for summing a column of numbers?

Answer: =SUM(A1:A10)

The `SUM` function is the standard Excel formula used to add up a range of numbers. By specifying a range like `A1:A10`, the function calculates the total of all values within those cells. Options like `TOTAL` or `ADD` are not valid Excel functions for this purpose.

What kind of cell reference does Excel use by default?

Answer: Relative

Excel uses relative cell references by default, meaning that when a formula is copied or filled to other cells, the cell references within the formula automatically adjust based on their new position. This dynamic adjustment is fundamental to Excel's efficiency, allowing formulas to be easily applied across rows or columns without manual modification.