Excel Formulas and Functions Basics

<p>PRODUCT (D)</p> Signup and view all the answers

<p>A worksheet refers specifically to one spreadsheet within a program. (B)</p> Signup and view all the answers

<p>Labels, values, or formulas (B)</p> Signup and view all the answers

<p>Using the correct prefix for function arguments (A)</p> Signup and view all the answers

<p>Lower left corner of the screen (C)</p> Signup and view all the answers

<p>=HLOOKUP() (B)</p> Signup and view all the answers

<p>30 (C)</p> Signup and view all the answers

<p>=TODAY() (C)</p> Signup and view all the answers

<p>Clicking on Evaluate Formula in the Formula tab (C)</p> Signup and view all the answers

<p>=SUMIFS() (C)</p> Signup and view all the answers

<p>Press Ctrl+Shift+Enter (B)</p> Signup and view all the answers

<p>Values in the first column (D)</p> Signup and view all the answers

<p>The range must be named (D)</p> Signup and view all the answers

<p>Values down the first row of the range (B)</p> Signup and view all the answers

<p>=VLOOKUP(revenue, $A$3:$C$7, 3, FALSE) (A)</p> Signup and view all the answers

<p>To ensure it doesn't change as you copy the formula to other cells (C)</p> Signup and view all the answers

<p>The relative column number of the target data (C)</p> Signup and view all the answers

<p>Incorrect data retrieval from a horizontal range (D)</p> Signup and view all the answers

<p>It adds cells that match a specified condition. (B)</p> Signup and view all the answers

<p>SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2]) (B)</p> Signup and view all the answers

<p>It enables the running of a function across a range of cells at once. (A)</p> Signup and view all the answers

<p>To determine which values from the second range will be summed. (C)</p> Signup and view all the answers

<p>It combines the values in B2:B5 where A2:A5 values exceed $160,000. (C)</p> Signup and view all the answers

<p>SUMIF uses one criterion, while SUMIFS allows for multiple criteria. (A)</p> Signup and view all the answers

<p>It calculates the product of the cells in E4:E13 and G4:G13 and sums the results. (A)</p> Signup and view all the answers

<p>=SUMIFS(G4:G13, B4:B13, 'Bumpers', C4:C13, 'Continental') (D)</p> Signup and view all the answers

A program that displays data (text and numbers) in a table called a worksheet.

A grid with columns and rows. Often used interchangeably with the term spreadsheet.

The intersection of a row and column.

Words or letters for labeling rows and columns.

Numbers or numeric values.

Statements that perform a calculation.

A group of cells that are closely together.

Vertical arrangement of cells identified by letters.

Horizontal arrangement of cells identified by numbers.

Identifies each open worksheet in a spreadsheet program. Located in the lower left corner of the screen.

The foundation of Excel, used to calculate cells, numbers, and other data in a workbook.

Order of operations in which Excel performs calculations. Excel follows the standard order of operations: Parentheses, Exponents, Multiplication and Division (from left to right), Addition and Subtraction (from left to right).

Refers to a specific cell in a worksheet using the column letter and row number (e.g., A1, B2).

Built-in algorithms used in formulas, usually appearing as prefixes, that perform a variety of calculations.

Pre-built algorithms embedded in Excel that automatically perform calculations and data manipulation.

Instructions for Excel to perform calculations, manipulations, and data retrieval.

Inputs or values that a function takes to perform its operation. They can be cell references, numbers, text, or other functions.

Uses the PRODUCT function to multiply numbers from different cells.

Adds cells that meet specific criteria. Example: =SUMIF(A2:A5,">160000",B2:B5) adds values in Column B where Column A values are greater than $160,000.

Allows multiple criteria for summing. Example: =SUMIFS(G4:G13,B4:B13,"Bumpers",C4:C13,"Continental") sums values in Column G where Column B values are "Bumpers" and Column C values are "Continental."

Perform functions on a set of values. Indicated by curly braces {}. Example: {=SUM(E4:E13*G4:G13)} sums the product of values in ranges E4:E13 and G4:G13.

Joins up to 30 text items. Example: =CONCATENATE(text1, text2, [text3],...) combines text1, text2, and optional subsequent text values into a single string.

Returns the current date. =TODAY()

Returns the current date and time. =NOW()

Add days to the current date. =TODAY()+7 returns the date seven days from today.

Use Evaluate Formula (Alt + TUF) to step through a formula and see each calculation.

Searches the first column of a table for a value and returns a value from the same row in another column.

Similar to VLOOKUP, but searches across the first row of a range.