Excel Beginner 2 Quiz

What feature in Excel allows you to quickly fill in days of the week or months without typing them each time?

• Rounding function

• Auto-filling sequence

• Filter option

• Custom sort feature

How can you adjust a column width to fit its content in Excel?

• Right-click and select 'Fit to Content'

• Double-click the column edge

• Drag the column edge

• Use the sort feature

What does Excel do if you try to auto-fill using a single number?

• Creates a pattern based on nearby cells

• Copies the same number down

• Increments by one

• Generates a random sequence

How can you make Excel recognize a pattern when auto-filling numbers?

• Excel cannot recognize patterns in numbers

• Highlight two numbers that establish the pattern

• Use the 'Pattern Recognition' tool

• Type the first three numbers of the sequence

What can you do to add your own lists to Excel's auto-fill options?

• Edit the Excel program files

• Use the 'Custom Lists' option in Excel settings

• Download additional Excel add-ons

• It's not possible to add custom lists to auto-fill

What feature allows you to organize your Excel data based on specific criteria?

• Rounding

• Custom sort

• Auto-fill

• Filter

How can you apply a filter to your data in Excel?

• Right-click the column and select 'Filter'

• Use the 'Sort & Filter' option on the Home tab

• Filters are automatically applied

• Use the 'Data Analysis' tool

What function in Excel rounds a number to a specified number of digits?

• ROUND

• ROUNDDOWN

• ROUNDUP

• All of the above

What does the '$' symbol signify in an Excel formula?

• It converts a number to currency format

• It indicates an absolute cell reference

• It's used to denote a special function

• It's a shortcut for summing up a column

How can you quickly change all instances of a specific value in Excel formulas across multiple cells?

• Use the 'Quick Replace' feature

• Excel does not support this functionality

• Manually change each instance

• Use the 'Find and Replace' tool