LearnTube MS office Quiz Competition 29/1/23

Full Name ?

Email ID ?

Phone Number ?

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

• To add up the values in a range of cells
• To calculate the average of a range of cells
• To count the number of cells in a range
• To find the highest value in a range of cells

What is the keyboard shortcut to quickly save an Excel document?

• Ctrl+S
• Alt+S
• Shift+S
• F12

How can you use the IF function in Excel to create a conditional statement?

• =IF(condition, value if true, value if false)
• =IF(condition, value if false, value if true)
• =IF(value if true, condition, value if false)
• =IF(value if false, condition, value if true)

How can you quickly copy a formula down a column in Excel?

• By using the fill handle
• By using the copy and paste functions
• By using the keyboard shortcut Ctrl+C and Ctrl+V
• By using the keyboard shortcut Ctrl+X and Ctrl+V

How can you create a chart in Excel?

• By using the Chart Wizard
• By using the Insert Chart function
• By using the Chart Tools tab
• All of the above

How can you use the VLOOKUP function in Excel to find a specific value in a table?

• By using the formula =VLOOKUP(value, table range, column number, exact match)
• By using the formula =VLOOKUP(value, table range, column number, approximate match)
• By using the formula =VLOOKUP(table range, value, column number, exact match)
• By using the formula =VLOOKUP(table range, value, column number, approximate match)

How can you quickly clear the contents of a cell in Excel?

• By using the Clear Contents function
• By using the Delete function
• By using the Backspace key
• By using the Ctrl+A and Delete