Free Printable Quiz of spreadsheet

1.

Which option changes the appearance of text to bold in Excel?

a)

Ctrl + B

b)

Ctrl + A

c)

Ctrl + I

d)

Ctrl + Z

2.

What is the default font in Microsoft Excel?

a)

a)Arial

b)

b) Times New Roman

c)

c) Calibri

d)

d) Verdana

3.

Which feature allows you to increase or decrease text size in a cell?

a)

a) Font Style

b)

b) Font Size

c)

c) Text Effects

d)

d) Underline

4.

How can you apply italic formatting to selected text in Excel?

a)

a) Ctrl + B

b)

b) Ctrl + I

c)

c) Ctrl + U

d)

d) Ctrl + K

5.

Which of the following is NOT a font formatting option?

a)

a) Strikethrough

b)

b) Subscript

c)

c) Text Wrap

d)

d) Superscript

6.

Which alignment option places text at the top of a cell?

a)

a) Top Align

b)

b) Middle Align

c)

c) Bottom Align

d)

d) Justify

7.

What does the "Merge & Center" button do?

a)

a) Combines multiple cells and centers the text

b)

b) Aligns text to the left

c)

c) Changes font size

d)

d) Adds a border

8.

Which keyboard shortcut aligns text to the left in a cell?

a)

a) Ctrl + L

b)

b) Ctrl + E

c)

c) Ctrl + R

d)

d) Ctrl + J

9.

What is the default horizontal alignment for numbers in Excel?

a)

a) Left

b)

b) Center

c)

c) Right

d)

d) Justified

10.

Which alignment setting allows text to appear on multiple lines within a cell?

a)

a) Wrap Text

b)

b) Shrink to Fit

c)

c) Merge Cells

d)

d) Center Across Selection

11.

Which option adds a border around a selected cell?

a)

a)Home > Font > Borders

b)

b)Home > Alignment > Borders

c)

c)Home > Number > Borders

d)

d)Home > Styles > Borders

12.

What does a thick box border around a cell indicate?

a)

a) The cell is selected

b)

b) The cell has a thick border applied

c)

c) The cell contains an error

d)

d) The cell is locked

13.

Which border style is NOT available in Excel?

a)

a) Dotted

b)

b) Double

c)

c) Dashed

d)

d) Zigzag

14.

How do you remove all borders from a cell?

a)

a) Select "No Border" from the Borders menu

b)

b) Press `Ctrl + Shift + _`

c)

c) Both a and b

d)

d) Press `Delete`

15.

Which option adds an outside border to a selected range?

a)

a) All Borders

b)

b) Outside Borders

c)

c) Thick Box Border

d)

d) Bottom Border

16.

What is the purpose of cell shading?

a)

a) To change the font color

b)

b) To add a background color to cells

c)

c) To apply borders

d)

d) To align text

17.

Which tab contains the "Fill Color" option?**

a)

a) Home > Font

b)

b) Home > Alignment

c)

c) Home > Number

d)

d) Home > Styles

18.

What happens when you apply "No Fill" to a cell?

a)

a) The cell becomes transparent

b)

b) The cell turns white

c)

c) The cell gets a default gray fill

d)

d) The cell border disappears

19.

Which option allows you to apply a gradient fill to a cell?

a)

a) Fill Color

b)

b) Pattern Fill

c)

c) Format Cells > Fill > Gradient

d)

d) Conditional Formatting

20.

How can you quickly copy cell shading to another cell?

a)

a) Use `Format Painter`

b)

b) Press `Ctrl + C` and `Ctrl + V`

c)

c) Drag the fill handle

d)

d) Right-click and select "Copy Shading"

21.

What is the primary goal of customer segmentation?

a)

a) To reduce marketing costs

b)

b) To group customers based on similar characteristics

c)

c) To increase product prices

d)

d) To eliminate low-value customers

22.

Which of the following is NOT a common customer segmentation approach?

a)

a) Demographic

b)

b) Geographic

c)

c) Chronological

d)

d) Behavioral

23.

RFM analysis segments customers based on:

a)

a) Race, Family size, Marital status

b)

b) Recency, Frequency, Monetary value

c)

c) Region, Feedback, Market share

d)

d) Revenue, Forecast, Metrics

24.

Which visualization is best for comparing proportions in customer segments?

a)

a) Line chart

b)

b) Pie chart

c)

c) Scatter plot

d)

d) Heatmap

25.

A heatmap is most useful for displaying:

a)

a) Trends over time

b)

b) Correlation between variables

c)

c) Geographic distribution

d)

d) Hierarchical data

26.

Which chart type is ideal for showing customer purchasing trends over time?

a)

a) Bar chart

b)

b) Histogram

c)

c) Line chart

d)

d) Box plot

27.

A box plot helps visualize:

a)

a) Customer preferences

b)

b) Data distribution and outliers

c)

c) Geographic clusters

d)

d) Website click paths

28.

K-means clustering is used in segmentation to:

a)

a) Predict future sales

b)

b) Group similar customers automatically

c)

c) Analyze time-series data

d)

d) Create decision trees

29.

Which visualization helps interpret PCA results in clustering?

a)

a) Bar chart

b)

b) Scree plot

c)

c) Pie chart

d)

d) Gantt chart

30.

A dendrogram is associated with which clustering method?

a)

a) K-means

b)

b) Hierarchical

c)

c) DBSCAN

d)

d) Fuzzy clustering

31.

Which chart is best for comparing campaign performance across segments?

a)

a) Radar chart

b)

b) Waterfall chart

c)

c) Stacked bar chart

d)

d) Bubble chart

32.

A lift chart is used to evaluate:

a)

a) Customer satisfaction

b)

b) Model performance in targeting

c)

c) Geographic sales distribution

d)

d) Website traffic sources

33.

Which tool is best for interactive customer segmentation dashboards?

a)

a) Excel

b)

b) Tableau

c)

c) Notepad

d)

d) PowerPoint

34.

Which visualization helps identify high-value customer segments?

a)

a) Histogram

b)

b) Pareto chart

c)

c) Word cloud

d)

d) Sankey diagram

35.

What is a key consideration when visualizing customer segments?

a)

a) Using as many colors as possible

b)

b) Avoiding labels for clarity

c)

c) Ensuring readability and avoiding clutter

d)

d) Only using 3D charts

36.

Which Python library is commonly used for segmentation visualizations?

a)

a) TensorFlow

b)

b) Scikit-learn

c)

c) Matplotlib/Seaborn

d)

d) PyTorch

37.

If a scatter plot shows customers clustered in two groups, what does this suggest?

a)

a) Customers have similar behaviors

b)

b) Two distinct segments exist

c)

c) Data is normally distributed

d)

d) No actionable insights

38.

A high Recency score in RFM analysis indicates:

a)

a) Frequent purchases

b)

b) Recent purchases

c)

c) High spending

d)

d) Low engagement

39.

Which visualization would best show the journey of customers across segments?

a)

a) Line chart

b)

b) Sankey diagram

c)

c) Pie chart

d)

d) Box plot

40.

What does a high silhouette score in clustering indicate?

a)

a) Poor segmentation

b)

b) Well-defined clusters

c)

c) Overfitting

d)

d) Random noise

Quiz of spreadsheet

Total questions: 40

Worksheet time: 20mins

Similar Resources on Wayground