Excel Functions and Pivot Table Quiz

What does the `=MAX(A1:A10)` return?

• Minimum value

• Sum

• Largest value

• Count

Which function is used to count numeric values only?

• COUNTA

• COUNT

• LEN

• AVERAGE

What does the `=LEFT("Excel",2)` return?

• "Ex"

• "El"

• "ce"

• Error

What is the use of `=TRIM()` function in Excel?

• Text combine करने के लिए

• Extra spaces हटाने के लिए

• Text को छोटा करने के लिए

• कुछ नहीं

Which function returns today’s date?

• NOW

• DATE

• TODAY

• TIME

Which function is used to join texts?

• CONCATENATE

• SUM

• JOIN

• LINK

What is the use of `=IF(A1>10, "High", "Low")`?

• Comparison

• Sum

• Average

• Formatting

Which function gives number of characters in a string?

• COUNT

• CHAR

• LEN

• NUM

What does `=PROPER("hello world")` return?

• HELLO WORLD

• hello world

• Hello World

• Error

What is the main use of Pivot Table?

• Formatting

• Data entry

• Data summarization

• Formulas