# Excel 2007 Function/Formula Recap Quiz

15 Questions | Total Attempts: 349  Settings  This quiz is to test your knowledge and understanding of the two Excel trainings we have provided.

• 1.
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?
• 2.
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

• 3.
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

• 4.
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

• 5.
ABCD1234 EFGH5678 IJKL9012Would I use Right or Left to keep the letters in each of the above?
• A.

Right

• B.

Left

• 6.
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.

• D.

Opens Excel Options

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

• 8.
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

• 9.
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

• 10.
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

• 11.
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

• 12.
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

• 13.
Where can you insert a comment?
• A.

Only in the top row

• B.

In any cell

• C.

• D.

In any cell that has a value in it

• 14.
You can use vLookup to find data in different worksheets but not different workbooks.
• A.

True

• B.

False

• 15.
Macros
• A.

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

Related Topics Back to top