MSIS 3223 Exam 1 Questions with Verified Correct Answers

MSIS 3223 Exam 1 Questions with Verified
Correct Answers
Relative Reference

Cell reference that changes when copied to another cell (example: A1)

Absolute Reference

Cell reference that does not change when copied and uses $ signs (example: $A$1)

SUM Function

Adds a range of numbers

AVERAGE Function

Calculates the mean of a range of numbers

MIN Function

Returns the smallest value in a range

MAX Function

Returns the largest value in a range

COUNT Function

Counts the number of numeric values in a range

COUNTIF Function

Counts the number of values that meet a specified condition

IF Function

Returns one value if a condition is true and another value if false

, AND Function

Returns TRUE only if all specified conditions are true

OR Function

Returns TRUE if at least one specified condition is true

XLOOKUP Function

Looks up a value in an array and returns a corresponding value from another array

VLOOKUP Function

Looks for a value in the leftmost column of a table and returns a corresponding value

HLOOKUP Function

Looks for a value in the top row of a table and returns a corresponding value

INDEX Function

Returns the value of a cell based on its row and column position in a table

Pivot Table

A tool used to summarize, analyze, and organize large datasets

Column Chart

A chart used to compare values across categories using vertical bars

Line Chart

A chart used to show trends over time

Scatter Chart

A chart used to show the relationship between two numerical variables