No. Ultimate Offering cannot Special Summon the Egyptian God Cards (Slifer the Sky Dragon, Obelisk the Tormentor, The Winged Dragon of Ra). Here's why.
Ultimate Offering is a Continuous Trap Card. Its effect: Pay 500 LP → Normal Summon/Set 1 additional monster during your Main Phase or the opponent's Battle Phase. It grants an extra Normal Summon—not a Special Summon.
Ultimate Offering could facilitate a God Card's Normal Summon by giving you a second Normal Summon in a turn (e.g., tribute two monsters for the first summon, use Ultimate Offering to tribute the third for the God). However:
In short: Ultimate Offering helps you Normal Summon them faster if you have the tributes—but it doesn't cheat their summoning conditions.