Blog

What function is used to calculate totals in Excel? Can you use the following in Excel to calculate total of values in cells? If no, re-write it to correct it? =TOTAL(A1; B1; C1; D1)

Find an angle co-terminal with 

What do adjacent cells mean? How are they different from non-adjacent cells? Can adjacent cells be called a range?

What is an IF function in Excel? What is the general form of the IF Function? What does the following IF function do? =IF(A1>B1, 50, 0)

What function in Excel do you use to find the highest of values in a cell range? Write the Excel function that gives you the highest of values in cells A1, B1, A2, B2, X1, X2, and X4. Can the cells be called a range? If yes, why?

Is there anything wrong with the following Excel function? If yes, re-write it to correct it. What kind of cell is $B$19? =IF(B4>=$B$19; 5000; 0)

To measure system performance, companies use _____________, which uses a set of standard tests on one system to compare its performance and capacity to that of other systems.

When is an average function used in Excel? Can you use the following in Excel to calculate the average of values  in cells A1, B1, A2, A7 and B2? If not, rewrite it to correct it. =AVG(A1, B1, A2, A7 and B2)

Determine how much time is required for an investment to triple in value if the interest is earned at the rate of 6.25% compounded monthly. Round your answer to the nearest year. 

Many IT professionals use this term _________to describe a second generation of the web that enables people to collaborate, interact, and share information.