Excel 2007 Function/Formula Recap Quiz

The difference between =6+2/2 and =(6+2)/2 in Excel is that they are processed in different orders. In the first equation, the division operation is performed first, resulting in 2. Then, the addition operation is performed, resulting in 6+2=8. Therefore, the answer is 7. In the second equation, the parentheses indicate that the addition operation is performed first, resulting in (6+2)=8. Then, the division operation is performed, resulting in 8/2=4. Therefore, the answer is 4.

The Countif function is used to count the number of cells within a range that meet a specific criteria. In this case, we want to count the number of times each name appears above. By using the Countif function with the criteria set to each name, we can get the desired result.

Concatenate is the correct answer because it is a function in Excel that is used to combine text from multiple cells into one cell. In this case, the names "Angela", "Swift", "Paul", "Velasco", "Shawna", and "Rae" can be combined into one cell using the Concatenate function.

You can insert a comment in any cell of a spreadsheet. Comments are used to provide additional information or explanations about the data in a cell. This can be helpful for collaboration or for adding notes to the data for future reference.

This answer is correct because macros are used to automate repetitive tasks. Macros are sets of instructions that can be recorded or written in a programming language to perform a series of actions automatically. By using macros, users can save time and effort by automating tasks that they frequently perform.

The statement is incorrect. vLookup can be used to find data not only in different worksheets but also in different workbooks. vLookup is a function in Excel that allows you to search for a value in a specific column of a table and retrieve a corresponding value from another column in the same row. This function can be used across multiple worksheets within the same workbook or even across different workbooks by specifying the workbook and worksheet names in the formula. Therefore, the correct answer is False.

Pressing CTRL + SHIFT + RIGHT ARROW selects all of the data to the right until a blank cell is encountered. This shortcut is commonly used in Excel to quickly select a range of data in a row. It is useful when you want to select a specific section of data without manually dragging the mouse or scrolling through the spreadsheet.

The letters in each of the given sequences are arranged in a left-to-right order. Therefore, to keep the letters in each sequence, we would use the "Left" direction.

The correct process to create an IF formula is to click the fx button, search for/open up the IF function, enter a Logical_test, enter a Value_if_true, and finally enter a Value_if_false.

The use of a "$" in a formula creates a fixed array for your formula. This means that when the formula is copied or dragged to other cells, the cell references with the "$" will remain fixed, while the other cell references will adjust relative to the new location. This is useful when you want to keep certain references constant in a formula, such as when calculating a running total or referencing a specific cell in a range.

The status bar in Excel is located above the Taskbar and below the document. It is a horizontal bar that displays information about the current status of the spreadsheet, such as the sum of selected cells, the average value, or the current page number. It also provides quick access to certain features, such as zooming in and out, changing the view mode, or enabling macros.

The formula "Exact" is used to compare two cells and will provide back the result of "True" if the cells match, not "Yes". Therefore, the given statement is incorrect, making the answer "False" the correct one.

When using Conditional Formatting, one problem that could arise is that it overlays other formatting in the same cells. This means that if there are already existing formatting settings applied to a cell, such as font color or cell borders, the Conditional Formatting may override those settings and replace them with its own formatting rules. This can lead to confusion and inconsistency in the appearance of the cells, especially when multiple formatting rules are applied.

To break up the names into two separate columns, you would use the "Text to Columns with Delimiters" function. This function allows you to specify a delimiter, such as a comma or space, to separate the text into different columns. In this case, you would use a space as the delimiter to separate the first name and last name into separate columns.