Intro to Microsoft Excel

Multiple Choice

What is the primary function of Microsoft Excel?

• To write and format text documents

• To create and manipulate spreadsheets with data

• To edit photos and graphics

• To browse the internet

Multiple Choice

What is the SUM function used for in Excel?

• To calculate the average of a range of numbers

• To find the highest number in a list

• To add together a range of numbers

• To count the number of cells in a range

Multiple Choice

Which of the following formulas will calculate the average of scores in cells B2 through B4?

• =SUM(B2:B4)

• =AVERAGE(B2:B4)

• =AVERAGE(2:4)

• =IF(B2>B4, B2, B4)