Prelim Exam: Computer Quiz MCQ!

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Anthzila
A
Anthzila
Community Contributor
Quizzes Created: 35 | Total Attempts: 45,169
| Attempts: 76
SettingsSettings
Please wait...
  • 1/25 Questions

    When creating formulas, it should always start with a _________.

    • Equal sign
    • Operator
    • Cell format
Please wait...
About This Quiz

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.

Prelim Exam: Computer Quiz MCQ! - Quiz

Quiz Preview

  • 2. 

    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 Tab
    Explanation
    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:

  • 3. 

    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 Tab
    Explanation
    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:

  • 4. 

    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 Tab
    Explanation
    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:

  • 5. 

    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 format
    Explanation
    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:

  • 6. 

    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 Bar
    Explanation
    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:

  • 7. 

    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 Tab
    Explanation
    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:

  • 8. 

    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 button
    Explanation
    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:

  • 9. 

    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:

  • 10. 

    This button replaces the file menu found in previous versions of Excel.

    • Office Button

    • Quick Access Toolbar

    • Title Bar

    • Ribbon

    Correct Answer
    A. Office Button
    Explanation
    The Office Button is the correct answer because it is the button that replaces the file menu in previous versions of Excel. The Office Button provides access to common file-related tasks such as opening, saving, and printing files. It is located in the top left corner of the Excel window and has the Microsoft Office logo on it. By clicking on the Office Button, users can access various options and commands related to managing files in Excel.

    Rate this question:

  • 11. 

    What number format to use when dealing with data that involves money?

    • Accounting

    • Number

    • Currency

    • General

    Correct Answer
    A. Currency
    Explanation
    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:

  • 12. 

    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 cell
    Explanation
    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:

  • 13. 

    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 cell
    Explanation
    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:

  • 14. 

    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 Toolbar
    Explanation
    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:

  • 15. 

    Is the following formula correct? a2+b2+c2  

    • True

    • False

    Correct Answer
    A. False
    Explanation
    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:

  • 16. 

    What is the maximum row height size you can set?

    • 255

    • 309

    • 409

    Correct Answer
    A. 409
    Explanation
    The maximum row height size that can be set is 409.

    Rate this question:

  • 17. 

    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:

  • 18. 

    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. Ribbon
    Explanation
    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:

  • 19. 

    What is the maximum column width size you can set?

    • 128

    • 256

    • 255

    Correct Answer
    A. 255
    Explanation
    The maximum column width size that can be set is 255.

    Rate this question:

  • 20. 

    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 cell
    Explanation
    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:

  • 21. 

    What number format to use when dealing with data that involves employee salary?

    • Accounting

    • Number

    • Currency

    • General

    Correct Answer
    A. Currency
    Explanation
    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:

  • 22. 

    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:

  • 23. 

    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 worksheet
    Explanation
    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:

  • 24. 

    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 Center
    Explanation
    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:

  • 25. 

    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. Date
    Explanation
    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:

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, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 04, 2012
    Quiz Created by
    Anthzila
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.