Intermediate Excel Test
0 of 11 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 11 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)
Question 1 of 11
As per spreadsheet image, we want to create a formula in cell J4 which will work out the commission due to Lorraine. The Commission rate is in Cell F1. We will want to copy down these formulas. From the list below which is the most effective formula.CorrectIncorrect
Question 2 of 11
As per spreadsheet image, we want to create an IF Function in cell I2 and copy ,which will output True if the commission is greater than or equal to 350 or leave the cells empty if not.
Pick the IF Function below which does this.CorrectIncorrect
Question 3 of 11
We want to create a VLOOKUP Function in cell D12, which will return the Wednesday sales figures for whatever sales person is entered into cell C12.
Which of the VLOOKUP Functions below is the best.CorrectIncorrect
Question 4 of 11
We need to create a SUMIF Function in cell G4,which will give us the total minutes played for whatever band is typed into Cell F4.
Which of the SUMIF Functions below is correct and the most effective.CorrectIncorrect
Question 5 of 11
I need to create a formula in D2 downwards which will only show loans from identifiers in column A beginning with US. Which of the formulas below do this successfully?CorrectIncorrect
Question 6 of 11
What number does Excel associate with the date 2 December 2014?CorrectIncorrect
Question 7 of 11
I have created a dropdown box in sheet1 like the image below.
I want to create the same dropdown list in sheet2, which of the statements below is True?CorrectIncorrect
Question 8 of 11
Because the cell in C12 is empty, the VLOOKUP Function in D12 is showing the #N/A Error message. How can we hide this error message. Which of the following will do this effectively?CorrectIncorrect
Question 9 of 11
I want to create a macro of a logo which I want to be able to place in different positions in various worksheets of various workbooks.
What much I make sure I do?CorrectIncorrect
Question 10 of 11
I have various conditional formats on my worksheet. I just need to delete one of them. How do I do this?CorrectIncorrect
Question 11 of 11
I have a value in cell A1 in Sheet1 worksheet and I have a value in cell A1 in sheet2 worksheet.
I want to create a formula in worksheet Sheet3 which will add them together.Which is the correct formula.CorrectIncorrect