Excel Fundamentals

What is Microsoft Excel primarily used for?

• Creating and editing documents

• Analyzing data and performing calculations

• Sending and receiving emails

• Designing graphics and illustrations

Which term is used to describe a single cell in Excel?

• Cell

• Field

• Box

• Block

Which function is used to find the highest value in a range of cells?

• MAX

• SUM

• AVG

• MIN

What does the formula "=A1+B1" in Excel do?

• Multiplies the values in cells A1 and B1

• Divides the value in cell A1 by the value in cell B1

• Subtracts the value in cell B1 from the value in cell A1

• Adds the values in cells A1 and B1

Which Excel feature allows you to format cells based on specific criteria?

• Autofill

• Sort

• Filter

• Conditional formatting

What is the keyboard shortcut for copying cells in Excel?

• Ctrl+X

• Ctrl+C

• Ctrl+D

• Ctrl+V

Which chart type is best suited for displaying trends over time?

• Pie chart

• Bar chart

• Line chart

• Scatter plot

What does the function "=COUNT(A1:A10)" in Excel do?

• Adds the values in the range A1:A10

• Calculates the average of the values in the range A1:A10

• Multiplies the values in the range A1:A10

• Counts the number of cells with values in the range A1:A10

Which Excel feature allows you to view multiple worksheets simultaneously?

• Formula bar

• Data validation

• Pivot table

• Split window

Which function is used to combine text from different cells into one cell in Excel?

• CONCATENATE

• SUM

• VLOOKUP

• IF