DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If I want to find an average of cells A1 through A25, which formula would I use?
|
|
=average(A1:A25)
|
|
|
=avg(A1:A25)
|
|
|
=average(A1-A25)
|
|
|
=avg(A1-A25)
|
Explanation:
Detailed explanation-1: -What is the correct formula to calculate an average based on cells H7 to H10? a) =AVE(H7:H10)
Detailed explanation-2: -The main uses of Excel include: Data entry. Data management. Accounting.
Detailed explanation-3: -Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
Detailed explanation-4: -Microsoft Excel is a spreadsheet program included in the Microsoft Office suite of applications.
There is 1 question to complete.