All Questions Ask question Search Order By: ActiveCategoryClear Filter 0 Votes 1 Ans Can we create shortcuts to Excel functions? 470 viewsT N W Changed status to publish 08/05/2020Microsoft Office 0 Votes 1 Ans What is the “What If” condition in Excel formulas? 374 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans How cell reference is useful in the calculation of excel? 365 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans What is the AND function does in Excel? 383 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans How can you disable the automating sorting in pivot tables? 377 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? 410 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? 411 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? 384 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? 375 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans What is IF function in Excel? 410 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? 437 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? 371 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans What is the use of LOOKUP function in Excel? 408 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. 352 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans Explain the difference between SUBSTITUTE and REPLACE function in MS-Excel? 371 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans Explain workbook protection types in Excel. 436 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? 369 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans What is Freeze Panes in MS-Excel? 365 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? 370 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? 366 viewsT N W Answered question 08/05/2020Microsoft Office 0 Votes 1 Ans How do you open a command prompt when issuing a command? 375 viewsMehedi Hasan Answered question 08/05/2020Linux 0 Votes 1 Ans What is GUI? 363 viewsMehedi Hasan Answered question 08/05/2020Linux 0 Votes 1 Ans What is CLI? 384 viewsMehedi Hasan Answered question 08/05/2020Linux 0 Votes 1 Ans What is the importance of the GNU project? 369 viewsMehedi Hasan Answered question 08/05/2020Linux 0 Votes 1 Ans What is the basic difference between BASH and DOS? 428 viewsMehedi Hasan Answered question 08/05/2020Linux 1 2 3 Question and answer is powered by AnsPress.io