In opera the soprano usually sings the heroine: Mimì in La bohème, Violetta in La traviata, Pamina in The Magic Flute, Tosca and Madama Butterfly. Coloratura sopranos get the fireworks, from the Queen of the Night's F6 to Lucia's mad scene. Singers widely held up as models include Joan Sutherland for coloratura, Renée Fleming and Kiri Te Kanawa for lyric roles, Leontyne Price for spinto repertoire and Birgit Nilsson for Wagner.
Musical theater has its own soprano tradition, often called legit soprano. Julie Andrews is the classic example, and Christine in The Phantom of the Opera, Cosette in Les Misérables, Glinda in Wicked and Johanna in Sweeney Todd are all soprano roles. In pop the labels are looser: Ariana Grande and Dolly Parton are commonly described as sopranos, while many pop stars with high, belted choruses are mezzo-sopranos with a strong mix.
Your test result lists singers whose published ranges overlap yours. Use it as a pointer for song choices, not a diagnosis: a famous singer's lowest growl or highest whistle note says little about where their voice sits most of the time.