Excel 2007 Function/Formula Recap Quiz
This quiz is to test your knowledge and understanding of the two Excel trainings we have provided.
- 1.
Angela Swift Paul Velasco Shawna RaeWhat of the below functions or Formulas could be used to combine the above data into one cell for each row?
- A.
Join
- B.
Concatenate
- C.
Text to Columns
- D.
Find/Replace
Correct Answer
B. ConcatenateExplanation
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.Rate this question:
-
- 2.
Angela Swift Paul Velasco Shawna RaeYou need to break up the names above into two separate columns, what function and sub-function would you use?
- A.
Right with Conditional Formatting
- B.
Left with Delimiters
- C.
Text to Columns with Fixed Width
- D.
Text to Columns with Delimiters
Correct Answer
D. Text to Columns with DelimitersExplanation
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.Rate this question:
-
- 3.
In Excel what is the difference between =6+2/2 and =(6+2)/2?
- A.
Nothing, they are the same and both give and answer of 7
- B.
Nothing, they are the same and both give and answer of 4
- C.
They are processed in different orders; the first would give an answer of 7 and the second would give 4
- D.
They are processed in different orders; the first would give an answer of 4 and the second would give 7
Correct Answer
C. They are processed in different orders; the first would give an answer of 7 and the second would give 4Explanation
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.Rate this question:
-
- 4.
ABCD1234 EFGH5678 IJKL9012Would I use Right or Left to keep the letters in each of the above?
- A.
Right
- B.
Left
Correct Answer
B. LeftExplanation
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.Rate this question:
-
- 5.
What does pressing CTRL + SHIFT + RIGHT ARROW do?
- A.
Selects all of the data to the right until a blank cell is encountered
- B.
Selects the entire row
- C.
Activates the task bar
- D.
Opens Excel Options
Correct Answer
A. Selects all of the data to the right until a blank cell is encounteredExplanation
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.Rate this question:
-
- 6.
Where is the status bar located on the screen in Excel?
- A.
Above the document and below the ribbon
- B.
In the Review Ribbon
- C.
With Excel Options
- D.
Above the Taskbar and below the document
Correct Answer
D. Above the Taskbar and below the documentExplanation
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.Rate this question:
-
- 7.
True or false, the formula Exact is used to compare two cells and will provide back the result of "Yes" if the cells match?
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 8.
What does the use of a "$" in a formula do?
- A.
Gives your results back in currency format
- B.
Gives your results back in accounting format
- C.
Creates a fixed array for your formula
- D.
Creates an array for when using multiple formulas for a single solution
Correct Answer
C. Creates a fixed array for your formulaExplanation
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.Rate this question:
-
- 9.
Dana Tami Dana Dana Tami Tami Dana TamiI need to create a formula that would show me the number of times each of the names appears above, what function should I use?
- A.
Countif
- B.
Sum
- C.
Total
- D.
Count
Correct Answer
A. CountifExplanation
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.Rate this question:
-
- 10.
Conditional Formatting formats cells when certain conditions are met, what is the problem that you could run into when using Conditional Formatting?
- A.
It can show up differently to a customer based on their theme
- B.
It can overwrite formulas
- C.
It is so complicated to setup that it is easy to miss a step
- D.
It overlays other formatting in the same cells
Correct Answer
D. It overlays other formatting in the same cellsExplanation
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.Rate this question:
-
- 11.
Which of the below is the correct process to create an IF formula?
- A.
Click the fx button, search for/open up the IF function, enter a Logical_test, enter a Value_if_false, enter a Value_if_true
- B.
Click the fx button, search for/open up the IF function, enter a Value_if_true, enter a Logical_test, enter a Value_if_false
- C.
Click the fx button, search for/open up the IF function, enter a Logical_test, enter a Value_if_true, enter a Value_if_false
- D.
Click the fx button, search for/open up the IF function, enter a Value_if_true, enter a Value_if_false, enter a Logical_test
Correct Answer
C. Click the fx button, search for/open up the IF function, enter a Logical_test, enter a Value_if_true, enter a Value_if_falseExplanation
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.Rate this question:
-
- 12.
Please describe the difference between changing the format of 1.3756901 to currency and using the ROUND formula to 2 decimal place. a. What would the answer be if you added $2.57 to the formatted number? b. What would the answer be if you added $2.57 to the rounded number?
- 13.
Where can you insert a comment?
- A.
Only in the top row
- B.
In any cell
- C.
Only in headers
- D.
In any cell that has a value in it
Correct Answer
B. In any cellExplanation
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.Rate this question:
-
- 14.
You can use vLookup to find data in different worksheets but not different workbooks.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 15.
Macros
- A.
Automate repetitive tasks.
- B.
Will auto-sum all the Number/Currency formatted cells in your workbook.
- C.
Create a table of all the data you have selected.
- D.
Can be used on any set of data no matter of the formatting.
Correct Answer
A. Automate repetitive tasks.Explanation
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.Rate this question:
-
Back to top