G4s MIS - Qualifying Exam
Basic Excel Exam
Questions and Answers
- 1.
Which is the best formula to add cells A1 and A4:A6 (A4 through A6) together?
- A.
=SUM(A1,A4,A5,A6)
- B.
=SUM(A1,A4:A6)
- C.
=SUM(A1:A6)
- D.
Don’t know
Correct Answer
B. =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:
-
- 2.
Suppose column A contains a list of confectionary items. Which is the most efficient method to find anything containing “Chocolate”?
- A.
Select the Filter and type “choc” in the search box.
- B.
Sort the data alphabetically and then visually scan down the list.
- C.
Select the Filter, then click Text Filters and select Contains... and enter “Chocolate”.
- D.
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:
-
- 3.
Which is the best method to sort a data set by multiple columns (i.e. a multi-level sort)?
- A.
Sort the data, then select the range of ties and sort that.
- B.
Go to Data and click Sort and add as many sorting levels as needed.
- C.
Sort by the first column, then select the second column and sort by that column.
- D.
Don’t know
Correct Answer
B. 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:
-
- 4.
A fast way to add up this column of numbers is to click in the cell below the numbers and then:
- A.
Click Subtotals on the Data menu.
- B.
View the sum in the formula bar.
- C.
Click the AutoSum button on the Standard toolbar, then press ENTER.
Correct Answer
C. 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.
Say that you want to paste a formula result — but not the underlying formula — to another cell.
- A.
Click the Paste button on the Standard toolbar.
- B.
Click the arrow on the Paste button on the Standard toolbar, then click Formulas.
- C.
Click the arrow on the Paste button on the Standard toolbar, then click Values.
Correct Answer
C. 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:
-
- 6.
How do you change column width to fit the contents?
- A.
Single-click the boundary to the left of the column heading.
- B.
Double-click the boundary to the right of the column heading.
- C.
Press ALT and single-click anywhere in the column.
Correct Answer
B. 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:
-
- 7.
There are three worksheets with every new workbook. You can change that automatic number if you want to.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 8.
###### means:
- A.
You've entered a number wrong.
- B.
You've misspelled something.
- C.
The cell is not wide enough.
Correct Answer
C. 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:
-
- 9.
To add a new row, click a cell in the row immediately above where you want the new row.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
To add a new row, you need to click a cell in the row immediately below where you want the new row, not above. Therefore, the statement "To add a new row, click a cell in the row immediately above where you want the new row" is false.Rate this question:
-
- 10.
Which key do you press to group two or more nonadjacent worksheets?
- A.
CTRL.
- B.
SHIFT
- C.
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:
-
- 11.
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.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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:
-
- 12.
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 ?
- A.
Count
- B.
Average
- C.
Sum
Correct Answer
C. SumExplanation
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:
-
- 13.
Is it possible to insert an image from a file into an Excel spreadsheet ?
- A.
Yes
- B.
No
Correct Answer
A. YesExplanation
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:
-
- 14.
Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge ?
- A.
Yes
- B.
No
Correct Answer
A. YesExplanation
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:
-
- 15.
On an Excel sheet the active cell is indicated by ____.
- A.
A dark wide border
- B.
A dotted border
- C.
A blinking border
- D.
None of the above
Correct Answer
A. A dark wide borderExplanation
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:
-
- 16.
A Formula and a function are the same thing.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A formula and a function are not the same thing. A formula is a mathematical expression used to perform calculations, while a function is a predefined operation that can take inputs and produce outputs. Functions can be used within formulas to perform specific tasks, but they are distinct concepts.Rate this question:
-
- 17.
In order to multiply items in Excel you would use:
- A.
^
- B.
@
- C.
*
- D.
#
Correct Answer
C. *Explanation
To multiply items in Excel, the correct symbol to use is "*". The asterisk symbol represents the multiplication operation in Excel. By using the asterisk symbol, you can multiply numbers or cells together to calculate the product.Rate this question:
-
- 18.
The formula = ((A2+B5)*5% is valid
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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:
-
- 19.
What text function should use to combine text in different cell/s?
- A.
Substitute
- B.
Concatenate
- C.
Replace
- D.
Mid
Correct Answer
B. ConcatenateExplanation
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:
-
- 20.
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.
- A.
Index Match
- B.
Transpose
- C.
Vlookup
- D.
Lookup
Correct Answer
C. VlookupExplanation
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:
-
Back to top