MCAS Formulas, Functions & Calculations

Question 1

In Microsoft Excel, which symbol must begin every formula?

Accepted Answer

=

Answer

@

Answer

#

Answer

+

Question 2

What is the result of the Excel formula =SUM(A1:A5) if cells A1 through A5 contain the values 2, 4, 6, 8, and 10?

Accepted Answer

30

Answer

10

Answer

20

Answer

48

Question 3

In Excel, what does a cell reference like $A$1 (with dollar signs) indicate?

Accepted Answer

An absolute reference that does not change when the formula is copied to another cell

Answer

A formula that calculates currency values

Answer

A reference to a cell in another workbook

Answer

A cell that has been locked for editing

Question 4

Which Excel function returns the largest value in a range of cells?

Accepted Answer

MAX

Answer

LARGE

Answer

HIGH

Answer

TOP

Question 5

In Excel, what does the IF function do?

Accepted Answer

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

Answer

Counts the number of cells that are not empty

Answer

Looks up a value in a table and returns a result from the same row

Answer

Rounds a number to a specified number of decimal places

Question 6

In Excel, what does the AVERAGE function calculate?

Accepted Answer

The arithmetic mean (sum divided by count) of a range of numbers

Answer

The middle value in a sorted list

Answer

The most frequently occurring value

Answer

The difference between the highest and lowest values