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)?
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
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