Excel Functions and Features Assessment

This video tutorial introduces Excel, covering its interface, creating data forms, adjusting column widths, filling numbers and dates, and using formulas. It provides practical tips and shortcuts for efficient Excel use, aiming to help beginners understand and utilize Excel's features effectively.

What is the primary component of an Excel file?

• Rows

• Tables

• Charts

• Cells

Which key should you press to move the cursor to the right cell after entering data?

• Shift

• Ctrl

• Tab

• Enter

How can you adjust the width of a column to fit the text in Excel?

• Use the Format menu

• Right-click the column

• Double-click the column border

• Drag the column border

What feature allows you to center text across multiple cells?

• Wrap Text

• Text Direction

• Center Alignment

• Merge and Center

How can you quickly fill a series of numbers in Excel?

• Use the Format Painter

• Copy and paste

• Use the Fill Handle

• Type each number manually

What is the recommended format for entering dates in Excel?

• Using spaces

• Using hyphens

• Using slashes

• Using commas

Which keyboard shortcut enters today's date in a cell?

• Ctrl + T

• Ctrl + Enter

• Ctrl + ;

• Ctrl + D

What symbol is used to start a formula in Excel?

• -

• *

• +

• =

How does Excel adjust formulas when copied to another cell?

• It keeps the original cell references

• It converts the formula to text

• It adjusts the cell references relative to the new location

• It removes the formula

Which button would you use to apply a currency format to a cell?

• Percentage

• Accounting Number Format

• Currency Symbol

• Number Format