# Question: What formula would you write to do each of the

What formula would you write to do each of the following?

a. Add a range of numbers in cells B2:B12.

b. Find the largest value in cells C2:F2.

c. Find the smallest value in cells A1 through X10.

d. Find the average value in cells C1 through C10, assuming blank cells will be ignored.

e. Find the total number of items listed in cells A1 through F1, excluding any that contain text.

a. Add a range of numbers in cells B2:B12.

b. Find the largest value in cells C2:F2.

c. Find the smallest value in cells A1 through X10.

d. Find the average value in cells C1 through C10, assuming blank cells will be ignored.

e. Find the total number of items listed in cells A1 through F1, excluding any that contain text.

## Answer to relevant Questions

Define the following terms: syntax, arguments, and algorithm. How do pie charts differ from doughnut charts? How do you change the chart type of an existing chart? List and describe the steps you would take to create a structured list of data from a text file that contains values stored on separate lines. What is the Query Wizard and when would you use it?Post your question