Answer:
<em>Which function would you use if you wanted to count the number of values, but ignore the cells that have text or are empty</em>
<em>Which function would you use if you wanted to count the number of values, but ignore the cells that have text or are emptya COUNT</em>
<em>Which function would you use if you wanted to count the number of values, but ignore the cells that have text or are emptya COUNTb. COUNTA</em>
<em>Which function would you use if you wanted to count the number of values, but ignore the cells that have text or are emptya COUNTb. COUNTAc. COUNTBLANK</em>
<em>Which function would you use if you wanted to count the number of values, but ignore the cells that have text or are emptya COUNTb. COUNTAc. COUNTBLANKd. COUNTVALUES</em>
Answer:
Excel MIN Function
Explanation:
Excel MIN Function is used to get the smallest value which means, it returns the smallest value in the array(a set of data).
syntax is =MIN (number1, [number2], ...)
<u>The types of data sources that could be used in a mail merge are:</u>
- Word tables
- a database
- an excel sheet
- an outlook contacts list
<u>Explanation:</u>
Mail merge allows one to send a particular document to different individuals. It is generally used in office environment where some information is to be communicated to a number of people. The information is attached by adding the data sources.
Mail merge comprises of joining mail and letters and pre-tended to envelopes or mailing names for mass mailings from a structure letter.
In database mail merging it is embedding it into reports, for example, letters, mailing marks, and unofficial IDs.
Tables assist you with exhibiting data in an unmistakable and sorted out way. Tables are helpful for different assignments, for example, introducing content data and numerical information.
In excel the component in Microsoft Word and Excel streamlines the way toward sending a similar report with customized changes to a few beneficiaries.
In outlook contacts, the wellspring of customized data in a bunch of Word reports, through Word's mail blend include through Word's mail merge feature.
