ICT 0 version

What is Microsoft Excel primarily used for?

• Video Editing

• Spreadsheet Application

• Web Browsing

• Graphic Design

How do you select a range of cells in Excel?

• Click the first cell, hold Shift, and click the last cell

• Double-click the first cell and the last cell

• Right-click on the first cell and the last cell

• Click the first cell, hold Alt, and click the last cell

Where can most font commands be found in Excel?

• Insert Tab

• Home Tab in the Font Group

• View Tab

• Data Tab

What does sorting in Excel allow you to do?

• Hide rows

• Rearrange data in ascending or descending order

• Change the underlying data

• Add new rows

What is a chart in Excel?

• A table of data

• A graphical representation of data

• A formula for calculations

• A cell reference

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

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 is a macro in Excel?

• A type of formula for calculations

• A series of commands and instructions grouped together

• A function used to create pivot tables

• A type of chart

What is the primary purpose of the Macro Editor in Excel?

• To create charts and graphs

• To view and edit the code behind macros

• To format cell content

• To design pivot tables

What is the purpose of the 'Design' tab in Microsoft PowerPoint?

• To change the language settings of the presentation.

• To add animations to slides.

• To adjust the aesthetics and themes of the presentation

• To create speaker notes.