BA 215 Project 1 flashcards

Question 1

What is the purpose of the SUM() function in Excel?

Accepted Answer

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.

Question 2

How do you extract a specific part of a text string using Excel?

Accepted Answer

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.

Question 3

What does the FIND() function do in Excel?

Accepted Answer

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.

Question 4

How can you determine the total number of characters in a text string in Excel?

Accepted Answer

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'.

Question 5

What information can the CELL() function provide?

Accepted Answer

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.

Question 6

What is the keyboard shortcut to convert a data range into an Excel Table?

Accepted Answer

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.

Question 7

What is the shortcut for saving your Excel workbook?

Accepted Answer

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

Question 8

How do you undo your last action in Excel?

Accepted Answer

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

Question 9

What are the standard shortcuts for copying and pasting in Excel?

Accepted Answer

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

Question 10

How can you edit the contents of a cell directly without retyping?

Accepted Answer

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

Question 11

What is the primary use of the F4 key when working with formulas?

Accepted Answer

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.

Question 12

How do you quickly switch between worksheets in an Excel workbook?

Accepted Answer

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

Question 13

What does the Ctrl+Arrow key combination do?

Accepted Answer

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

Question 14

What shortcut opens the 'Format Cells' dialog box?

Accepted Answer

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

Question 15

What is the best practice for building complex spreadsheets with similar components?

Accepted Answer

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

Question 16

How should data on a summary sheet be populated?

Accepted Answer

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

Question 17

What is a cross-sheet reference and how is it formatted?

Accepted Answer

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.

Question 18

Why are absolute references important when building robust spreadsheets?

Accepted Answer

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

Question 19

How can you diagnose and fix a circular reference error in Excel?

Accepted Answer

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