Excel Basics Quiz

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

• Ctrl+P

• Ctrl+S

• Ctrl+C

• Ctrl+X

Which function is used to add up a range of cells in Excel?

• SUM

• AVERAGE

• COUNT

• MAX

What does the 'VLOOKUP' function do?

• Looks for a value in the leftmost column and returns a value in the same row from a specified column

• Looks for a value in the top row and returns a value in the same column from a specified row

• Counts the number of cells that match a criteria

• Calculates the average of a range of cells

Which symbol is used to start a formula in Excel?

• &

• =

• #

• %

Which function in Excel is used to count the number of cells that contain numbers?

• COUNT

• COUNTA

• COUNTIF

• COUNTBLANK

What is the default file extension for an Excel workbook?

• .xls

• .xlsx

• .csv

• .docx

In Excel, which of the following is a valid cell reference?

• 12B

• B12

• 12-B

• B-12

What is the purpose of the 'IF' function in Excel?

• To add numbers in a range

• To apply conditional logic to perform actions based on a true or false condition

• To count cells that match a criteria

• To format cells based on a condition

What is the purpose of the 'Merge & Center' feature in Excel?

• To merge multiple worksheets into one

• To merge and center the contents of selected cells across a new merged cell

• To split a cell into multiple cells

• To combine two cells into a new cell

Which function is used to return the current date in Excel?

• NOW()

• TODAY()

• DATE()

• CURRENTDATE()