Microsoft Excel Mastery

What is the shortcut key to insert the current date in a cell?

• Alt + D

• Ctrl + D

• Shift + D

• Ctrl + ; (semicolon)

Explain the difference between a relative reference and an absolute reference in Excel formulas.

• Relative reference is used for text, absolute reference is used for numbers

• Relative reference starts with a letter, absolute reference starts with a number

• Relative reference is for formatting, absolute reference is for calculations

• Relative reference changes when copied, absolute reference remains constant.

How can you merge cells in Excel?

• Use the 'Merge Cells' option in the 'Insert' tab

• Right-click on the cells and select 'Merge' from the context menu

• Press 'Ctrl + M' on the keyboard to merge the cells

• Select the cells and click on the 'Merge & Center' button in the 'Alignment' group on the 'Home' tab.

What is the function of the CONCATENATE function in Excel?

• The function of the CONCATENATE function in Excel is to combine multiple strings into one single string.

• The function of the CONCATENATE function in Excel is to split a single string into multiple strings.

• The function of the CONCATENATE function in Excel is to change the format of a single string.

• The function of the CONCATENATE function in Excel is to perform mathematical calculations on strings.

Explain the difference between SUM and AVERAGE functions in Excel.

• The SUM function calculates the average of the numbers in a range

• The SUM function adds up all the numbers in a range, while the AVERAGE function calculates the average of the numbers in a range.

• The SUM function multiplies all the numbers in a range

• The AVERAGE function adds up all the numbers in a range

What is the purpose of the VLOOKUP function in Excel?

• To change the font style of a cell

• To create a new worksheet in the Excel file

• To search for a value in the first column of a table and return a value in the same row from another column.

• To calculate the sum of a range of cells

How can you apply conditional formatting to a range of cells in Excel?

• You can apply conditional formatting to a range of cells in Excel by selecting the range, going to the 'Home' tab, clicking on 'Conditional Formatting' in the 'Styles' group, and choosing the desired formatting option from the dropdown menu.

• You can apply conditional formatting to a range of cells in Excel by typing in the desired formatting code in the formula bar

• You can apply conditional formatting to a range of cells in Excel by using the 'Insert' tab and choosing 'Conditional Formatting'

• You can apply conditional formatting to a range of cells in Excel by right-clicking on the range and selecting 'Format Cells'

What is the function of the IF function in Excel?

• The IF function in Excel is used to calculate the sum of a range of cells

• IF function in Excel is designed to create pivot tables

• The function of the IF function in Excel is to perform a logical test and return different values based on the result of the test.

• The function of the IF function in Excel is to change the font style of a cell

Explain the purpose of the COUNTIF function in Excel.

• The purpose of the COUNTIF function in Excel is to count the number of cells within a range that meet a specific criteria.

• The purpose of the COUNTIF function in Excel is to calculate the average of cells within a range that meet a specific criteria.

• The purpose of the COUNTIF function in Excel is to sort cells within a range that meet a specific criteria.

• The purpose of the COUNTIF function in Excel is to format cells within a range that meet a specific criteria.

How can you protect a worksheet in Excel?

• Go to the 'Home' tab, click on 'Protect Workbook', and set a password

• Right-click on the worksheet tab, select 'Format Cells', and set a password

• Go to the 'Review' tab, click on 'Protect Sheet', and set a password

• Go to the 'Insert' tab, click on 'Protect Document', and set a password