Explain when you would use SUMIFS instead of SUMIF.
What will be an ideal response?
You would use SUMIFS when you want to sum a range based on multiple conditions. The SUMIF function provides for only one condition to be tested.
You might also like to view...
Fading transitions use the ____ property to lighten and darken a screen.
A. Opacity B. Brightness C. Transparency D. Contrast
Show the sequence of changes to the routing tables that would occur (according to the RIP algorithm) after the link labelled is broken.
What will be an ideal response?
A(n) ____________________ is formed by the intersection of a column and a row.
Fill in the blank(s) with the appropriate word(s).
You can change settings, such as making the right button the primary mouse button if you are left-handed, in the Word Options dialog box.
Answer the following statement true (T) or false (F)