G4s MIS - Qualifying Exam

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 Jmsgnzls
J
Jmsgnzls
Community Contributor
Quizzes Created: 1 | Total Attempts: 672
| Attempts: 672
SettingsSettings
Please wait...
  • 1/20 Questions

    In order to multiply items in Excel you would use:

    • ^
    • @
    • *
    • #
Please wait...
About This Quiz

The G4S MIS - Qualifying exam assesses proficiency in Microsoft Excel, focusing on skills such as formula application, data filtering, multi-level sorting, and efficient cell operations. This quiz is designed to enhance practical Excel skills relevant for professional development.

Microsoft Excel Quizzes & Trivia

Quiz Preview

  • 2. 

    Is it possible to insert an image from a file into an Excel spreadsheet ?

    • Yes

    • No

    Correct Answer
    A. Yes
    Explanation
    It is indeed possible to insert an image from a file into an Excel spreadsheet. This can be done by selecting the desired cell or range of cells where the image should be placed, then navigating to the "Insert" tab in the Excel ribbon and clicking on the "Picture" option. From there, the user can browse their computer for the image file they want to insert and select it. The image will then be inserted into the spreadsheet at the chosen location.

    Rate this question:

  • 3. 

    Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge ?

    • Yes

    • No

    Correct Answer
    A. Yes
    Explanation
    An Excel spreadsheet can indeed be used as the "data source" for a Word Mail Merge. This is a common practice where the data from Excel, such as names and addresses, is merged into a Word document to create personalized letters, labels, or envelopes. Excel provides a convenient way to organize and manage the data, while Word allows for easy customization and formatting of the merged documents. By linking the Word document to the Excel spreadsheet, the data can be seamlessly merged, saving time and effort in creating personalized documents.

    Rate this question:

  • 4. 

    A fast way to add up this column of numbers is to click in the cell below the numbers and then: 

    • Click Subtotals on the Data menu.

    • View the sum in the formula bar.

    • Click the AutoSum button on the Standard toolbar, then press ENTER.

    Correct Answer
    A. Click the AutoSum button on the Standard toolbar, then press ENTER.
    Explanation
    To add up the column of numbers quickly, you can use the AutoSum button on the Standard toolbar. This button automatically selects the range of cells above it and inserts the SUM function, which calculates the sum of those cells. After clicking the AutoSum button, you can press ENTER to confirm the sum and display the result in the cell. This is a faster method compared to manually typing the SUM function or using other options like Subtotals on the Data menu or viewing the sum in the formula bar.

    Rate this question:

  • 5. 

    How do you change column width to fit the contents?

    • Single-click the boundary to the left of the column heading.

    • Double-click the boundary to the right of the column heading.

    • Press ALT and single-click anywhere in the column.

    Correct Answer
    A. Double-click the boundary to the right of the column heading.
    Explanation
    To change the column width to fit the contents in a spreadsheet, you can double-click the boundary to the right of the column heading. This action will automatically adjust the width of the column to accommodate the widest cell content within that column.

    Rate this question:

  • 6. 

    ###### means: 

    • You've entered a number wrong.

    • You've misspelled something.

    • The cell is not wide enough.

    Correct Answer
    A. The cell is not wide enough.
    Explanation
    The given answer suggests that the meaning of "######" is that the cell is not wide enough. This implies that when a cell in a spreadsheet or table is not wide enough to display the entire content, it is represented by "######" to indicate that the content is truncated. This commonly occurs when the content in the cell is too long or when the column width is not adjusted properly.

    Rate this question:

  • 7. 

    The formula = ((A2+B5)*5% is valid

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The given formula is not valid because it is missing a closing parenthesis. The correct formula should be = ((A2+B5)*5%). Therefore, the answer is false.

    Rate this question:

  • 8. 

    On an Excel sheet the active cell is indicated by ____.

    • A dark wide border

    • A dotted border

    • A blinking border

    • None of the above

    Correct Answer
    A. A dark wide border
    Explanation
    The active cell on an Excel sheet is indicated by a dark wide border. This border helps to differentiate the active cell from other cells on the sheet and makes it easier for the user to identify which cell is currently selected. The dark wide border stands out and is more visible than a dotted or blinking border, which may be used for other purposes in Excel. Therefore, the correct answer is a dark wide border.

    Rate this question:

  • 9. 

    What text function should use to combine text in different cell/s?

    • Substitute

    • Concatenate

    • Replace

    • Mid

    Correct Answer
    A. Concatenate
    Explanation
    The Concatenate function should be used to combine text in different cells. This function allows you to join together text from multiple cells into one cell. It is useful when you want to combine information from different cells into a single cell, such as combining first and last names or combining text with a specific format.

    Rate this question:

  • 10. 

    There are three worksheets with every new workbook. You can change that automatic number if you want to.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    By default, every new workbook in Excel comes with three worksheets. However, if desired, the user has the ability to change this automatic number and add or remove worksheets according to their needs. Therefore, the statement "There are three worksheets with every new workbook. You can change that automatic number if you want to" is true.

    Rate this question:

  • 11. 

    Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell ?

    • Count

    • Average

    • Sum

    Correct Answer
    A. Sum
    Explanation
    The formula that can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell is the "Sum" formula. This formula is specifically designed to add up a range of numbers and provide the total sum. It automatically ignores any non-numeric values in the range and only adds up the numeric values.

    Rate this question:

  • 12. 

    Say that you want to paste a formula result — but not the underlying formula — to another cell.

    • Click the Paste button on the Standard toolbar.

    • Click the arrow on the Paste button on the Standard toolbar, then click Formulas.

    • Click the arrow on the Paste button on the Standard toolbar, then click Values.

    Correct Answer
    A. Click the arrow on the Paste button on the Standard toolbar, then click Values.
    Explanation
    To paste only the result of a formula and not the formula itself, you need to click the arrow on the Paste button on the Standard toolbar and then select "Values". This will paste the calculated value of the formula into the desired cell, without including the underlying formula.

    Rate this question:

  • 13. 

    Which is the best method to sort a data set by multiple columns (i.e. a multi-level sort)?

    • Sort the data, then select the range of ties and sort that.

    • Go to Data and click Sort and add as many sorting levels as needed.

    • Sort by the first column, then select the second column and sort by that column.

    • Don’t know

    Correct Answer
    A. Go to Data and click Sort and add as many sorting levels as needed.
    Explanation
    The best method to sort a data set by multiple columns is to go to the Data tab and click on Sort. Then, you can add as many sorting levels as needed. This allows you to specify the order in which the columns should be sorted, creating a multi-level sort.

    Rate this question:

  • 14. 

    The ________ function performs a vertical lookup by searching for a value in the left-most column of the table and returning the value in the same row in the index_number position.

    • Index Match

    • Transpose

    • Vlookup

    • Lookup

    Correct Answer
    A. Vlookup
    Explanation
    The Vlookup function performs a vertical lookup by searching for a value in the left-most column of the table and returning the value in the same row in the index_number position.

    Rate this question:

  • 15. 

    To add a new row, click a cell in the row immediately above where you want the new row.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    In most spreadsheet applications like Microsoft Excel, when you want to add a new row, you can click on a cell in the row immediately above where you want the new row to appear. Then, when you insert a new row, it will be added above the selected row. This process ensures the new row is inserted in the correct location relative to your selected row.

    Rate this question:

  • 16. 

    Which is the best formula to add cells A1 and A4:A6 (A4 through A6) together?

    • =SUM(A1,A4,A5,A6)

    • =SUM(A1,A4:A6)

    • =SUM(A1:A6)

    • Don’t know

    Correct Answer
    A. =SUM(A1,A4:A6)
    Explanation
    The best formula to add cells A1 and A4:A6 together is =SUM(A1,A4:A6). This formula allows you to add the value in cell A1 to the sum of the values in cells A4 to A6.

    Rate this question:

  • 17. 

    Which key do you press to group two or more nonadjacent worksheets? 

    • CTRL.

    • SHIFT

    • ALT

    Correct Answer
    A. CTRL.
    Explanation
    To group two or more nonadjacent worksheets in Excel, you need to press the CTRL key. This key allows you to select multiple worksheets that are not next to each other by clicking on each worksheet tab while holding down the CTRL key. Once the worksheets are grouped, any changes made to one worksheet will be applied to all the grouped worksheets simultaneously.

    Rate this question:

  • 18. 

    A Formula and a function are the same thing.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    A formula and a function are distinct but related concepts in spreadsheet software. A formula is an expression used to calculate values, incorporating numbers, cell references, operators, and possibly functions. A function, however, is a predefined operation in the software that performs specific calculations, such as SUM, AVERAGE, or VLOOKUP. Functions are often used within formulas to simplify and perform complex calculations efficiently. Thus, while they work together, they are not the same thing.

    Rate this question:

  • 19. 

    To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down SHIFT, and then drag the selected sheet along the row of sheet tabs. 

    • True

    • False

    Correct Answer
    A. False
    Explanation
    To copy an entire worksheet and all its data, you should right-click the worksheet tab of the sheet that you want to copy, select "Move or Copy" from the context menu, choose the location where you want to copy the sheet to, and click "OK". Holding down SHIFT and dragging the selected sheet along the row of sheet tabs will only move the sheet to a different location, not copy it. Therefore, the answer is False.

    Rate this question:

  • 20. 

    Suppose column A contains a list of confectionary items. Which is the most efficient method to find anything containing “Chocolate”?

    • Select the Filter and type “choc” in the search box.

    • Sort the data alphabetically and then visually scan down the list.

    • Select the Filter, then click Text Filters and select Contains... and enter “Chocolate”.

    • Don’t know

    Correct Answer
    A. Select the Filter and type “choc” in the search box.
    Explanation
    The most efficient method to find anything containing "Chocolate" is to select the Filter and type "choc" in the search box. This allows for a quick and targeted search for any confectionary items that have the word "Chocolate" in them.

    Rate this question:

Quiz Review Timeline (Updated): Aug 27, 2024 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Aug 27, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 21, 2015
    Quiz Created by
    Jmsgnzls
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.