Excel Quiz

What is Flash Fill used for in Excel?

• To format cells

• To fill in data based on a pattern

• To create charts

• To sort data

Grace is working on an Excel spreadsheet to track her monthly expenses. She wants to count the number of entries she has made so far, excluding any blank cells. Which function should she use?

• COUNTBLANK

• COUNT

• COUNTA

• COUNTIF

What action does the Enter button perform in Excel?

• Deletes a cell

• Cancels a formula

• Completes a formula

• Opens a new worksheet

What should you press if you want to start over a formula in Excel?

• Ctrl

• Alt

• Esc

• Shift

What is the purpose of the Function Arguments dialog box?

• To format text

• To enter arguments for a formula

• To create a chart

• To sort data

Ava is working on a spreadsheet and uses Flash Fill to automatically fill in a series of data. What should she do after Excel shows a preview of Flash Fill?

• Press Esc

• Press Enter

• Press Tab

• Press Shift

What does the COUNT function do in Excel?

• Counts the number of text entries

• Counts the numbers in a range of cells

• Counts the number of formulas

• Counts the number of worksheets

What do the MAX and MIN functions return in Excel?

• The sum and difference of a range of cells

• The average and median of a range of cells

• The highest and lowest number in a range of cells

• The first and last number in a range of cells

How can you open the Insert Function dialog box if you don't have an active formula?

• By clicking the Home tab

• By pressing Ctrl + F

• By clicking the Insert Function button next to the formula bar

• By selecting the View tab

Which function uses a delimiter to link multiple items?

• CONCAT

• TEXTJOIN

• SORT

• MID