Learn complete data analysis in excel using pivots in less than 30 minutes. Click here to visit. Be updated with all the latest happenings in business, tax, cricket, movies, startups all at one place. Click here to visit. 0% 20 questions need to be finished within 20 Minutes. Scroll down for more information. Time’s up. Wait result is loading. Excel Basic Certification Score 75% or above to clear this test. NameEmailPhone Number 1 / 20 What result does =indirect(h6) gives? 80 N/A error 90 2 / 20 What are the shortcuts to select row, select column, add new row/column? Shift + space; ctrl + space; ctrl + shift + + None of the abovve Ctrl + space; ctrl + shift + +; Shift + space 3 / 20 What will be the output in cells A2,A3? 105;100 100;105 105;105 4 / 20 what will be the output for below formula? Tiger War Hrithik War Error 5 / 20 What will be the output in cells B8, C8? 10%,10% 0%,10% N/A error, 10% 6 / 20 What will be the output when we use below formula with = sign before formula in Q34? 2 1 0 Error 7 / 20 what will be the output for below formula? 13,35 35,35 0,35 35,0 8 / 20 what will be the output for below formula? Error 0 Check Input 9 / 20 Where is remove duplicates located? Insert Menu Formulas Menu Data Menu 10 / 20 what is the NPV and IRR for below information? npv = 88.43 irr =65% npv = 188.43 irr =55% npv = 43.88 irr =45% 11 / 20 If you want to calculate total sales value, which below method gives very quick result? Multiply sale with price then sum all Need to use only option a as option b cant be used in this case Use sumproduct in this case 12 / 20 To hold row and column titles in place so that they do not scroll when you scroll a worksheet, We will use ? Hold titles command on the edit menu Unfreeze panes command on the window menu Freeze panes command on the window menu Split command on the window menu 13 / 20 what will be the output in cells B3, B4 ? error, 28-09-2020 27-09-2020, 28-09-2020 28-09-2020, 28-09-2020 14 / 20 what will be the output for below formula? 15 4 2 15 / 20 What are the shortcuts to move to next sheet within sheet, shortcut to move to other active excel sheet ? ctrl+ pg dn ; ctrl + tab ctrl+ shift +pg dn ; Shift + tab None of the above 16 / 20 Which of the following is an absolute cell reference? $A$1 A!1! A1 17 / 20 what will be the output for below formula? 100 0 10 18 / 20 To change rows data to columns and vice versa, we can use? use paste special then click transpose both of above transpose function 19 / 20 what will be the Output in Cell D2? 24 10 22 20 / 20 Calculate EMI for below information. 43125 46145 45145 Your score is 0% Loan Calculation 1 file(s) 169.24 KB Download Activity 1 file(s) 1.77 MB Download Click on enable macros for activity file and complete the task in 30 seconds.
