24-25 Computer Applications Midterm

Class Period

• 1
• 3
• 6

Which chart type is most useful for showing parts of a whole?

• Bar Chart
• Line Chart
• Pie Chart
• Scatter Plot

The x-axis on a chart usually represents:

• Values
• Categories
• Series
• Legends

Which function adds up a selected range of cells?

• SUM
• MAX
• MIN
• AVERAGE

Which function identifies the lowest number selected range of cells?

• SUM
• MAX
• MIN
• AVERAGE

The y-axis is often labeled as the __________.

• Category axis
• Value Axis
• Data Axis
• Series Axis

Which tool would you use to copy the formatting of one cell to another cell in Excel?

• Format Painter
• Conditional Formatting
• AutoFill
• Text Wrap

What is the purpose of "Merge & Center" in Excel?

• To insert a chart
• To format cells as currency
• To combine selected cells into one and center the text within it
• To align text to the left side of the cell

Which of the following commands is used to apply color to the background of a cell?

• Font Color
• Fill Color
• Border Color
• Text Highlight

How does "Conditional Formatting" work in Excel?

• It merges cells based on their content
• It applies specific formatting only when cell values meet certain conditions
• It automatically adjusts cell size to fit text
• It changes font style and size globally in the worksheet