Test Formula & Functions

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

• Filtering
• Sorting
• Pivot
• Formula

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

• Powerpoint
• Excel
• Adobe Photoshop
• Notepad

Which one is not a Function in MS Excel?

• MIN
• AVG
• MAX
• SUM

Which type of chart is used to compare the performance of two employees in a specific year?

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

Which function in Excel checks whether a condition is true or not?

• SUM
• IF
• AVERAGE
• COUNT

In Excel, how are columns labeled?

• A1, A2, etc...
• $A$1, $B$2, etc...
• A, B, C etc...
• 1, 2, 3, etc...

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

• Arranging
• Sorting
• Autofill
• Filtering

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

• Arranging
• Sorting
• Autofill
• Filtering

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

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

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

• Cell
• Column
• Table
• Box