Basic Excel Functions and Formulas Quiz

What is the purpose of the SUM function in Excel?

• To add up the values in a range of cells.

• To sort the values in a range of cells.

• To multiply the values in a range of cells.

• To find the average of the values in a range of cells.

How do you use the SUM function to add up a range of cells in Excel?

• =SUM(range of cells)

• =TOTAL(range of cells)

• =AVERAGE(range of cells)

• =ADD(range of cells)

What is one tool we can use to ensure our text fits in the cell?

• Squeeze text tool

• conditional formatting tool

• Wrap text tool

• Create table tool

What is the formula to multiply two cells in Excel?

• A1+B1

• A1/B1

• =A1*B1

• A1-B1

How do you make text bold, italic or underlined?

• Text decoration tools

• Font style tools

• change the size of the font

• Change the colour of the font

What are some key features of Excel that make it useful for data analysis?

• Sorting, filtering, pivot tables, data visualization

• Math problems, history essays, language translation

• Cooking, gardening, knitting, woodworking

• Word processing, graphic design, video editing, email management

What do we use excel for?

• Making presentations

• Writing a letter

• sorting and analyzing data

• Talking to friends

Which of the following will divide cell A1 by B1?

• B1/A1

• =A1/B1

• A1/B1

• =B1/A1

Explain the use of the Data Validation tool in Excel.

• It is used to create pivot tables in Excel.

• It is used to change the font style of the data in Excel.

• It is used to calculate formulas in Excel.

• It is used to control the type of data that can be entered into a cell or range of cells.