Excel Vocabulary Challenge

What is a function in Excel?

• A function in Excel is a predefined formula that performs calculations using specific values in a particular order.

• A function in Excel is a type of chart

• A function in Excel is a color used to highlight cells

• A function in Excel is a font style

How can you create a formula in Excel?

• Type the formula in all uppercase letters

• Begin with a hashtag (#) followed by the formula

• Use a semicolon (;) at the end of the formula

• Start with an equals sign (=) followed by the formula

What is data analysis in Excel?

• Data analysis in Excel is the process of organizing, cleaning, and analyzing data using Excel's tools and functions.

• Data analysis in Excel is the process of baking cookies

• Data analysis in Excel is the process of skydiving

• Data analysis in Excel is the process of creating animations

Explain the purpose of charts in Excel.

• The purpose of charts in Excel is to visually represent data for easier analysis.

• Charts in Excel are used for creating animations

• Charts in Excel are designed to play music

• Charts in Excel are meant for sending emails

What is a Pivot Table used for in Excel?

• A Pivot Table is used to create animations in Excel.

• A Pivot Table is used to summarize and analyze data in Excel.

• A Pivot Table is used to send emails in Excel.

• A Pivot Table is used to play music in Excel.

How can you apply conditional formatting in Excel?

• Apply bold formatting

• Click on the File tab

• Use the Insert function

• Select range -> Home tab -> Conditional Formatting -> Choose rule -> Set conditions -> OK

Name three parts of Excel interface.

• Cell grid

• Data tab

• Menu bar

• Ribbon, Worksheet area, Formula bar

What is the function of SUM in Excel?

• To add up values in a range of cells.

• To multiply values in a range of cells.

• To sort values in a range of cells.

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

How do you use VLOOKUP in Excel?

• Select cell -> Data tab -> Lookup & Reference -> VLOOKUP -> Enter lookup value, table array, column index number, range lookup -> Press Enter

• Select cell -> Formulas tab -> Lookup & Reference -> VLOOKUP -> Enter lookup value, table array, column index number, range lookup -> Press Enter

• Choose a cell -> Review tab -> Lookup & Reference -> VLOOKUP -> Enter lookup value, table array, column index number, range lookup -> Press Enter

• Click on a cell -> Insert tab -> Lookup & Reference -> VLOOKUP -> Enter lookup value, table array, column index number, range lookup -> Press Enter

What is the purpose of a line chart in Excel?

• To bake cookies

• To show trends over time or compare data points.

• To play music

• To predict the weather