Prelim Exam: Computer Quiz MCQ!
-
This button replaces the file menu found in previous versions of Excel.
-
Office Button
-
Quick Access Toolbar
-
Title Bar
-
Ribbon
-
Prelim Exam: Computer Quiz MCQ tests your knowledge of Microsoft Excel interface, focusing on elements like the Office Button, Quick Access Toolbar, Title Bar, Ribbon, and various tabs. It's designed to enhance proficiency in navigating and utilizing Excel effectively.
.jpg "Prelim Exam: Computer Quiz MCQ! - Quiz")
Quiz Preview
- 2.
Contains common commands such as Save and Undo. You can add more commands as well.
-
Ribbon
-
Title Bar
-
Quick Access Toolbar
-
Office Button
Correct Answer
A. Quick Access ToolbarExplanation
The Quick Access Toolbar is the correct answer because it contains common commands such as Save and Undo, and allows users to add more commands as well. This toolbar is located at the top of the application window, providing easy access to frequently used commands, regardless of which tab is currently selected in the Ribbon. It offers a convenient way for users to quickly perform actions without navigating through various menus and options.Rate this question:
-
- 3.
Displays the name of the workbook you are currently working on and the name of the program you are using.
-
Office Button
-
Ribbon
-
Title Bar
-
Quick Access Toolbar
Correct Answer
A. Title BarExplanation
The title bar is the topmost horizontal bar in a window that displays the name of the workbook or document being worked on, as well as the name of the program or application being used. It provides a quick and easy way for users to identify the current file and program they are working with.Rate this question:
-
- 4.
The tabs and groups on the Ribbon replace the menus and toolbars found in previous versions of Excel.
-
Ribbon
-
Quick Access Toolbar
-
Title Bar
-
Office Button
Correct Answer
A. RibbonExplanation
The answer is Ribbon because the Ribbon is a feature in Excel that replaces the traditional menus and toolbars. It is a tabbed interface that organizes commands and functions into different groups, making it easier for users to access and use various features in Excel. The Ribbon provides a more intuitive and streamlined way of navigating and using Excel compared to the previous versions.Rate this question:
-
- 5.
Which of the following tab that incorporates all text and cell formatting features such as font and paragraph changes?
-
Formulas Tab
-
Page Layout Tab
-
Insert Tab
-
Home Tab
Correct Answer
A. Home TabExplanation
The Home Tab is the correct answer because it incorporates all text and cell formatting features such as font and paragraph changes. This tab is commonly used for basic formatting tasks in Microsoft Excel, such as changing the font style, size, and color, as well as aligning text and applying borders. It also includes options for formatting numbers, applying conditional formatting, and managing styles.Rate this question:
-
- 6.
This tab allows you to insert a variety of items into a document from pictures, clipart and headers, and footers.
-
Insert Tab
-
Formulas Tab
-
Page Layout Tab
-
Home Tab
Correct Answer
A. Insert TabExplanation
The Insert Tab allows users to insert various items into a document, such as pictures, clipart, headers, and footers. It provides a range of options for adding visual elements and formatting to enhance the document's appearance and functionality. This tab is commonly used when customizing the layout and design of a document.Rate this question:
-
- 7.
This tab has the commands to adjust pages such as margins, orientation, and themes.
-
Home Tab
-
Page Layout Tab
-
Formulas Tab
-
Insert Tab
Correct Answer
A. Page Layout TabExplanation
The Page Layout Tab is the correct answer because it contains commands that allow users to adjust various aspects of a document's pages, such as margins, orientation, and themes. This tab is specifically designed for formatting and organizing the layout of the document, making it the most appropriate choice for this question. The other tabs listed do not typically include these specific page adjustment commands.Rate this question:
-
- 8.
This tab holds an immense function library that can assist you when creating any formula or function in your spreadsheet.
-
Insert Tab
-
Page Layout Tab
-
Formulas Tab
-
Home Tab
Correct Answer
A. Formulas TabExplanation
The Formulas Tab is the correct answer because it contains a function library that can assist in creating formulas and functions in a spreadsheet. This tab provides access to various mathematical, logical, text, date, and other types of functions that can be used to perform calculations and manipulate data within the spreadsheet. It also includes tools for auditing and debugging formulas, as well as managing named ranges and formula calculations.Rate this question:
-
- 9.
Which of the following is true if you want to enter data in a worksheet?
-
Click the cell you want to enter data.
-
Point to the cell to enter data
-
Type the data in the cell.
-
All of the above
Correct Answer
A. Click the cell you want to enter data.Explanation
To enter data in a worksheet, you need to click on the cell where you want to enter the data. This is the correct answer because clicking on the cell allows you to select it and activate it for data entry. Pointing to the cell is not sufficient for entering data as it only highlights the cell without actually inputting any data. Typing the data in the cell is also necessary, but it is the action you perform after clicking on the cell. Therefore, the correct sequence is to click the cell you want to enter data, and then type the data in the selected cell.Rate this question:
-
- 10.
How to select a single cell?
-
Click the cell or press the arrow keys to move the cell
-
Click the first cell in the range, and then drag to the last cell
-
Click the first cell in the range, then hold down shift while you click the last cell in the range.
Correct Answer
A. Click the cell or press the arrow keys to move the cellExplanation
To select a single cell, you can either click on the cell directly or use the arrow keys to navigate to the desired cell. This allows you to highlight and work with only one cell at a time.Rate this question:
-
- 11.
How to select a range of cells?
-
Click the first cell in the range, then hold down shift while you click the last cell in the range.
-
Click the first cell in the range, and then drag to the last cell
-
Click the cell or press the arrow keys to move the cell
Correct Answer
A. Click the first cell in the range, and then drag to the last cellExplanation
To select a range of cells, you can click on the first cell in the range and then drag the cursor to the last cell. This action will highlight all the cells in between.Rate this question:
-
- 12.
How to select all cells in a worksheet?
-
Press CTRL A or click the select all button
-
Click the first cell in the range and then drag to the last cell
-
Click the cell or press the arrow keys to move the cell
Correct Answer
A. Press CTRL A or click the select all buttonExplanation
To select all cells in a worksheet, you can either press CTRL A or click the select all button. This will highlight all the cells in the worksheet, allowing you to perform actions on the entire range of cells at once.Rate this question:
-
- 13.
What is the easiest way to cancel any selection in the worksheet?
-
Click the cancel button
-
Click any cell in the worksheet
-
Close MS Excel and open again
-
None of the above
Correct Answer
A. Click any cell in the worksheetExplanation
To cancel any selection in the worksheet, you can simply click on any cell in the worksheet. This action deselects any selected cells or ranges, allowing you to start a new selection or perform other actions on the worksheet. The other options, such as clicking the cancel button or closing and reopening MS Excel, are not necessary or efficient methods to cancel a selection.Rate this question:
-
- 14.
When a cell displays an animated moving border around itself, what does it mean?
-
It means a cell was deleted.
-
It means that the cell was copied or cut.
-
It means a cell is adjusted.
-
None of the above.
Correct Answer
A. It means that the cell was copied or cut.Explanation
When a cell displays an animated moving border around itself, it means that the cell was copied or cut. This animation is a visual indication that the cell has been selected and is being moved or copied to another location. It helps the user to track the movement of the cell and ensures that they are aware of the action being performed on the cell.Rate this question:
-
- 15.
To move a cell using the mouse, what are the steps?
-
Select the cells or range of cells to move.
-
Click move button
-
Point to the border of the selection.
-
Drag the cell or range of cells to another location.
Correct Answer(s)
A. Select the cells or range of cells to move.
A. Click move button
A. Drag the cell or range of cells to another location.Explanation
To move a cell using the mouse, you first need to select the cells or range of cells that you want to move. Then, you click on the move button. After that, you need to point to the border of the selection and drag the cell or range of cells to another location.Rate this question:
-
- 16.
What is the maximum column width size you can set?
-
128
-
256
-
255
Correct Answer
A. 255Explanation
The maximum column width size that can be set is 255.Rate this question:
-
- 17.
What is the maximum row height size you can set?
-
255
-
309
-
409
Correct Answer
A. 409Explanation
The maximum row height size that can be set is 409.Rate this question:
-
- 18.
To set the column and row width and height, go to
-
Home tab and click cells
-
Home tab, then go to cells
-
Home tab, then go to cells group and click format
Correct Answer
A. Home tab, then go to cells group and click formatExplanation
To set the column and row width and height, you need to navigate to the Home tab. From there, you should go to the cells group and click on the format option. This will allow you to adjust the width and height of the columns and rows in your spreadsheet.Rate this question:
-
- 19.
At times, a cell might display #######. What does it mean?
-
It contains a text that exceeds the width of the cell
-
It contains a number or date that exceeds the width of the cell
-
The size of the width is too long
-
None of the above
Correct Answer
A. It contains a number or date that exceeds the width of the cellExplanation
When a cell displays "#######", it means that the number or date entered in the cell is too wide to fit within the column width. This usually happens when the number or date has more digits or characters than the column can accommodate. To fix this, the column width needs to be adjusted to make it wider or the number/date needs to be shortened or formatted differently to fit within the cell.Rate this question:
-
- 20.
Select from the choices below the steps in merging and centering cells.
-
Click Review Tab
-
Click Home Tab
-
Go to Alignment Group
-
Go to Align Group
-
Click Merger and Centering
-
Click Merge and Center
Correct Answer(s)
A. Click Home Tab
A. Go to Alignment Group
A. Click Merge and CenterExplanation
To merge and center cells in Microsoft Excel, you need to first click on the Home Tab, which is where the formatting options are located. Then, go to the Alignment Group, which contains the options for aligning and merging cells. Finally, click on the Merge and Center button to merge and center the selected cells.Rate this question:
-
- 21.
Check all the types of number formats in the following choices:
-
General
-
Text
-
Currency
-
Accounting
-
Date
-
Integer
Correct Answer(s)
A. General
A. Text
A. Currency
A. Accounting
A. DateExplanation
The given answer is correct. The types of number formats listed in the choices are General, Text, Currency, Accounting, Date. General format is used for displaying numbers as they are entered, Text format treats numbers as text and displays them as such, Currency format is used for displaying currency values, Accounting format is similar to currency format but it aligns the currency symbols and decimal points in a column, and Date format is used for displaying dates.Rate this question:
-
- 22.
What number format to use when dealing with data that involves money?
-
Accounting
-
Number
-
Currency
-
General
Correct Answer
A. CurrencyExplanation
When dealing with data that involves money, it is best to use the currency number format. This format ensures that the numbers are displayed with the appropriate currency symbol and decimal places, making it easier to read and understand the monetary values. It also helps in performing calculations and maintaining accuracy when working with financial data.Rate this question:
-
- 23.
What number format to use when dealing with data that involves employee salary?
-
Accounting
-
Number
-
Currency
-
General
Correct Answer
A. CurrencyExplanation
When dealing with data that involves employee salary, it is best to use the currency number format. This format ensures that the numbers are displayed with the appropriate currency symbol, decimal places, and formatting conventions. It helps to maintain consistency and clarity in representing salary figures, making it easier for users to understand and interpret the data accurately.Rate this question:
-
- 24.
When creating formulas, it should always start with a _________.
-
Equal sign
-
Operator
-
Cell format
Correct Answer
A. Equal signExplanation
When creating formulas, it should always start with an equal sign. This is because the equal sign is used to indicate that a formula is being entered in a cell. Without the equal sign, the content entered in the cell will be treated as text or a value, rather than a formula. Therefore, to perform calculations or use functions in Excel or other spreadsheet programs, it is important to begin the formula with an equal sign.Rate this question:
-
- 25.
Is the following formula correct? a2+b2+c2
-
True
-
False
Correct Answer
A. FalseExplanation
The formula a2+b2+c2 is incorrect because it does not represent a valid mathematical operation. In order to perform a mathematical operation, there needs to be an operator between the variables or constants. The given formula only consists of variables and constants without any operators, making it invalid.Rate this question:
-
Quiz Review Timeline (Updated): Mar 20, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 20, 2023Quiz Edited by
ProProfs Editorial Team -
Jan 04, 2012Quiz Created by
Anthzila
Back to top