📊 Excel Functions, Lists & Charts Quiz

1. Which Excel function returns one value if a condition is true and another if false?

• A. AND
• B. IF
• C. OR
• D. NOT

2. What is the primary difference between filtering and sorting?

• A. Sorting rearranges entries while filtering removes entries from view.
• B. A worksheet can be saved in a sorted state but not in a filtered state.
• C. Filtering affects the original data while sorting leaves it intact.
• D. Filtering is only possible in tables.

3. Which of the following is a function_num argument of the SUBTOTAL function that ignores hidden values?

• A. 1
• B. 101
• C. 2
• D. 201

4. What differentiates tables from data ranges?

• A. Tables can contain any type of cell data.
• B. Tables are independent objects.
• C. You can define a name for a table.
• D. You can sort and filter tables.

5. Graphical representations of numerical values are known as what?

• A. Conditional formatting
• B. Charts
• C. Slicers
• D. Tables

6. Which chart type is also known as a dual-axis chart?

• A. Area
• B. Combo
• C. Line
• D. Pie

7. True or False? In Excel function syntax, arguments in bold are optional.

• A. true
• B. false

8. True or False? You can perform date and time calculations on text.

• A. true
• B. false

9. True or False? Database functions are set up the same way as advanced filters.

• A. true
• B. false

10. True or False? Conditional formatting cannot be applied to cells that reference other cells.

• A. true
• B. false

11. True or False? PivotTables can only summarize values and cannot perform any other calculation.

• A. true
• B. false

12. True or False? The filters on a PivotChart are linked to the filters on the corresponding PivotTable.

• A. true
• B. false

13. True or False? Selecting a button on a slicer hides the corresponding values from view in a PivotTable.

• A. true
• B. false

14. What can you use to define cell and range names in Excel? (Choose three.)

• A. Name Manager dialog box
• B. New Name dialog box
• C. Name Box
• D. Formula Bar

15. Which Excel functions can split text? (Choose three.)

• A. LEFT
• B. RIGHT
• C. MID
• D. FIND

16. Which statements are true regarding sorting? (Choose two.)

• A. You can sort data ranges by rows or columns.
• B. Sorting alters your original data.
• C. You can sort on only one column at a time.
• D. You can sort data based on numerical values, alphabetically, and chronologically.

17. Which statements are true regarding conditional formatting? (Choose three.)

• A. Excel can display icon sets in front of background fills.
• B. Rule precedence determines which rule will prevail when there are conflicts.
• C. Excel does not support custom conditional formatting.
• D. You can use formulas to determine which cells to format.

18. Which of the following items are elements of Excel charts? (Choose three.)

• A. Legend
• B. Slicer
• C. Data series
• D. Title

19. Where can a PivotTable be created? (Choose two.)

• A. New Worksheet
• B. New Workbook
• C. Existing Worksheet
• D. New Window

20. What is the syntax for the COUNTIF function?

• A. =COUNTIF(range, criteria)
• B. =COUNTIF(criteria, range)
• C. =COUNTIF(range, value)
• D. =COUNTIF(range, [value])

21. Which function returns the current date and time?

• A. TODAY
• B. DATE
• C. NOW
• D. TIME

22. What does the WEEKDAY function return by default when return_type is omitted?

• A. Monday=1, Tuesday=2
• B. Sunday=1, Monday=2
• C. Monday=0, Tuesday=1
• D. Sunday=0, Monday=1

23. Which function is used to calculate the number of working days between two dates?

• A. WORKDAY
• B. NETWORKDAYS
• C. DAYS
• D. DATEDIF

24. What is the purpose of the LEFT function?

• A. Returns characters from the right of a string
• B. Returns characters from the left of a string
• C. Finds the position of a character
• D. Converts text to uppercase

25. Which function converts text to proper case (first letter capitalized, others lowercase)?

• A. UPPER
• B. LOWER
• C. PROPER
• D. TRIM

26. Which of the following is a valid comparison operator?

• A. !
• B. <>
• C. ><
• D. ||

27. In the AND function, what is returned if all arguments are true?

• A. TRUE
• B. FALSE
• D. 1

28. Which function reverses the result of a logical test?

• A. IF
• B. AND
• C. OR
• D. NOT

29. What does the OR function return if at least one condition is true?

• A. TRUE
• B. FALSE
• C. Maybe
• D. Error

30. What is the keyboard shortcut to open the Name Manager?

• A. Ctrl + F3
• B. Ctrl + N
• C. F3
• D. Alt + N

31. Which of the following is a valid rule type in the New Formatting Rule dialog box?

• A. Format only cells that contain
• B. Format only if cell is empty
• C. Format based on conditional logic
• D. Format with pivot tables

32. What does the Quick Analysis button provide access to?

• A. Chart types only
• B. Conditional formatting, charts, totals, tables, sparklines
• C. Only table conversion
• D. Only formatting options

33. Which of the following is a chart element?

• A. Data series
• B. PivotTable
• C. Slicer
• D. Filter

34. Which chart type is best to show the relative size of values compared to a whole?

• A. Column
• B. Line
• C. Pie
• D. Bar

35. What does a trendline on a chart represent?

• A. The average of all data points
• B. The pattern or direction of data over time
• C. The highest value in the dataset
• D. The lowest value in the dataset

36. Which trendline type is best for data that increases at a steady rate?

• A. Exponential
• B. Linear
• C. Logarithmic
• D. Moving average

37. What does the Filter command do?

• A. Permanently deletes rows
• B. Temporarily hides rows that do not meet criteria
• C. Sorts data alphabetically
• D. Creates a table

38. What is the purpose of the Subtotal feature?

• A. To calculate grand totals only
• B. To automatically insert SUBTOTAL functions for grouped data
• C. To remove duplicate rows
• D. To create a PivotTable

39. Which of the following is a database function?

• A. SUMIF
• B. DAVERAGE
• C. COUNTIF
• D. AVERAGEIF

40. What does the DSUM function do?

• A. Sums all numbers in a column
• B. Sums numbers in a column that match specified criteria
• C. Counts records that match criteria
• D. Averages numbers that match criteria

41. What is the difference between function_num 9 and 109 in the SUBTOTAL function?

• A. 9 ignores hidden rows, 109 includes them
• B. 9 includes hidden rows, 109 ignores them
• C. Both ignore hidden rows
• D. Both include hidden rows

42. Which of the following is NOT a requirement for using the Subtotal feature effectively?

• A. Data must be sorted by the grouping column
• B. Dataset must have column headers
• C. Data must be formatted as a table
• D. The column to subtotal must contain numbers

43. What does the Outline feature do?

• A. Groups rows or columns into collapsible sections
• B. Creates a border around selected cells
• C. Adds a shadow to cells
• D. Highlights duplicate values

44. Which chart type is best to show trends over time at consistent intervals?

• A. Bar
• B. Pie
• C. Line
• D. Column

45. What is the purpose of the Chart Elements button?

• A. To change the chart type
• B. To add or remove chart elements like titles and legends
• C. To apply a chart style
• D. To filter chart data

46. Which of the following can be created using the Quick Analysis tool?

• A. PivotTable
• B. Sparkline
• C. Both A and B
• D. Neither

47. What does the Text to Columns feature do?

• A. Splits a single column of text into multiple columns
• B. Merges multiple columns into one
• C. Converts text to numbers
• D. Finds and replaces text

48. What does the PROPER function do?

• A. Capitalizes all letters
• B. Makes all letters lowercase
• C. Capitalizes the first letter of each word
• D. Removes extra spaces

49. Which function returns the position of a specific character within a text string?

• A. FIND
• B. SEARCH
• C. POSITION
• D. INDEX

50. What is the purpose of the Format Painter?

• A. To copy cell formatting only
• B. To copy cell content and formatting
• C. To create a chart
• D. To remove formatting