Microsoft Excel Basics 2

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

• Pattern recognition

• Quick sort

• Custom list

• Auto-filling sequence

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

• Use the 'Adjust Width' tool

• Double-click the column separator

• Drag the column edge

• Right-click and select 'Fit to content'

What does Excel use to predict the next item in a sequence when using auto-fill?

• Artificial Intelligence

• Pattern recognition

• Random generation

• Manual input

How can you create a custom auto-fill list in Excel?

• Directly typing into the Excel formula bar

• Using the 'Custom List' feature under 'File'

• By right-clicking on the cell

• Through the 'Options' menu under 'Advanced'

What is the first step to sort data in Excel?

• Go to the 'Data' tab and select 'Sort'

• Highlight the list you want to sort

• Select the 'Sort' option from the right-click menu

• Use the quick sort buttons 'A to Z' or 'Z to A'

How can you apply a filter to data in Excel?

• Use the 'Filter' button in the 'Data' tab

• Select the data and press 'Ctrl+F'

• Right-click and choose 'Apply Filter'

• Go to 'View' and select 'Filter Mode'

What function allows you to round numbers in Excel?

• ADJUST()

• FIX()

• RND()

• ROUND()

What does adding a dollar sign ($) to a cell reference in a formula do?

• Increases the cell's value

• Converts the cell reference to absolute

• Locks the formula from editing

• Formats the cell as currency

What is the purpose of using the 'Custom Sort' feature in Excel?

• To sort data in a non-alphabetical order

• To sort data based on multiple levels

• To randomly sort data

• To sort data based on cell color

How can you make Excel automatically fill in a sequence of names or other custom lists?

• By dragging the fill handle

• Typing the first item and pressing 'Enter'

• Using the 'AutoComplete' feature

• Adding them to the custom lists in Excel options