Ad hoc functions perform ad hoc operations such as zooming, retrieving and submitting data, and pivoting.
HypRetrieve
HypRetrieveRange
HypRetrieveNameRange
HypGetNameRangeList
HypRetrieveAllWorkbooks
HypExecuteQuery
HypSubmitData
HypPivot
HypPivotToGrid
HypPivotToPOV
HypKeepOnly
HypRemoveOnly
HypZoomIn
HypZoomOut