Skip to the content
Evara BA 215 Project 1

Key terms

39 terms from the guide and the flashcards.

Study these terms
  1. What is the purpose of the SUM() function in Excel?Essential Excel Functions

    The SUM() function adds up all the numbers in a specified range of cells. For example, =SUM(A1:A10) calculates the total of values from A1 through A10.

  2. How do you extract a specific part of a text string using Excel?Essential Excel Functions

    The MID() function extracts a specified number of characters from a text string, starting at a given position. For example, =MID(A1,5,3) pulls 3 characters from cell A1 starting at the 5th position.

  3. What does the FIND() function do in Excel?Essential Excel Functions

    The FIND() function locates the starting position of a specific character or text within a larger string. For instance, =FIND(")",A1) finds the position of the closing parenthesis in cell A1.

  4. How can you determine the total number of characters in a text string in Excel?Essential Excel Functions

    The LEN() function is used to count the total number of characters in a text string. For example, =LEN(A1) would return 11 if cell A1 contains 'Hello World'.

  5. What information can the CELL() function provide?Essential Excel Functions

    The CELL() function provides details about a cell, such as its format, location, or the workbook's filename. For example, =CELL("filename",A1) returns the file and sheet name where cell A1 is located.

  6. What is the keyboard shortcut to convert a data range into an Excel Table?Keyboard Shortcuts for Efficiency

    The keyboard shortcut Ctrl+T is used to quickly convert a range of data into an Excel Table, which offers benefits for data management and formula expansion.

  7. What is the shortcut for saving your Excel workbook?Keyboard Shortcuts for Efficiency

    Ctrl+S is the keyboard shortcut used to quickly save your current Excel workbook.

  8. How do you undo your last action in Excel?Keyboard Shortcuts for Efficiency

    The keyboard shortcut Ctrl+Z is used to undo the last operation performed in Excel.

  9. What are the standard shortcuts for copying and pasting in Excel?Keyboard Shortcuts for Efficiency

    Ctrl+C is the shortcut for copying selected content, and Ctrl+V is the shortcut for pasting it.

  10. How can you edit the contents of a cell directly without retyping?Keyboard Shortcuts for Efficiency

    Pressing the F2 key allows you to enter edit mode directly within the active cell to modify its contents.

  1. What is the primary use of the F4 key when working with formulas?Building Robust Spreadsheets: Best Practices

    The F4 key is used to toggle between relative, absolute, and mixed cell references in a formula, saving the need to manually type dollar signs.

  2. How do you quickly switch between worksheets in an Excel workbook?Keyboard Shortcuts for Efficiency

    Use Ctrl+Page Up to move to the previous sheet and Ctrl+Page Down to move to the next sheet.

  3. What does the Ctrl+Arrow key combination do?Keyboard Shortcuts for Efficiency

    Pressing Ctrl along with an arrow key jumps the cursor to the edge of the current contiguous data region in that direction.

  4. What shortcut opens the 'Format Cells' dialog box?Keyboard Shortcuts for Efficiency

    The keyboard shortcut Ctrl+1 opens the 'Format Cells' dialog box, providing access to various formatting options like number, alignment, and font.

  5. What is the best practice for building complex spreadsheets with similar components?Building Robust Spreadsheets: Best Practices

    Build one sheet perfectly first, thoroughly testing all formulas and formatting, before duplicating it to ensure consistency and reduce errors.

  6. How should data on a summary sheet be populated?Building Robust Spreadsheets: Best Practices

    All data on a summary sheet should pull directly from source sheets using formulas, rather than being manually typed, to ensure accuracy and consistency.

  7. What is a cross-sheet reference and how is it formatted?Building Robust Spreadsheets: Best Practices

    A cross-sheet reference is a formula that links to a cell on a different worksheet within the same workbook, typically formatted as =SheetName!Cell.

  8. Why are absolute references important when building robust spreadsheets?Building Robust Spreadsheets: Best Practices

    Absolute references (e.g., BB1) ensure that cell references in formulas remain constant when copied, preventing errors when referencing single inputs like tax rates.

  9. How can you diagnose and fix a circular reference error in Excel?Building Robust Spreadsheets: Best Practices

    Navigate to Formulas → Error Checking → Circular References in the Excel ribbon to identify and resolve formulas that refer back to themselves.

  10. SUM()

    An Excel function that adds up a range of cells, for example, =SUM(A1:A10).

  11. MID()

    An Excel function that extracts a specified number of characters from the middle of a text string, starting at a given position, for example, =MID(A1,5,3).

  12. FIND()Essential Excel Functions

    An Excel function that returns the starting position of one text string within another text string, for example, =FIND(")",A1).

  13. LEN()

    An Excel function that returns the number of characters in a text string, for example, =LEN(A1).

  14. CELL()Essential Excel Functions

    An Excel function that returns information about the formatting, location, or contents of a cell, such as the filename or sheet name, for example, =CELL("filename",A1).

  15. Ctrl+TKeyboard Shortcuts for Efficiency

    A keyboard shortcut used to convert a range of cells into an Excel Table, which offers enhanced functionality like auto-expanding formulas.

  16. Ctrl+SKeyboard Shortcuts for Efficiency

    A keyboard shortcut used to save the current workbook.

  17. Ctrl+ZKeyboard Shortcuts for Efficiency

    A keyboard shortcut used to undo the last action.

  18. Ctrl+C / Ctrl+VKeyboard Shortcuts for Efficiency

    Keyboard shortcuts used to copy selected content and paste it, respectively.

  19. F2

    A function key used to edit the contents of the active cell.

  20. F4

    A function key used to toggle through absolute, mixed, and relative cell references in a formula.

  21. Ctrl+Page Up/DownKeyboard Shortcuts for Efficiency

    Keyboard shortcuts used to switch between different worksheets in a workbook.

  22. Ctrl+ArrowKeyboard Shortcuts for Efficiency

    A keyboard shortcut used to jump to the edge of the current data region in the direction of the arrow key.

  23. Ctrl+1Keyboard Shortcuts for Efficiency

    A keyboard shortcut used to open the Format Cells dialog box.

  24. Ctrl+Shift+$Keyboard Shortcuts for Efficiency

    A keyboard shortcut used to apply the Currency format to selected cells.

  25. Absolute ReferenceBuilding Robust Spreadsheets: Best Practices

    A cell reference in a formula that remains constant when the formula is copied to other cells, indicated by dollar signs, e.g., BB1 or B$1.

  26. Excel TableKeyboard Shortcuts for Efficiency

    A structured range of data in Excel that provides enhanced features like automatic formula expansion and structured referencing.

  27. Cross-sheet ReferencesBuilding Robust Spreadsheets: Best Practices

    Formulas that link to cells on different worksheets within the same workbook, typically in the format =SheetName!Cell.

  28. Circular Reference ErrorBuilding Robust Spreadsheets: Best Practices

    An error that occurs when a formula refers back to its own cell, either directly or indirectly, creating an infinite loop.

  29. External Link WarningBuilding Robust Spreadsheets: Best Practices

    A prompt that appears when opening a workbook that contains links to other files, indicating that data might be pulled from outside the current file.

Made from class notes on Evara.