ИКТ(визаут 42 квешнс)

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

• Z1

• A1

• 1A

• 0,0

What does the VLOOKUP function in Excel primarily do?

• Search for values vertically in a table range

• Search for values horizontally in a table range

• Make logical comparisons between values

• Perform flexible lookups using INDEX and MATCH

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 intersection of a row and column in Excel called?

• Workbook

• Cell

• Tab

• Ribbon

What is Microsoft Excel primarily used for?

• Video Editing

• Spreadsheet Application

• Web Browsing

• Graphic Design

What does BEDMAS stand for?

• Brackets, Exponents, Division, Multiplication, Addition, Subtraction

• Brackets, Exponents, Division, Multiplication, Subtraction, Addition

• Brackets, Exponents, Addition, Subtraction, Division, Multiplication

• None of the above

What does the AutoSum command allow you to do?

• Insert common formulas like Sum, Average, Count Numbers, Max, and Min

• Insert hyperlinks

• Insert text functions

• Insert pivot tables

How can you force Excel to perform calculations if the automatic process is delayed?

• Click 'Formulas' tab and then 'Calculate Now'

• Click 'Home' tab and then 'Calculate Now'

• Click 'Data' tab and then 'Calculate Now'

• Click 'View' tab and then 'Calculate Now'

Why are macros needed in Excel?

• To create charts and graphs

• To perform complex calculations

• To edit cell content

• To change the font style

What do formulas in Excel always begin with?

• A hashtag (#)

• An equal sign (=)

• A dollar sign ($)

• A percentage sign (%)