Microsoft Excel Quiz by PEDi Changlun

How do you create a basic addition formula in Excel?

• =TOTAL(cell1, cell2)

• =PLUS(cell1, cell2)

• =SUM(cell1, cell2)

• =ADD(cell1, cell2)

What function is used to find the average of a range of cells in Excel?

• MAX

• AVERAGE

• COUNT

• SUM

How do you create a simple bar chart in Excel?

• Use the 'Format' tab to create a bar chart

• Insert a bar chart from the 'Insert' tab

• Copy and paste a bar chart from another Excel file

• Manually draw a bar chart using the 'Draw' tool

What is the shortcut to save an Excel file?

• Alt + S

• Shift + S

• Ctrl + A

• Ctrl + S

How do you create a basic subtraction formula in Excel?

• =A1/B1

• =A1*B1

• =A1-B1

• =A1+B1

What is the shortcut to apply bold formatting to text in Excel?

• Alt + B

• Shift + B

• Ctrl + A

• Ctrl + B

What function is used to find the maximum value in a range of cells in Excel?

• AVERAGE

• SUM

• MAX

• MIN

How do you create a simple line chart in Excel?

• Select the data and go to the 'Insert' tab to choose 'Line Chart'

• Use the 'Data Analysis' tool to create a line chart

• Right-click on the data and choose 'Line Chart'

• Go to the 'Format' tab and select 'Line Chart'

How do you apply currency formatting to a cell in Excel?

• Use the 'Format' tab to apply currency formatting

• Right-click on the cell and choose 'Currency Format'

• Use the 'Number' tab to apply currency formatting

• Manually type the currency symbol in the cell

What function is used to count the number of cells with numerical values in Excel?

• NUMERICCOUNT

• COUNTNUM

• NUMCOUNT

• NUMVALCOUNT