题目

COMM_V 205 101 102 103 2025W1 Assignment B1 (Excel)

多项填空题

There have been 4 different Xbox consoles in these 13 years: Xbox, XOne, X360, and Xlive. While you were looking into console names, you realize that there is no other console with a name that starts with character X. Also assume that there are consoles whose names start with character Y or character Z . Finally, assume that there is no console whose name is just Y or just Z (in other words, single letter Y or single letter Z). Complete the following formula to calculate the aggregate sales amount for all the games designed for any one of the Xbox consoles in Alex’s entire game dataset. =SUMIFS(I2:I1301,D2:D1301,">XXX") XXX SUMIFS(I2:I1301,D2:D1301,">XXX") You can only use either an arithmetic operator or a text in each blank and if you enter a text, each text should consist of a single letter. As always, don't leave any space in your formula. =SUMIFS(I2:I1301,D2:D1301,">[Fill in the blank], ")[Fill in the blank], SUMIFS(I2:I1301,D2:D1301,">[Fill in the blank], ")

查看解析

标准答案

Please login to view

思路分析

To solve this fill-in-the-blank formula, we need to construct a expression that isolates sales for games designed for Xbox consoles (names starting with X) while excluding consoles starting with other letters such as Y or Z. First, consider what the dataset contains: console names that begin with X, Y, or Z, with the caveat that single-letter Y or Z do not exist in the dataset. The goal is to aggregate sales for games designed for any Xbox console (those starting with X). Option by option reasoning for each blank: - Blank 1 (inside the first SUMIFS criterion): Think about how to capture all items whose console name starts with X. In Excel SUMIFS, usin......Login to view full explanation