Basics of Excel

Which Excel feature allows you to create a form-like interface to enter, view, and search data?

• Formulas

• Excel Form

• Filter

• Data Validation

What Excel tool allows you to automatically generate a series of numbers, dates, or patterns?

• A. AutoSum

• B. Fill Handle / Series Fill

• C. Sort

• D. Flash Fill

Which symbol is used in Excel to perform division?

• A. *

• B. /

• C. \

• D. %

In Excel formulas, what can you use to control the order of operations?

• A. Commas

• B. Quotes

• C. Parentheses ()

• D. Brackets []

Which part of Excel displays the name of the current workbook?

A. Status Bar
B. Formula Bar
C. Title Bar
D. Ribbon

• A. Status Bar

• B. Formula Bar

• C. Title Bar

• D. Ribbon

Which Excel function returns the arithmetic mean (average) of a range of numbers?

• A. MEAN()

• B. AVERAGE()

• C. MID()

• D. MEDIAN()

Which option lets you add a new vertical set of cells into a worksheet?

• A. Insert Row

• B. Insert Column

• C. Merge Cells

• D. Split Cells

Which Excel feature allows you to undo, redo, or quickly save your work with one click?

• A. Ribbon

• B. Quick Access Toolbar

• C. Formula Bar

• D. Status Bar

Which function adds values together in Excel?

• A. AVERAGE()

• B. SUM()

• C. MAX()

• D. MIN()

Which function in Excel is used to count the number of cells that meet a certain condition?

• A. COUNTA()

• B. COUNTIF()

• C. COUNT()

• D. SUMIF()