Excel Basic Function

What is the intersection of a column and a row on a worksheet called?

• Cell
• Value
• Address
• Column

Which feature in Excel displays only the data in column(s) according to specified criteria?

• Formula
• Filtering
• Pivot
• Sorting

What software is commonly used for statistical calculations and preparation of tables and graphs?

• Excel
• Notepad
• Powerpoint
• Adobe Photoshop

Which type of chart is suitable for comparing the performance of two employees in a specific year?

• Dot Chart
• Column Chart
• Line Chart
• Pi Chart

In MS Excel, functions must begin with which symbol?

• A > Sign
• An Equal Sign
• A Plus Sign
• A () Sign

What symbol must functions in MS Excel begin with?

• A > Sign
• A () Sign
• A Plus Sign
• An Equal Sign

What is the process of arranging the items of a column in some sequence or order called?

• Arranging
• Sorting
• Autofill
• Filtering

Which type of chart is useful for comparing parts of a whole?

• Line Chart
• Dot Graph
• Column Chart
• Pi Chart

If one wanted to compare an individual contribution to the whole, which chart type would be used?

• Bar Chart
• Pi Chart
• Column Chart
• Line Chart

What is the basic unit of a worksheet in Excel where data is entered called?

• Box
• Cell
• Table
• Column