Ms Excel Basics

What formula would you use to add numbers in cells A1 and A2?

• =A1 + A2

• =A1 - A2

• =A1 * A2

• =SUM(A1,A2)

How do you subtract the value in cell B1 from the value in cell B2?

• =B1-B2

• =B2+B1

• =B1*B2

• =B2-B1

Which function would you use to find the average of a range of cells?

• MAX

• AVERAGE

• SUM

• COUNT

What is the formula to multiply the values in cells C1 and C2?

• =C1*C2

• C1+C2

• C1/C2

• C1-C2

Which function can you use to count the number of cells that contain numbers?

• SUM

• AVERAGE

• COUNT

• MAX

How do you sort a column of numbers from highest to lowest?

• Sort the column using a descending order function or method.

• Leave the column unsorted and analyze the data as is.

• Sort the column using an ascending order function.

• Randomly shuffle the numbers in the column.

What formula would you use to find the maximum value in a range of cells?

• SUM(range)

• COUNT(range)

• AVERAGE(range)

• MAX(range)

How can you quickly filter data to show only specific entries?

• Use filtering tools or functions in software or programming languages to specify criteria for displaying specific entries.

• Use a random selection method to choose entries.

• Delete all entries that do not match your criteria.

• Sort the data alphabetically to find specific entries.

What function would you use to find the minimum value in a set of numbers?

• max

• sum

• min

• average

How do you create a formula that adds the values in cells D1 through D5?

• =SUM(D1+D2+D3+D4+D5)

• =ADD(D1,D2,D3,D4,D5)

• =SUM(D1:D5)

• =TOTAL(D1:D5)