Excel Functions and Features Assessment

What is the main purpose of Microsoft Excel?

• To create presentations.

• To write documents and letters.

• To create electronic spreadsheets for organizing data and performing calculations.

• To design websites.

Which of the following is an advantage of using Excel?

• Creating video games.

• Performing complex calculations and data analysis.

• Editing photos.

• Sending emails.

What is the name for the intersection of a column and a row in Microsoft Excel?

• A sheet

• A workbook

• A cell

• A range

What are the three main parts that make up the Excel Ribbon?

• Files, Folders, and Documents

• Tabs, Groups, and Commands

• Rows, Columns, and Cells

• Workbooks, Worksheets, and Charts

When you insert a new row in Excel, where does it appear relative to the row you selected?

• Below the selected row.

• To the right of the selected row.

• Above the selected row.

• To the left of the selected row.

When you drag the Fill Handle of a single selected cell in a spreadsheet, what happens to the content?

• It copies the number or text to other cells.

• It deletes the content from other cells.

• It changes the font of the content.

• It sorts the content alphabetically.

To arrange information in alphabetical order in a spreadsheet, which command should you use after selecting a cell in the desired column?

• Sort from Smallest to Largest

• Sort A to Z

• Fill Handle

• Trace Precedents

If you move a cell that contains a relative reference to another location, what happens to the reference itself?

• The reference remains unchanged.

• The reference changes based on the new relative position.

• The reference becomes an absolute reference.

• The reference is deleted.

What symbol is used in a cell reference to make it absolute, meaning it always refers to a specific cell location even if the formula is moved?

• # (hashtag)

• @ (at symbol)

• $ (dollar sign)

• % (percentage sign)

In the DATEDIF function, which argument tells the function the format in which you want the difference to be calculated (e.g., days, months, years)?

• Start Date

• End Date

• Interval

• Function