Mastering Microsoft Excel

What is Microsoft Excel?

• A web browser
  

• A word processing program
  

• A graphic design tool
  

• A spreadsheet application

What is the default file extension for an Excel workbook?

• .xlsx

• .xls

• .txt

• .csv

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

• COUNT

• MAX

• AVERAGE

• SUM

In Microsoft Excel spreadsheets, rows are designated as _______.

• 1, 2, 3, ....

• A, B, C, ....

• A1, B1, C1, ....

• I, II, III, ....

How do you create a pie chart in Excel?

• Select your data, go to 'File' > 'New Chart', and choose a type.

• Select your data, go to 'Insert' > 'Pie Chart', and choose a style.

• Highlight your data, click on 'Data' > 'Chart Options', and pick a design.

• Choose your data, navigate to 'View' > 'Chart Wizard', and select a format.

What is the purpose of conditional formatting in Excel?

• The purpose of conditional formatting in Excel is to visually enhance data by applying formatting based on specific conditions.

• To create charts automatically based on data trends.

• To protect data from being edited by users.

• To sort data in ascending or descending order.

How do you sort data in Excel?

• Select the data range, go to the 'Home' tab, click 'Format', then choose 'Align' options.

• Select the data range, go to the 'Data' tab, click 'Sort', choose the column and order, then click 'OK'.

• Highlight the data, then press 'Ctrl + Z' to undo any changes.

• Right-click the data range and select 'Delete' to remove duplicates.

Which function would you use to count the number of cells that meet a certain condition?

• MAXIF

• AVERAGEIF

• SUMIF

• COUNTIF

What type of chart is best for showing trends over time?

• Pie chart

• Scatter plot

• Bar chart

• Line chart

How can you apply conditional formatting to highlight cells greater than a certain value?

• Select the cells, go to Data > Sort > Ascending > Apply changes.

• Right-click the cells, choose Format Cells > Number > Set decimal places.

• Select the cells, go to Home > Font > Change color to red.

• Select the cells, go to Conditional Formatting > New Rule > Format cells that contain > Greater than > Enter value > Choose format > OK.