Excel Midterm Exam

What is the intersection of a row and a column called?

• Range

• Cell

• Worksheet

• Workbook

How do you start a formula in Excel?

• With a plus sign (+)

• With a minus sign (-)

• With an equal sign (=)

• With a dollar sign ($)

Which function is used to calculate the average of a range of cells?

• SUM

• AVERAGE

• MIN

• MAX

What is a single spreadsheet within an Excel workbook called?

• Cell

• Range

• Worksheet

• Chart

Which of the following is a predefined formula in Excel?

• Cell

• Function

• Range

• Workbook

What does the #DIV/0! error indicate?

• Invalid cell reference

• Division by zero

• Incorrect type of argument

• Missing value

How can you apply conditional formatting in Excel?

• By changing the font size

• By using the Format Painter

• By setting rules based on cell values

• By sorting data

What is the shortcut for copying selected cells?

• Ctrl + V

• Ctrl + C

• Ctrl + X

• Ctrl + Z

Which chart type is best for showing proportions of a whole?

• Line chart

• Bar chart

• Pie chart

• Scatter plot

What does the #REF! error indicate?

• Invalid cell reference

• Division by zero

• Incorrect type of argument

• Missing value