1) Which function is used to calculate the sum of a range of cells in Excel? a) MAX b) AVERAGE c) SUM d) MIN 2) Which symbol is used to start a formula in Excel? a) # b) @ c) $ d) = 3) Which function can be used to combine the contents of multiple cells into one cell? a) CONCATENATE b) COMBINE c) MERGE d) JOIN 4) Which of the following is a cell reference in Excel? a) 1A b) A1 c) AB d) B2C3 5) What is the default file extension for an Excel workbook? a) .xls b) .csv c) .xlsx d) .docx

Leaderboard

Visual style

Options

Switch template

Continue editing: ?