FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

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?

A	=average(A1:A25)
B	=avg(A1:A25)
C	=average(A1-A25)
D	=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: -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-3: -Microsoft Excel is a spreadsheet program included in the Microsoft Office suite of applications.

Detailed explanation-4: -The most common reason for an Excel formula not calculating is that you have inadvertently activated the Show Formulas mode in a worksheet. To get the formula to display the calculated result, just turn off the Show Formulas mode by doing one of the following: Pressing the Ctrl + ‘ shortcut, or.

There is 1 question to complete.