ИКТ Excel Part 1, 2

How do you make a cell reference absolute in Excel?

• Using asterisks

• Using dollar signs

• Using percentage signs

• Using hashtags

Which function would you use to determine whether a student "Passes" or "Fails" based on their grades?

• VLOOKUP

• HLOOKUP

• IF

• INDEX

How can you run a macro in Excel if you've assigned a shortcut to it?

• Click 'Run Macro' in the Developer tab

• Press 'F12'

• Press the assigned shortcut key

• Click on the cell where the macro is recorded

What is the top-left cell in an Excel worksheet referenced as?

• Z1

• A1

• 1A

• 0,0

Which tab is NOT one of Excel's eight main tabs?

• Home

• Insert

• File

• Data

What is a workbook in Excel?

• A single worksheet

• A collection of one or more worksheets

• A single cell

• A single column

What does the CONCATENATE function in Excel do?

• Splits a text string into multiple strings

• Converts text to uppercase

• Combines several text strings into one string

• Removes spaces from text

What does the DATE function in Excel return?

• The day of the week

• The sequential serial number representing a date

• The month of the year

• The year of a date

What does the status bar display?

• Only the zoom level

• Information about the workbook

• Only the active cell

• Only temporary results

What do formulas in Excel always begin with?

• A hashtag (#)

• An equal sign (=)

• A dollar sign ($)

• A percentage sign (%)