Excel Placement(EN)

Welcome to your Excel Placement(EN)

The fill handle is used to

You can remove an entire row and it contents by selecting it and

Which of the following would be most useful if you wanted to change every occurrence of "Jones" to "Smith"?

Which function identifies the smallest number in a group of selected cells?

What is the result of the following function =sim(5,6)?

What is the range?

To Select a Range of Non-Connecting Cells, you can use

when hit enter the result in cell A3 will be five, using the handfill to replicate the formula in cells B3 and C3, what are the results

Add description here!

When hit enter what will be the result in cell A6

Add description here!

What is the meaning of the error #REF

11. In loan calculation in excel, the PMT function stands for

In the table below, we need to search using VLOOKUP for the ID 100432924 and return the value from the salary column , which will be the correct formula

Add description here!

13. We can mix different icon set from the conditional formatting menu

To define a name range , we can

when create a custom name , All the following are true about name range EXCEPT

16. We use validation to

17. We use VLOOKUP with approximate search type as

18. When we convert range into table

19. The shortcut to insert table

20. In loan calculation which of the following function represent the loan

Post Your Comment Here