Excel 2007 Function/Formula Recap Quiz

15 Questions | By OSVU | Last updated: Mar 15, 2022 | Total Attempts: 349

Questions

Settings

Create your own Quiz

This quiz is to test your knowledge and understanding of the two Excel trainings we have provided.

Questions and Answers

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.
  
  Activates the task bar
- 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.
  
  Only in headers
- 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.
  
  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.