Microsoft Excel and PowerPoint 2016 Quiz

What is Microsoft Excel primarily used for?

• Presentation software

• Database management

• Spreadsheet application

• Word processing

Which of the following is NOT a feature of spreadsheets?

• Graphical representation of data

• Creating presentations

• Performing calculations

• Storing data

What is the purpose of the formula bar in Excel?

• To display the current date

• To enter and edit formulas

• To format cells

• To create charts

Which function would you use to calculate the sum of a range of cells?

• MAX()

• SUM()

• COUNT()

• AVERAGE()

What does the AutoFill feature do in Excel?

• Creates charts

• Fills data based on a pattern

• Automatically formats cells

• Calculates totals

In Excel, what does the term 'cell reference' mean?

• The address of a cell in a worksheet

• The name of a function

• The format of a cell

• The content of a cell

Which of the following is an example of a logical function in Excel?

• IF()

• AVERAGE()

• SUM()

• COUNT()

What is the result of the formula =A1+B1 if A1=5 and B1=10?

• 10

• 15

• 50

• 5

What does the VLOOKUP function do?

• Finds the maximum value

• Looks up a value in a vertical column

• Calculates the average of a range

• Counts the number of cells

Which of the following is a valid way to enter a date in Excel?

• DD-MM-YYYY

• All of the above

• MM/DD/YYYY

• YYYY/MM/DD