In excel if a hyperlink is established against any text it transformed into _______ .Select one:YELLOWORANGEBLUERED

When inserting a hyperlink, what can you link to? Select all that apply.

When you link data maintained in an excel workbook to a word documentThe word document cannot be editThe word document contains a reference to the original source applicationThe word document must contain a hyperlinkThe word document contains a copy of the actual data

rue or False: Hyperlinks in a Word document will always point to a web site. Select one: True False

As you record a macro, excel converts your actions in _____.Select one:A.FormulaeB.HyperlinkC.VBA codeD.Shortcuts

Q21. What is the short key of Filter in Ms-Excel? Ctrl + L Shift + L Ctrl + Shift + L Shift + Alt + LQ22. MS Excel is a ________. Word Processing Program Spreadsheet Program Presentation Program None of the aboveQ23. Which function will you use to enter current Date & time in a worksheet cell ? =currentTime() =time() =now() All of the aboveQ24. What is the short key of hyperlink? Shift + K Ctrl + K Alt + K Ctrl + Shift + KQ25. How many types of Page Orientation in Excel ? 1 2 3 4Q26. What does the VLOOKUP function do? Looks up text that contain V Checks whether text is the same in one cell as in the next Finds related records None of theseQ27. What is the use of =datedif() formula ? For Calculating the Age For Current Date For Current Time None of theseQ28. Which formula is convert negative value to positive value ? =int() =abs() =gcd() =mod()Q29. which formula is used to find out the reminder of division ? =quetient() =mod() =abs() =int()Q30. Which formula is used to change small word in to capital word ? =capital() =proper() =upper() =lower()