MS Excel Mastery

What is the shortcut key to open the 'Insert Function' dialog box in Excel?

• Shift + F3

• Shift + F4

• Alt + F3

• Ctrl + F3

Explain the difference between absolute and relative cell references in Excel formulas.

• Absolute cell references do not change, while relative cell references adjust based on their new position.

• Absolute cell references adjust based on their new position, while relative cell references do not change.

• Absolute cell references are used for text, while relative cell references are used for numbers.

• Absolute cell references and relative cell references are the same thing.

How can you create a pie chart in Excel?

• Select data, go to Insert tab, click on Pie Chart, choose style

• Click on the Home tab, select data, choose Pie Chart from the dropdown menu

• Go to Format tab, click on Insert Chart, select Pie Chart

• Open the Review tab, click on Pie Chart, input data manually

What is conditional formatting in Excel and how is it useful?

• Conditional formatting in Excel is used for creating animations

• Conditional formatting in Excel is only applicable to text data

• Conditional formatting in Excel is useful for visually emphasizing data points, identifying outliers, and making data easier to interpret.

• Conditional formatting in Excel is a feature for deleting data

Explain the concept of 'Freeze Panes' in Excel.

• Freeze Panes in Excel is used to change the font style of specific cells

• Freeze Panes in Excel is used to lock specific rows or columns in place to keep them visible while scrolling.

• Freeze Panes in Excel is used to lock entire sheets in place

• Freeze Panes in Excel is used to delete rows or columns permanently

What is the function of the 'SUM' function in Excel?

• Multiplies a range of numbers

• Adds up a range of numbers

• Divides a range of numbers

• Subtracts a range of numbers

How can you change the default font in Excel?

• Access 'Page Layout' tab -> Click on 'Font' dialog box launcher -> Choose font, style, size -> Click 'Apply to All Sheets'

• Navigate to 'Home' tab -> Click on 'Font' dialog box launcher -> Select font, style, size -> Click 'Set As Default'

• Right-click on a cell -> Choose 'Font' from the context menu -> Select font, style, size -> Click 'Apply Default'

• Go to 'Insert' tab -> Click on 'Font' dialog box launcher -> Select font, style, size -> Click 'Set As Default'

What is the purpose of the 'IF' function in Excel?

• To perform conditional logic in Excel

• To insert images into Excel cells

• To change the font style in Excel

• To calculate mathematical operations in Excel

Describe the steps to create a line graph in Excel.

• Enter data, highlight it, insert a bar graph, select a theme, and adjust the chart

• The steps to create a line graph in Excel involve entering data, selecting it, inserting a line chart, choosing a style, and customizing the graph.

• Input data, pick it, add a scatter plot, select a design, and modify the chart

• Add data, select it, insert a pie chart, choose a style, and customize the graph

What are the different types of cell referencing in Excel formulas?

• Constant referencing

• Static referencing

• Relative referencing, Absolute referencing, and Mixed referencing

• Dynamic referencing