Keyword

Result: 29 questions

What is the use of LOOKUP function in Excel?

In Microsoft Excel, the LOOKUP function returns a value from a range or an array.

How can you apply the same formatting to every sheet in a workbook in MS-Excel?

Right Click ‘Worksheet tab’ > Choose ‘Select All Sheets’. Now any formatting done will be applied to the whole workbook. To apply to a particular group of sheets, select only those sheets that need formatting.

What is the benefit of using formula in Excel sheet?

Calculating the numbers in Excel sheet, not only help you to give the final ‘sum up’ of the number but, it also calculates automatically the number replaced by another number or digit.  Through Excel sheet, the complex calculations become easy like payroll deduction or averaging the student’s result.

What is the “What If” condition in Excel formulas?

The “What If” condition is used to change the data in Microsoft Excel formulas to give different answers.

Example: You are buying a new car and want to calculate the exact amount of tax that will be levied on it then you can use the “What If” function.  For instance, there are three cells A4,B4, and C4. First cell says about the amount, the second cell will tell about the percentage (7.5%) of tax and the final cell will calculate the exact amount of tax.

What is the AND function does in Excel?

Like IF function, AND function also does the logical function. To check whether the output will be true or false the AND function will evaluate at least one mathematical expression located in another cell in the spreadsheet. If you want to see the output of more than one cells in a single cell, it is possible by using AND function.

Example: If you have two cells, A1 and A2, and the value you put in those two cells are >5 and you want result should display as ‘TRUE’ in cell B1 if value>5, and ‘False’ if any of those values<5. You can use AND function to do that.

How cell reference is useful in the calculation?

In order to avoid writing the data again and again for calculating purpose, cell reference is used. When you write any formula, for specific function, you need to direct Excel the specific location of that data. This location is referred as, cell reference. So, every time a new value added to the cell, the cell will calculate according to the reference cell formula.

What is the process to create a table in R language without using external files?

MyTable= data.frame ()

edit (MyTable)

The above code will open an Excel Spreadsheet for entering data into MyTable.

Learn Data Science in R Programming to land a top gig as an Enterprise Data Scientist!

What is the output of the program below? Explain your answer.

``````class Program {
private static string result;

static void Main() {
SaySomething();
Console.WriteLine(result);
}

static async Task<string> SaySomething() {
result = "Hello world!";
return “Something”;
}
}
``````

Also, would the answer change if we were to replace `await Task.Delay(5);` with `Thread.Sleep(5)`? Why or why not?

The answer to the first part of the question (i.e., the version of the code with `await Task.Delay(5);`) is that the program will just output a blank line (not “Hello world!”). This is because `result` will still be uninitialized when `Console.WriteLine` is called.

Most procedural and object-oriented programmers expect a function to execute from beginning to end, or to a `return` statement, before returning to the calling function. This is not the case with C# `async` functions. They only execute up until the first `await` statement, then return to the caller. The function called by `await` (in this case `Task.Delay`) is executed asynchronously, and the line after the `await` statement isn’t signaled to execute until `Task.Delay` completes (in 5 milliseconds). However, within that time, control has already returned to the caller, which executes the `Console.WriteLine` statement on a string that hasn’t yet been initialized.

Calling `await Task.Delay(5)` lets the current thread continue what it is doing, and if it’s done (pending any awaits), returns it to the thread pool. This is the primary benefit of the async/await mechanism. It allows the CLR to service more requests with less threads in the thread pool.

Asynchronous programming has become a lot more common, with the prevalence of devices which perform over-the-network service requests or database requests for many activities. C# has some excellent programming constructs which greatly ease the task of programming asynchronous methods, and a programmer who is aware of them will produce better programs.

With regard to the second part of the question, if `await Task.Delay(5);` was replaced with `Thread.Sleep(5)`, the program would output `Hello world!`. An `async` method without at least one `await` statement in it operates just like a synchronous method; that is, it will execute from beginning to end, or until it encounters a `return` statement. Calling `Thread.Sleep()` simply blocks the currently running thread, so the `Thread.Sleep(5)` call just adds 5 milliseconds to the execution time of the `SaySomething()` method.

Compare Java & Python