Excel Functions and Features Assessment

This video tutorial provides a comprehensive guide to using Microsoft Excel for beginners. It covers the basics of creating workbooks, entering and managing data, using formulas and functions, formatting cells, creating charts, and printing or publishing documents. The tutorial aims to equip viewers with the essential skills needed to use Excel effectively, regardless of their prior experience.

What is the intersection of a column and a row in Excel called?

• Workbook

• Cell

• Range

• Sheet

Which feature in Excel helps to extend a pattern of data automatically?

• Autofill Handle

• Formula Bar

• Name Box

• Ribbon

How can you quickly resize columns to fit the data in Excel?

• Double-click between column headers

• Drag the column border

• Use the 'Format' menu

• Right-click and select 'Resize'

What symbol is used in Excel formulas to indicate multiplication?

• *

• x

• +

• /

What is the purpose of using a dollar sign ($) in Excel formulas?

• To add a comment

• To highlight a cell

• To create an absolute cell reference

• To indicate a currency format

What is the main difference between relative and absolute cell references in Excel?

• Neither change when copied.

• Both change when copied.

• Absolute references change when copied, relative references do not.

• Relative references change when copied, absolute references do not.

Which function would you use to find the highest value in a range of cells?

• MIN

• AVERAGE

• MAX

• SUM

What is the purpose of the AutoSum function in Excel?

• To automatically sum a range of cells.

• To automatically average a range of cells.

• To automatically count a range of cells.

• To automatically format a range of cells.

How can you quickly apply the same formatting from one cell to another in Excel?

• Use the Format Painter tool.

• Copy and paste the cell.

• Re-enter the data manually.

• Use the AutoFormat feature.

Which option allows you to save an Excel workbook as a PDF?

• Save As and select PDF format.

• Print and select PDF printer.

• Export and select PDF format.

• All of the above.