Excel Features and Functions Year 8 Term 5

Which function in Excel allows you to search for a value in the first column of a table and return a value in the same row from another column?

• SUMIF

• VLOOKUP

• COUNTIF

• CONCATENATE

Where can you find the tools to insert ComboBoxes, Checkboxes, and Option Buttons in Excel?

• Home tab

• Insert tab

• Developer menu

• Data tab

What is the main purpose of a ComboBox in an Excel spreadsheet?

• To display a list of options for the user to select from

• To perform calculations

• To create charts

• To insert images

Which control would you use if you want users to select only one option from a group in Excel?

• Checkbox

• ComboBox

• Option Button

• Textbox

What is the function of a Checkbox in an Excel form?

• To allow users to select multiple options

• To enter text

• To perform calculations

• To create a drop-down list

How do you access the Developer menu in Excel if it is not visible?

• Right-click on the ribbon and select "Show Developer Tab"

• Go to File > Options > Customise Ribbon and tick "Developer"

• Press Ctrl + D

• It is always visible by default

Which of the following is NOT a use of a Textbox in Excel?

• To enter free-form text

• To display a list of options

• To collect user input

• To add comments or notes

When using the VLOOKUP function, what does the fourth argument (range_lookup) specify?

• The column to search in

• Whether to find an exact or approximate match

• The row number to return

• The worksheet name

Which control would you use to allow users to type in their own answer in an Excel form?

• Option Button

• Checkbox

• Textbox

• ComboBox

If you want to insert a Checkbox in Excel, which of the following steps is correct?

• Go to Home tab > Insert > Checkbox

• Go to Developer menu > Insert > Checkbox

• Go to Data tab > Data Validation > Checkbox

• Go to View tab > Show > Checkbox