G4s MIS - Qualifying Exam
Basic Excel Exam
- 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
- 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
- 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
- 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.
- 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.
- 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.
- 7.There are three worksheets with every new workbook. You can change that automatic number if you want to.
- A.
True
- B.
False
- 8.###### means:
- A.
You've entered a number wrong.
- B.
You've misspelled something.
- C.
The cell is not wide enough.
- 9.To add a new row, click a cell in the row immediately above where you want the new row.
- A.
True
- B.
False
- 10.Which key do you press to group two or more nonadjacent worksheets?
- A.
CTRL.
- B.
SHIFT
- C.
ALT
- 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
- 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
- 13.Is it possible to insert an image from a file into an Excel spreadsheet ?
- A.
Yes
- B.
No
- 14.Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge ?
- A.
Yes
- B.
No
- 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
- 16.A Formula and a function are the same thing.
- A.
True
- B.
False
- 17.In order to multiply items in Excel you would use:
- A.
^
- B.
@
- C.
*
- D.
#
- 18.The formula = ((A2+B5)*5% is valid
- A.
True
- B.
False
- 19.What text function should use to combine text in different cell/s?
- A.
Substitute
- B.
Concatenate
- C.
Replace
- D.
Mid
- 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
Questions: 20 | Attempts: 100541 | Last updated: Jul 27, 2021
-
Sample QuestionA fast way to add up this column of numbers is to click on the cell below the numbers and then:
Questions: 10 | Attempts: 61338 | Last updated: May 30, 2021
-
Sample QuestionLabels are aligned at the ________ edge of the cell.
Questions: 10 | Attempts: 59571 | Last updated: Nov 19, 2020
-
Sample QuestionAn Excel Workbook is a collection of …….
Back to top