0 of 15 Questions completed
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 15 Questions answered correctly
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Look at the formula designed as below, what will be shown on C1 if the formula is applied?
You are writing a formula to get the count with condition, as below. Which of the following is correct?
In the image below, you have a excel sheet with Employee information, but unfortunately it has only the employees’ full name. Your manager is asking you to split the full name into last and first names. You are designing the formula to do so, and what are the most likely functions you are going to use for this task?
In an Excel working environment, the following terms are in use often:
2. Excel Application
4. Worksheet (Sheet)
Based on the Excel working hierarchy, what of the following describes the containable levels in which Excel works structurally?
You are asked to generate a list of Sales ID with the title, as below. You are designed the formula using VLookup. When giving the file with the formula to the requester, you are told that the result does not seem to be working properly all times. What could be the fix?
You have a sample data about product-packing info, and you want to make up a calculation formula on column D, and for this sample row data, to display “70 Bottles”. What would be your formula look like, with consideration of future use of the formula on more data rows?
You are creating a report with looking up the title based on employee ID, as below, what value will be displayed on the next cell as questioned?
Look at the show below, and you want to use a formula to get the first 4 digits of Credit card on column O, so we have the financial company’s code shown on column P. Which one of the following is correct?
You are to create an Excel Macro for doing a task, which of the following is correct format of Excel Marco?
When writing VBA code, you want to locate a button on the sheet to run your VBA when the button is clicked. If the button is named btnGetOrder, which of the following is most correct format of the event sub definition?
In the VBA code below, what does the pointed line do there?
You are creating a For-Next loop to populate a list of years on column, which of the following is correct to enclosing the loop?
In your Excel VBA, you created form to execute a special task, when completing, you want the code to close the form itself so that the whole process can finish itself. What of the following is the way to make the form closed?
You have an Excel file to save from your VBA, which exports the reporting data into the final Excel file to the disk, as the show below:
What is the result of the code run above?
As the last step of a report with VBA, you need to have a series of actions to save the do some ending steps to finish up the report, as below:
Which of the following alternative way can do the same thing?