MS excel Archives - Govtexamresults

Connect with us

4 weeks ago
Which of the following keyboard shortcuts is used to navigate from one worksheet in the next in the decreasing order of worksheet numbers
Correct Answer is: Ctrl + pgUp Explanation: Ctrl + pgUp keyboard shortcuts is used to navigate from one worksheet in the next in the decreasing order...
4 weeks ago
Which feature is used to freeze rows and columns of a large worksheet in Excel 2010 to keep them in view while scrolling.
Correct Answer is : Freeze Panes Explanation: Freeze panes is a feature in spreadsheet applications, such as Microsoft Excel, that “locks” a row or column in...
4 weeks ago
In MS Excel , if cell B4 contain 60, then formula =LEN(B4) computer _____
Correct Answer is: 2
4 weeks ago
In Excel , FLOOR function belongs to which category of functions ?
Correct Answer is : Math and trigonometry Explanation: The Excel FLOOR function is a math formula that rounds a specific number down to the nearest specified...
4 weeks ago
In MS Excel enter the Jan into cell A1, select cell A1 and drag the fill handle down by five rows, cell A3 now contain
Correct Answer is: MAR