1. What is the purpose of Excel functions?

C. To perform predefined calculations

12. What is the purpose of using absolute references in formulas?

C. To keep reference fixed when copying

8. What does the function =SUMIF(A1:A10, ">50", B1:B10) do?

B. Sums values in B1:B10 where A1:A10 > 50

14. What is the behavior of a mixed reference $A1 when copied across columns?

A. Row changes, column stays fixed

15. Why are mixed references useful?

C. For creating complex models like multiplication tables

studbud

Quzi 1- Chapter 5 Introduction to Advanced Excel Functions

15 termsStudBud Administration14 plays

Imported from external platform

Flashcards15 cardsFPractice quizPHost liveL

Questions 15

Answers

1
6. What will happen to the formula =B2 + C2 when copied from row 2 to row 3?
A. It becomes =B3 + C3
B. It becomes =B2 + C2
C. It becomes =C2 + D2
D. It becomes =B2 + D2
2
3. What function can be used for conditional summing in Excel?
D. SUBTOTAL
A. COUNTIF
C. SUMPRODUCT
B. SUMIF
3
4. Which function would best be used to find data in a table by matching a value?
A. SUM
B. VLOOKUP
C. TEXTJOIN
D. TRIM
4
1. What is the purpose of Excel functions?
A. To draw charts
C. To perform predefined calculations
D. To write code
B. To create documents
5
10. Which Excel function is used to get today’s date?
C. DATE()
B. TODAY()
A. NOW()
D. TIME()
6
5. What type of cell reference is $A$1?
A. Relative
B. Absolute
C. Mixed (row fixed)
D. Dynamic
7
12. What is the purpose of using absolute references in formulas?
D. To sort values
C. To keep reference fixed when copying
A. To change values dynamically
B. To create charts
8
2. Which of the following is an example of a basic Excel formula?
D. =INDEX(A1:A5, MATCH(3, B1:B5, 0))
A. =XLOOKUP(105, A2:A100, C2:C100, "Not Found")
C. =IF(A1>10, "Yes", "No")
B. =SUM(A1:A10)
9
7. Which function helps perform decision-making calculations in Excel?
B. SUM
A. IF
D. NOW
C. LEFT
10
9. What kind of reference is A$1?
C. Mixed (row fixed)
D. Mixed (column fixed
B. Absolute)
A. Relative
11
8. What does the function =SUMIF(A1:A10, ">50", B1:B10) do?
B. Sums values in B1:B10 where A1:A10 > 50
A. Sums all values greater than 50 in column B
D. Sums only B1:B10 without condition
C. Counts cells in A1:A10 greater than 50
12
14. What is the behavior of a mixed reference $A1 when copied across columns?
B. Column changes, row stays fixed
D. Neither changes
A. Row changes, column stays fixed
C. Both change
13
13. Which of the following is a dynamic array function in Excel?
B. FILTER
C. TRIM
A. INDEX
D. MATCH
14
15. Why are mixed references useful?
B. For copying values
A. For basic addition
D. For writing text
C. For creating complex models like multiplication tables
15
11. What happens when you copy the formula =B2 * $D$1 across other rows?
D. B2 changes to D2
C. $D$1 turns into D2, D3...
A. $D$1 changes
B. $D$1 remains constant

Quzi 1- Chapter 5 Introduction to Advanced Excel Functions Flashcards | StudBud