Excel Multiple Choice Questions

You may wonder what top 10 questions multiple choice in Excel which help you to groom yourself in Excel sheet check out al Ten questions

Don't forget to subscribe our blog for latest updates on. Data analytics | Excel | Certification 

What is the keyboard shortcut to save an Excel spreadsheet?

a) Ctrl+S

b) Ctrl+P

c) Ctrl+X

d) Ctrl+Z

Answer: a) Ctrl+S

Which of the following formulas would you use to add up a range of cells in Excel?

a) =SUM()

b) =AVG()

c) =COUNT()

d) =MIN()

Answer: a) =SUM()

What does the function =NOW() do in Excel?

a) Returns the current date and time

b) Returns the current time

c) Returns the current date

d) Returns the current year

Answer: a) Returns the current date and time

Which of the following is NOT a valid chart type in Excel?

a) Pie chart

b) Line chart

c) Bubble chart

d) Email chart

Answer: d) Email chart

What is the shortcut key to insert a new row in Excel?

a) Ctrl+R

b) Ctrl+N

c) Ctrl+I

d) Ctrl+Shift+Plus (+)

Answer: d) Ctrl+Shift+Plus (+)

Which of the following is NOT a valid function in Excel?

a) =SUMIF()

b) =COUNTIF()

c) =IFERROR()

d) =GETDATA()

Answer: d) =GETDATA()

What is the shortcut key to paste values only in Excel?

a) Ctrl+V

b) Ctrl+Shift+V

c) Ctrl+C

d) Ctrl+Alt+V

Answer: b) Ctrl+Shift+V

Which of the following is NOT a valid reference type in Excel?

a) Relative

b) Absolute

c) Mixed

d) Conditional

Answer: d) Conditional

What is the shortcut key to insert a new column in Excel?

a) Ctrl+Shift+C

b) Ctrl+Shift+V

c) Ctrl+Alt+C

d) Ctrl+Shift+Plus (+)

Answer: c) Ctrl+Alt+C

Which of the following is the correct formula to calculate the percentage increase from the old value to the new value in Excel?

a) =((New Value - Old Value) / Old Value) * 100

b) =(New Value - Old Value) / 100

c) =(Old Value - New Value) / Old Value

d) =((New Value / Old Value) - 1) * 100

Answer: a) =((New Value - Old Value) / Old Value) * 100