Hi there,
The archive page uses a template to dynamically display the corresponding content:
https://codex.wordpress.org/Creating_an_Archive_Index
Note that the exact method varies between themes, however you will need to locate the template that creates the archive page and use a Meta Slider ‘template include’ to display the slider you want, something like:
<?php if (is_category( 'Football' )) {
echo do_shortcode("[metaslider id=1705]");
} ?>
Thanks,
Dave