In Excel, which function is used to perform a vertical lookup with approximate match? MCQ with Answer and Explanation

Explanation:
A Primary Key is a field (or combination of fields) that uniquely identifies each record in a table. It cannot contain null or duplicate values.

Explanation:
.xps is XML Paper Specification, not a PowerPoint save format (though you can export as XPS). But typical save-as formats: pptx, ppt, pdf, ppsx. However, you can save as XPS from Office. I'll avoid ambiguous. I'll change: .wav is not a presentation format. I'll ask: Which is not a presentation file format? Options: .pptx, .ppsx, .potx, .wav. Answer D. So I'll adjust.

Explanation:
Crop removes the outer edges of a picture to focus on a specific area. It does not resize (though cropping changes dimensions), adjust brightness, or rotate.