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()

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()

The command to get the current date and time in MS Excel?*

If you type a date entry as 4/31/2021, what does Excel do?

4. In Open Office Calc, ___ function displays current date in the selected cell.

Which shortcut key is used for calculating current sheet in Ms Excel?AShift+F9BF7CF9DCtrl+F9