To insert slide numbers
Answer: D
Correct answer: Insert a new text box and select Insert >> slide Number
The slide number is a field, and a field must sit in a text box or placeholder. So a box is created first and the number inserted into it; the number then updates as slides are added or reordered.
Please log in or register to report this question.
Which of the following is a correct order of precedence in a formula calculation?
Answer: D
Correct answer: None of above
The true order is: negation, then percent, then exponentiation, then multiplication and division, then addition and subtraction, then comparison. Each of the three orders offered puts at least one of these in the wrong place.
Please log in or register to report this question.
In MS Excel, what does the SUMPRODUCT function do?
Answer: A
Correct answer: Multiplies corresponding items in the given arrays and adds the products
SUMPRODUCT multiplies corresponding elements of two or more ranges and adds the results. =SUMPRODUCT(A1:A10,B1:B10) is the standard way to total quantity times price without a helper column. Its wider usefulness comes from a second property: it handles arrays without needing Ctrl + Shift + Enter. Because a logical test returns TRUE or FALSE, which behave as 1 and 0 in arithmetic, conditions can be embedded directly. =SUMPRODUCT((A1:A10="Delhi")*(B1:B10>100)) counts rows meeting both conditions, and multiplying by a third range totals them. That made it the standard multi-condition tool before COUNTIFS and SUMIFS existed, and it remains more flexible than either, since its conditions can be any expression rather than a criteria string. All ranges must be the same size, or it returns #VALUE!. Text is treated as zero, which is why an unexpected zero usually means a column of numbers stored as text.
Please log in or register to report this question.
