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
Comments