Microsoft Excel Quiz MCQ Test!
Do you want to become familiar with Microsoft Excel? Do you think you can pass this quiz? Microsoft Excel helps to organize information in an easy to navigate way. It does complicated math problems so that you don’t have to. It creates, builds, and edits pixelated images, and it also helps you organize data into helpful graphics and charts. If you want to learn more about Microsoft Excel, look no further than this quiz.
- 1.
Which language is used to create macros in Excel?
- A.
Visual Basic
- B.
C
- C.
Visual C++
- D.
Java
Correct Answer
A. Visual BasicExplanation
Visual Basic is the language used to create macros in Excel. It is a programming language developed by Microsoft and is specifically designed for creating applications and automating tasks in Microsoft Office, including Excel. Visual Basic for Applications (VBA) is the version of Visual Basic used in Excel, allowing users to write and run macros to automate repetitive tasks, perform calculations, and manipulate data in Excel spreadsheets.Rate this question:
-
- 2.
Which of the following is not a term of MS-Excel?
- A.
Cells
- B.
Rows
- C.
Columns
- D.
Document
Correct Answer
D. DocumentExplanation
The term "Document" is not a term of MS-Excel. MS-Excel is a spreadsheet program used for organizing and analyzing data. It consists of cells, rows, and columns, which are the fundamental components of a spreadsheet. However, "Document" is not a specific component or feature in MS-Excel.Rate this question:
-
- 3.
How many worksheets can a workbook have?
- A.
3
- B.
8
- C.
255
- D.
None of above
Correct Answer
D. None of aboveExplanation
The correct answer is none of the above because a workbook in most spreadsheet software, such as Microsoft Excel, can have more than 255 worksheets. The number of worksheets that a workbook can have is typically limited by the available memory of the computer.Rate this question:
-
- 4.
Which would you choose to create a bar diagram?
- A.
Edit, Chart
- B.
Insert, Chart
- C.
Tools, Chart
- D.
Format, Chart
Correct Answer
B. Insert, ChartExplanation
To create a bar diagram in a document, the most suitable option would be to use the "Insert, Chart" feature. This option allows the user to insert various types of charts, including a bar chart, into the document. By selecting this option, the user can easily create a bar diagram by inputting the required data and customizing the chart according to their preferences. The other options mentioned, such as "Edit, Chart," "Tools, Chart," and "Format, Chart," do not specifically indicate the ability to create a chart or diagram, making "Insert, Chart" the correct choice.Rate this question:
-
- 5.
Which setting you must modify to print a worksheet using letterhead?
- A.
Paper
- B.
Margin
- C.
Layout
- D.
Orientation
Correct Answer
B. MarginExplanation
To print a worksheet using letterhead, you must modify the margin setting. The margin setting determines the amount of space between the content of the worksheet and the edges of the paper. By adjusting the margins, you can ensure that the letterhead is properly aligned and displayed on the printed worksheet.Rate this question:
-
- 6.
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
- A.
XY Chart
- B.
Line Chart
- C.
Pie Chart
- D.
Column Chart
Correct Answer
C. Pie ChartExplanation
A pie chart is a type of chart that shows the proportions or percentages of how one or more data elements relate to another data element. It is called a pie chart because the chart resembles a pie, with each slice representing a different proportion or percentage. Each slice of the pie represents a specific category or data element, and the size of the slice corresponds to the proportion or percentage it represents. Pie charts are commonly used to visualize data in a way that is easy to understand and compare different categories or data elements.Rate this question:
-
- 7.
The spelling dialog box can be involved by choosing to spell from ________ menu.
- A.
Insert
- B.
File
- C.
Tools
- D.
View
Correct Answer
C. ToolsExplanation
To access the spelling dialog box, you need to choose the "spell" option from the "tools" menu. This menu typically contains various tools and options related to editing and formatting text. By selecting the "spell" option from the "tools" menu, you can initiate the spell check process and correct any spelling errors in your document.Rate this question:
-
- 8.
Which key do you press to check to spell?
- A.
F3
- B.
F5
- C.
F7
- D.
F9
Correct Answer
C. F7Explanation
To check the spelling, you press the F7 key. This key is commonly used in word processing programs and text editors to initiate a spell check function. By pressing F7, the software will scan the document for spelling errors and provide suggestions for corrections. This feature helps ensure that the text is free from spelling mistakes and improves the overall quality and professionalism of the content.Rate this question:
-
- 9.
To record a sequence of keystrokes and mouse actions to playback later we use:
- A.
Media Player
- B.
Sound Recorder
- C.
Calculator
- D.
Macro Recorder
Correct Answer
D. Macro RecorderExplanation
A macro recorder is used to record a sequence of keystrokes and mouse actions. This allows users to automate repetitive tasks by playing back the recorded macro. It is commonly used in software testing, data entry, and other scenarios where the same sequence of actions needs to be performed multiple times. Unlike media players, sound recorders, and calculators, a macro recorder specifically focuses on recording and playing back user actions.Rate this question:
-
- 10.
We can save and protect the workbook by:
- A.
Write Reservation Password
- B.
Protection Password
- C.
Read-only Recommended
- D.
Any of the above
Correct Answer
D. Any of the aboveExplanation
The correct answer is "Any of the above" because all three options mentioned (Write Reservation Password, Protection Password, Read-only Recommended) can be used to save and protect the workbook. The choice depends on the specific requirements and level of security needed for the workbook.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
Back to top