JSKBS - Computer Applications for Business

1. What is the purpose of recording a macro in Excel?

• To create a shortcut for frequently used Excel commands.

• To automate repetitive tasks by recording a series of actions.

• To import data from external sources into an Excel worksheet.

• To calculate complex formulas and functions automatically.

What feature in Excel allows you to play with data by searching, sorting, and filtering?

• Conditional Formatting

• Vlookup

• Data Analysis Toolpak

• Data Validation

2. How can you create a data validation rule to allow only numeric entries in a cell?

• Select the cell, go to Data Validation, and choose “Whole Number” as the validation criteria.

• Select the cell, go to Data Validation, and choose “Text Length” as the validation criteria.

• Select the cell, go to Data Validation, and choose “Decimal” as the validation criteria.

• Select the cell, go to Data Validation, and choose “Custom” as the validation criteria.

1. What is the purpose of a Pivot Table in Excel?

• To create dynamic formulas

• To sort data in ascending order

• To summarize and analyze large data sets

• To perform complex calculations

What does the 'sumif' function do in Excel?

• Returns the current date and time formatted as a date and time

• Adds the cells specified by a given condition or criteria

• Converts hours, minutes, and seconds given as numbers to an Excel serial number formatted with a time format

• Returns true if the number is even

1. Which Excel feature is used to highlight cells that meet specific criteria?

• Conditional Formatting

• Data Validation

• Sorting

• Filtering

What add-in program serves as the data analyzing tool in Excel?

• Excel Analyse

• Analysis Toolpak

• Analysis Tool

• Data Analysis

What is 'Goal Seek' used for in Excel?

• To find a specific goal in a dataset

• To achieve a specific result in one cell by adjusting the value of another cell

• To seek out errors in data

• To search for a specific value in a column

What does 'Slicer' refer to in Excel?

• A tool for cutting data into smaller parts

• A feature for creating dynamic charts

• A control tool for filtering data in tables, pivot tables, or pivot charts

• A formula for slicing arrays

What is the purpose of the 'Quick Analysis' tool in Excel?

• To analyze data errors quickly

• To quickly analyze the data of Excel functions

• To quickly format, create charts, or add various types of analysis like totals

• To perform quick data entry