Excel and SQL Quiz

What is the shortcut key to save a workbook in Excel?

• Ctrl + S

• Ctrl + C

• Ctrl + V

• Ctrl + X

Which function is used to calculate the average of a range of values in Excel?

• SUM

• AVG

• AVERAGE

• MEAN

How do you create a chart in Excel?

• Insert > Chart

• Data > Chart

• View > Chart

• Format > Chart

What does the VLOOKUP function do?

• Looks up a value in a vertical table

• Looks up a value in a horizontal table

• Looks up a value in both vertical and horizontal tables

• None of the above

Which symbol is used to start a formula in Excel?

• =

• +

• -

• *

How can you apply a filter to a dataset in Excel?

• Home > Sort & Filter

• Data > Filter

• Insert > Filter

• View > Filter

What is the purpose of the CONCATENATE function?

• To combine text from different cells

• To separate text into different cells

• To delete text from cells

• To copy text from one cell to another

How do you freeze panes in Excel?

• View > Freeze Panes

• Insert > Freeze Panes

• Data > Freeze Panes

• Home > Freeze Panes

What does the IF function do?

• Checks if a condition is met and returns one value if true and another value if false

• Adds up a range of values

• Calculates the average of a range of values

• None of the above

How do you insert a new row in an Excel worksheet?

• Right-click the row number and select Insert

• Right-click the column letter and select Insert

• Right-click any cell and select Insert

• None of the above