Microsoft Excel Quiz: Test On Functions!

1. In EXCEL, you can sum a large range of data by simply selecting a tool button called …..

AutoFill

Auto correct

Auto sum

Auto format

In Excel, the AutoSum tool button allows you to quickly calculate the sum of a large range of data. This feature automatically selects the range of cells that Excel believes you want to sum, saving you the time and effort of manually selecting the range. By clicking on the AutoSum button, Excel will automatically insert the SUM function and highlight the range of cells being summed, making it easy to confirm and calculate the sum.

Explanation

In Excel, the AutoSum tool button allows you to quickly calculate the sum of a large range of data. This feature automatically selects the range of cells that Excel believes you want to sum, saving you the time and effort of manually selecting the range. By clicking on the AutoSum button, Excel will automatically insert the SUM function and highlight the range of cells being summed, making it easy to confirm and calculate the sum.

2. Microsoft Excel is powerful………..

Word processing package

Spreadsheet package

Communication S/W Package

DBMS package

Microsoft Excel is a spreadsheet package. It is a powerful tool that allows users to create, organize, and analyze data in a tabular format. Excel provides various features such as formulas, functions, charts, and graphs, which make it suitable for tasks related to data management, calculations, and data visualization. It is widely used for financial analysis, budgeting, data tracking, and creating reports. Therefore, the given answer, "Spreadsheet package," accurately describes Microsoft Excel's functionality and purpose.

Explanation

Microsoft Excel is a spreadsheet package. It is a powerful tool that allows users to create, organize, and analyze data in a tabular format. Excel provides various features such as formulas, functions, charts, and graphs, which make it suitable for tasks related to data management, calculations, and data visualization. It is widely used for financial analysis, budgeting, data tracking, and creating reports. Therefore, the given answer, "Spreadsheet package," accurately describes Microsoft Excel's functionality and purpose.

3. How do you rearrange the data in ascending or descending order?

Data, Sort

Data, Form

Data, Table

Data Subtotals

To rearrange data in ascending or descending order, you can use the "Data, Sort" function. This feature allows you to organize your data based on specific criteria, such as alphabetical order, numerical value, or date. By selecting the "Data, Sort" option, you can easily arrange your data in either ascending or descending order, making it more organized and easier to analyze.

Explanation

To rearrange data in ascending or descending order, you can use the "Data, Sort" function. This feature allows you to organize your data based on specific criteria, such as alphabetical order, numerical value, or date. By selecting the "Data, Sort" option, you can easily arrange your data in either ascending or descending order, making it more organized and easier to analyze.

4. Which function is not available in the Consolidate dialog box?

Pmt

Average

Max

Sum

The function "Pmt" is not available in the Consolidate dialog box. The Consolidate dialog box is used to combine data from multiple ranges into a single range. It allows users to perform calculations such as averaging, finding the maximum value, and summing the values. However, the "Pmt" function, which is used to calculate the payment for a loan or investment, is not available in this dialog box.

Explanation

The function "Pmt" is not available in the Consolidate dialog box. The Consolidate dialog box is used to combine data from multiple ranges into a single range. It allows users to perform calculations such as averaging, finding the maximum value, and summing the values. However, the "Pmt" function, which is used to calculate the payment for a loan or investment, is not available in this dialog box.

5. MS-EXCEL is based on ……….

WINDOWS

DOS

UNIX

OS/2

MS-EXCEL is based on WINDOWS operating system. This is because Microsoft Excel is a spreadsheet software developed by Microsoft, and it is designed to run on the Windows operating system. Windows provides the platform and environment for Excel to function and perform its tasks effectively.

Explanation

MS-EXCEL is based on WINDOWS operating system. This is because Microsoft Excel is a spreadsheet software developed by Microsoft, and it is designed to run on the Windows operating system. Windows provides the platform and environment for Excel to function and perform its tasks effectively.

6. To select an entire column in MS-EXCEL, press?

CTRL + C

CTRL + Arrow key

CTRL + S

None of the above

To select an entire column in MS-EXCEL, you can press CTRL + Spacebar. This keyboard shortcut allows you to select the entire column where the active cell is located. CTRL + C is used to copy, CTRL + Arrow key is used to navigate to the last cell in a column or row, and CTRL + S is used to save the workbook. None of these options are used to select an entire column.

Explanation

To select an entire column in MS-EXCEL, you can press CTRL + Spacebar. This keyboard shortcut allows you to select the entire column where the active cell is located. CTRL + C is used to copy, CTRL + Arrow key is used to navigate to the last cell in a column or row, and CTRL + S is used to save the workbook. None of these options are used to select an entire column.

7. An Excel Workbook is a collection of …….

Workbooks

Worksheets

Charts

Worksheets and Charts

An Excel Workbook is a collection of worksheets and charts. In Excel, a workbook is a file that can contain multiple worksheets, which are used to organize and manipulate data. Worksheets are the primary tool for entering, calculating, and analyzing data in Excel. Charts, on the other hand, are graphical representations of data that provide a visual representation of the information in the worksheets. By including both worksheets and charts, an Excel Workbook allows users to store and present data in a comprehensive and visually appealing manner.

Explanation

An Excel Workbook is a collection of worksheets and charts. In Excel, a workbook is a file that can contain multiple worksheets, which are used to organize and manipulate data. Worksheets are the primary tool for entering, calculating, and analyzing data in Excel. Charts, on the other hand, are graphical representations of data that provide a visual representation of the information in the worksheets. By including both worksheets and charts, an Excel Workbook allows users to store and present data in a comprehensive and visually appealing manner.

8. Which is not the function of the "Edit, Clear" command?

Delete contents

Delete notes

Delete cells

Delete formats

The "Edit, Clear" command is used to delete various elements in a document, such as contents, notes, and formats. However, it does not have the function to delete cells. This means that when using the "Edit, Clear" command, the user cannot delete entire cells from the document.

Explanation

The "Edit, Clear" command is used to delete various elements in a document, such as contents, notes, and formats. However, it does not have the function to delete cells. This means that when using the "Edit, Clear" command, the user cannot delete entire cells from the document.

9. What do you mean by a Workspace?

Group of Columns

Group of Worksheets

Group of Rows

Group of Workbooks

A workspace refers to a group of workbooks. It is a collection of multiple workbooks that are related to each other and can be opened and worked on simultaneously. Workspaces are useful when dealing with multiple files or projects that need to be organized and accessed together. They allow users to switch between different workbooks easily without having to open and close them individually. By grouping workbooks together in a workspace, it becomes more efficient and convenient to manage and navigate through multiple files simultaneously.

Explanation

A workspace refers to a group of workbooks. It is a collection of multiple workbooks that are related to each other and can be opened and worked on simultaneously. Workspaces are useful when dealing with multiple files or projects that need to be organized and accessed together. They allow users to switch between different workbooks easily without having to open and close them individually. By grouping workbooks together in a workspace, it becomes more efficient and convenient to manage and navigate through multiple files simultaneously.

10. To return the remainder after a number is divided by a divisor in EXCEL we use the function?

ROUND ( )

FACT ( )

MOD ( )

DIV ( )

The MOD() function in Excel is used to return the remainder after a number is divided by a divisor. This function takes two arguments, the number to be divided and the divisor, and returns the remainder as the result. Therefore, MOD() is the correct function to use in this scenario.

Explanation

The MOD() function in Excel is used to return the remainder after a number is divided by a divisor. This function takes two arguments, the number to be divided and the divisor, and returns the remainder as the result. Therefore, MOD() is the correct function to use in this scenario.