Mastering MS Excel Concepts

What function would you use to find the average of a range of cells?

• COUNT

• AVERAGE

• SUM

• MAX

How do you format a cell to display currency in Excel?

• Highlight the cell, go to 'Data', and select 'Currency Format' from the dropdown.

• Right-click the cell, select 'Cell Options', and choose 'Money' format.

• Select the cell, right-click, choose 'Format Cells', select 'Currency', and click 'OK'.

• Select the cell, click 'Insert', and choose 'Currency' from the menu.

Which chart type is best for showing trends over time?

• Line chart

• Bar chart

• Pie chart

• Scatter plot

What is the purpose of a Pivot Table in Excel?

• To create charts and graphs

• To store large datasets

• The purpose of a Pivot Table in Excel is to summarize and analyze data.

• To format text and images

How can you restrict data entry to a specific list of values?

• Use dropdown lists or data validation rules to limit entries to specific values.

• Implement a free-text input field only

• Use color coding to indicate valid entries

• Allow any text entry without restrictions

What formula would you use to calculate the sum of cells A1 to A10?

• =TOTAL(A1:A10)

• =ADD(A1:A10)

• =SUMMATION(A1:A10)

• =SUM(A1:A10)

How do you change the font color of a cell in Excel?

• Select the cell and press 'Ctrl + C' to copy the color.

• Select the cell, go to the 'Home' tab, click 'Font Color', and choose a color.

• Go to the 'View' tab and adjust the color settings.

• Right-click the cell and select 'Change Color' from the menu.

Which function would you use to count the number of cells that contain numbers?

• AVERAGE

• MAX

• SUM

• COUNT

What type of chart would you use to compare different categories?

• Scatter plot

• Line chart

• Bar chart

• Pie chart

How do you create a Pivot Table from a data range?

• Open 'File' > 'New' and create a blank spreadsheet.

• Highlight the data, right-click, and choose 'Delete'.

• Select data range, go to 'Insert' > 'PivotTable', choose location, and arrange fields.

• Select data range, go to 'Data' > 'Sort', and apply filters.