Microsoft Excel Quiz: Test On Functions!
(166).jpg "Microsoft Excel Quiz: Test On Functions! - Quiz")
Microsoft excel quiz: test on functions! Microsoft Excel is considered to be one of the most diverse Microsoft office tools as it not only allows calculations but can also allow processing of different sets of data. Are you confident in your ability to carry out different tasks with this tool? How about you take this quiz and see how true that is and which aspects of excel you may have forgotten!
- 1.
An Excel Workbook is a collection of …….
- A.
Workbooks
- B.
Worksheets
- C.
Charts
- D.
Worksheets and Charts
Correct Answer
D. Worksheets and ChartsExplanation
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.Rate this question:
-
- 2.
What do you mean by a Workspace?
- A.
Group of Columns
- B.
Group of Worksheets
- C.
Group of Rows
- D.
Group of Workbooks
Correct Answer
D. Group of WorkbooksExplanation
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.Rate this question:
-
- 3.
MS-EXCEL is based on ……….
- A.
WINDOWS
- B.
DOS
- C.
UNIX
- D.
OS/2
Correct Answer
A. WINDOWSExplanation
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.Rate this question:
-
- 4.
In EXCEL, you can sum a large range of data by simply selecting a tool button called …..
- A.
AutoFill
- B.
Auto correct
- C.
Auto sum
- D.
Auto format
Correct Answer
C. Auto sumExplanation
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.Rate this question:
-
- 5.
To select an entire column in MS-EXCEL, press?
- A.
CTRL + C
- B.
CTRL + Arrow key
- C.
CTRL + S
- D.
None of the above
Correct Answer
D. None of the aboveExplanation
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.Rate this question:
-
- 6.
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
- A.
ROUND ( )
- B.
FACT ( )
- C.
MOD ( )
- D.
DIV ( )
Correct Answer
C. MOD ( )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.Rate this question:
-
- 7.
Which function is not available in the Consolidate dialog box?
- A.
Pmt
- B.
Average
- C.
Max
- D.
Sum
Correct Answer
A. PmtExplanation
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.Rate this question:
-
- 8.
Which is not the function of the “Edit, Clear” command?
- A.
Delete contents
- B.
Delete notes
- C.
Delete cells
- D.
Delete formats
Correct Answer
C. Delete cellsExplanation
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.Rate this question:
-
- 9.
Microsoft Excel is powerful………..
- A.
Word processing package
- B.
Spreadsheet package
- C.
Communication S/W Package
- D.
DBMS package
Correct Answer
B. Spreadsheet packageExplanation
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.Rate this question:
-
- 10.
How do you rearrange the data in ascending or descending order?
- A.
Data, Sort
- B.
Data, Form
- C.
Data, Table
- D.
Data Subtotals
Correct Answer
A. Data, SortExplanation
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.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 24, 2010Quiz Created by
Mcqquestions