All Questions Ask question Search Order By: ActiveCategoryClear Filter 0 Votes 1 Ans Can we create shortcuts to Excel functions? 186 viewsT N W Changed status to publish 08/05/2020Microsoft Office 0 Votes 1 Ans What is the “What If” condition in Excel formulas? 141 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans How cell reference is useful in the calculation of excel? 139 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans What is the AND function does in Excel? 142 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans How can you disable the automating sorting in pivot tables? 137 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans Which function is used to determine the day of the week for a date in excel? 156 viewsT N W Changed status to publish 08/05/2020Microsoft Office 0 Votes 1 Ans What is the benefit of using formula in Excel sheet? 153 viewsT N W Changed status to publish 08/05/2020Microsoft Office 0 Votes 1 Ans What is the quick way to return to a particular area of a worksheet? 145 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans To move to the previous worksheet and next sheet, what keys will you press in excel? 141 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans What is IF function in Excel? 146 viewsT N W Changed status to publish 08/05/2020Microsoft Office 0 Votes 1 Ans How can you apply the same formatting to every sheet in a workbook in MS-Excel? 164 viewsT N W Changed status to publish 08/05/2020Microsoft Office 0 Votes 1 Ans What are left, right, fill and distributed alignments in excel? 131 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans What is the use of LOOKUP function in Excel? 152 viewsT N W Changed status to publish 08/05/2020Microsoft Office 0 Votes 1 Ans Difference between COUNT, COUNTA, COUNTIF and COUNTBLANK in Ms-Excel. 116 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans Explain the difference between SUBSTITUTE and REPLACE function in MS-Excel? 136 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans Explain workbook protection types in Excel. 155 viewsT N W Changed status to publish 08/05/2020Microsoft Office 0 Votes 1 Ans What could you do to stop the pivot table from loosing the column width upon refreshing of excel? 133 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans What is Freeze Panes in MS-Excel? 134 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans How can you disable automatic sorting in pivot tables of ms excel? 144 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans Which event do you use to check whether the Pivot Table is modified or not in Excel? 136 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans How do you open a command prompt when issuing a command? 139 viewsMehedi Hasan Answered question 08/05/2020Linux 0 Votes 1 Ans What is GUI? 135 viewsMehedi Hasan Answered question 08/05/2020Linux 0 Votes 1 Ans What is CLI? 134 viewsMehedi Hasan Answered question 08/05/2020Linux 0 Votes 1 Ans What is the importance of the GNU project? 132 viewsMehedi Hasan Answered question 08/05/2020Linux 0 Votes 1 Ans What is the basic difference between BASH and DOS? 191 viewsMehedi Hasan Answered question 08/05/2020Linux 1 2 3 Question and answer is powered by AnsPress.io