FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What is missing from this function?=(F8:F13)
A
It doesn’t need parentheses ( )
B
The name of the function being applied
C
SUM should be in front of the equal sign
D
Nothing is missing
Explanation: 

Detailed explanation-1: -When you insert a function as one of the arguments within another function in Excel, it’s called nesting functions. For example, you can nest an AVERAGE function within an IF function if you want to base the logical test on a calculated average.

Detailed explanation-2: -To refresh the current cell-press F2 + Enter. To refresh the current tab-press Shift + F9. To refresh the entire workbook-press F9.

There is 1 question to complete.