Excel and Spreadsheet Basics Quiz

What is a spreadsheet?

• A word processing tool

• A presentation tool

• A software used for calculations and data analysis

• A drawing program

What is the default file extension for MS Excel 2010 and later?

• .docx

• .xls

• .xlsx

• .pdf

The intersection of a row and column is called:

• Table

• Range

• Cell

• Block

A cell address is represented as:

• 1A

• Row only

• Column + Row (e.g., A1)

• Cell ID

What is the name of the currently selected cell?

• Cursor

• Field

• Active Cell

• Marker

What formula adds numbers in Excel?

• =TOTAL()

• =ADD()

• =SUM()

• =PLUS()

Which function finds the average of a group of numbers?

• =MID()

• =AVERAGE()

• =TOTAL()

• =ROUND()

Which function counts the number of numeric entries?

• =SUM()

• =COUNT()

• =COUNTA()

• =MAX()

Which function returns the highest value?

• =BIG()

• =TOP()

• =MAX()

• =LARGE()

Which function returns the lowest number?

• =BOTTOM()

• =LOWEST()

• =MIN()

• =SMALL()