SCMA 350 Exam 1 Question and answers verified to pass 2025/2026

SCMA 350 Exam 1 Question and answers
verified to pass 2025/2026
1. 1. The following PivotTable is based on a 4. 1. The
database following
of professional tennis players. In the database, PivotTable is
every row represents a tennis player and there based on a
database
is a field/col- umn for the record number (row
of
in the database), their Preferred Hand (left or
professional
right), Nationality (South African, American,
tennis
Swedish, Japanese), Height, Weight, and Head-
players. In
to-Head Wins on the year.
the
Which of the "PivotTable Fields" needs to be database,
placed in Columns area to exactly recreate the every row
PivotTable? represents
a tennis
2. 1. is a logical function that returns player and
a there is a
user-defined value if the condition is true and field/col-
another user-defined value if the condition is umn for the
false. record
number
3. 1. The following PivotTable is based on a
(row in the
database
database),
of professional tennis players. In the database,
their
every row represents a tennis player and there
Preferred
is a field/col- umn for the record number (row
Hand (left
in the database), their Preferred Hand (left or
or right),
right), Nationality (South African, American,
Nationality
Swedish, Japanese), Height, Weight, and Head-
(South
to-Head Wins on the year.
African,
Which of the "PivotTable Fields" needs to be American,
placed in Rows area to exactly recreate the Swedish,
PivotTable? Japanese),
1/
9

, SCMA 350 Exam 1 Question and answers
verified to pass 2025/2026
Height, Weight, and Head-to-Head Wins on the
Preferred Hand
year.




IF




Nationality




Head-To-Head Wins




2/
9