Excel Skills Test

59 Questions

Settings
Please wait...
Excel Skills Test

Dear Sara and SamarPlease take this QUIZ thoroughly as the questions have been developed to target some areasfrom basic, intermediate to advance level; Upon your completion the results will appear in mysystem then I'll be able to define your learning objectives with more focused sessions. Best of luckAmer


Questions and Answers
  • 1. 
    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.

  • 2. 
    Say that you want to paste a formula result — but not the underlying formula — to another cell.You would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?  
    • 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.

  • 3. 
    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.

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

      True

    • B. 

      False

  • 5. 
    ###### means: 
    • A. 

      You've entered a number wrong.

    • B. 

      You've misspelled something.

    • C. 

      The cell is not wide enough.

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

      True

    • B. 

      False

  • 7. 
    Which key do you press to group two or more nonadjacent worksheets? 
    • A. 

      CTRL.

    • B. 

      SHIFT

    • C. 

      ALT

  • 8. 
    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

  • 9. 
    A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this ?
    • A. 

      Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet

    • B. 

      Right click on the spreadsheet tab and select DELETE

    • C. 

      Right click on the spreadsheet and select INSERT - ENTIRE COLUMN

  • 10. 
    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

  • 11. 
    Is it possible to insert an image from a file into an Excel spreadsheet ?
    • A. 

      Yes

    • B. 

      No

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

      Yes

    • B. 

      No

  • 13. 
    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

  • 14. 
    A Formula and a function are the same thing.
    • A. 

      True

    • B. 

      False

  • 15. 
    In order to multiply items in Excel you would use:
    • A. 

      ^

    • B. 

      @

    • C. 

      *

    • D. 

      #

  • 16. 
    The formula = ((A2+B5)*5% is valid
    • A. 

      True

    • B. 

      False

  • 17. 
    If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the average?
  • 18. 
    If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the total?
  • 19. 
    Get the remarks in cell E10 that valued 75 which noted, if the remarks will be higher than 74, the remarks will be "PASSED" or else "FAILED".
  • 20. 
    Get the remarks in cell A1 that valued 75 which noted, if the remarks will be higher than 74, the remarks will be "PASSED" or else "FAILED".
  • 21. 
    You need to sort a column of names alphabetically. What do you do?
    • A. 

      Select the column you need to sort. Click the Data tab and click the Sort button

    • B. 

      Select the column you need to sort. Click the Insert tab and click the Group button

    • C. 

      Manually arrange the data properly

  • 22. 
    How you can lock columns to remain visibly when I scroll down my worksheet?
    • A. 

      I click the view tab and in the window group I click "Freeze Pane" and then click freeze top row

    • B. 

      I click the page layout option and the click breaks, insert break in top row

    • C. 

      Insert a pivot table with including the top row

  • 23. 
    Tables can organize data for easier reading and analysis. How do you create a table?
    • A. 

      After highlighting the data you need, select the insert tab and click on the Table button.

    • B. 

      From the window tab, click the insert button and select table

    • C. 

      Select your data and click the Page Layout tab. Click on the Table button

  • 24. 
    How can you highlight important numbers stand out from your excel table?
    • A. 

      I select the group of cells that I want to work with, then on the Home Tab,I click conditional fomating on the menu

    • B. 

      Right Click on the mouse and change the font of the cell

    • C. 

      I click the Home Tab and then change the colors in the Font Options

  • 25. 
    To adjust the column width or a row’s height, you need to:
    • A. 

      Click the format button under the cells tab.

    • B. 

      Click the conditional formatting button under the styles tab

    • C. 

      Click the Margings button under the Page Settup tab

  • 26. 
    You have a large spreadsheet that is full of names. What do you need to do to search for a single person’s name?
    • A. 

      Under the Data tab, click the Filter button and select the search option.

    • B. 

      Under the View tab, click the Zoom button and select the Find option

    • C. 

      Under the Home tab, click the find & select button and select the find option

  • 27. 
    Is Ctrl +  C the shortcut for copy selected text.
    • A. 

      True

    • B. 

      False

  • 28. 
    Is Ctrl + Z the shortcut for format the Cells dialogue box?
    • A. 

      True

    • B. 

      False

  • 29. 
    What is the common excel math fuction for finding the average value of the selected range
    • A. 

      =Median(A2:B3)

    • B. 

      =Average(A2:C14)

    • C. 

      =Max(B2:B88)

  • 30. 
    What is the common excel math function to find the largest value in the selected range. 
    • A. 

      =Sum(B4,B5)

    • B. 

      =Max(B2:B88)

    • C. 

      =Min(B2:B88)

  • 31. 
    To count the numer of cells that contain numbers, which formula you use?
    • A. 

      =count(A1:A5)

    • B. 

      =If(A2>2,"Yes")

    • C. 

      =sumcells(A1:A5)

  • 32. 
    Vlookup will look for a piece of information in a large table of data and pull in any field from that table into your new table?
    • A. 

      True

    • B. 

      False

  • 33. 
    Is Quick Analysis a way to easily display and summarize my data for meaningful conclusion?
    • A. 

      True

    • B. 

      False

  • 34. 
    The Pivot Table helps me to cross data and analyze it depending of what I am looking?
    • A. 

      True

    • B. 

      False

  • 35. 
    The $ symbol in the formula will block the column A =$A4
    • A. 

      True

    • B. 

      False

  • 36. 
    Is the next formula well type, =SumA5:A8
    • A. 

      True

    • B. 

      False

  • 37. 
    The formula "IF SUM" is use when I want to return one value if a condition is true and another value if it's false
    • A. 

      True

    • B. 

      False

  • 38. 
    The If error returns a value you specify if a formula evaluates to an error, otherwise, returns the result of the formula. =Iferror(value, value_if_error)
    • A. 

      True

    • B. 

      False

  • 39. 
    In a Vlookup formula. the __________- is the value to be found in the first column of the table, and can be a value, a reference, or text string
    • A. 

      Table Array

    • B. 

      Lookup Value

    • C. 

      Col Index Num

  • 40. 
    Is the next formula correct, =Vlookup(A5,$A$5:A10,0)
    • A. 

      True

    • B. 

      False

  • 41. 
    A function must always start with
    • A. 

      =sumif

    • B. 

      =sum

    • C. 

      =

    • D. 

      =sumif(

  • 42. 
    Common Functions that we use most often are
    • A. 

      =Sum

    • B. 

      =Average

    • C. 

      =Min

    • D. 

      =Max

    • E. 

      All of the above

  • 43. 
    Excel aloows you to create ____________________________ that refer to column and row labels in place of the cell reference or range.
    • A. 

      Comments

    • B. 

      Natural Language Formulas

    • C. 

      Arguments

    • D. 

      Functions

  • 44. 
    A block of cells in an Excel worksheet
    • A. 

      Area

    • B. 

      Range

    • C. 

      Cell

    • D. 

      Active cell

  • 45. 
    A range of cells can be __________________or ____________________.
    • A. 

      Connected, nonconnected

    • B. 

      Adjancent,non adjancent

    • C. 

      Contiguous, noncontiguous

  • 46. 
    Worksheets that are selected as a unit; any action performed on this uit will affect all the worksheets in the group.
    • A. 

      Active

    • B. 

      Grouping

    • C. 

      Attached

  • 47. 
    A Range name may use up to ________ characters.
    • A. 

      355

    • B. 

      155

    • C. 

      255

    • D. 

      555

  • 48. 
    The format for an IF statement is:
    • A. 

      =SUM(condition,x,y)

    • B. 

      =IF(condition,x,y)

    • C. 

      =(condition,x,y)

  • 49. 
    Correct format for a SUMIF statement is
    • A. 

      =SUMIF(range, critera,sum_range)

    • B. 

      =SUMIF(range,sum_range,critera)

    • C. 

      =SUMIF(sum_range,critera,range)

  • 50. 
    A graphic that allows you to compare and contrast data in a visual format.
    • A. 

      Plot

    • B. 

      Legend

    • C. 

      Chart

  • 51. 
    All charts use axes except
    • A. 

      Bar

    • B. 

      Line

    • C. 

      Plot

    • D. 

      Pie

  • 52. 
    A chart actually has two backfrounds: the larger _______ _______ and the smaller ______ ______ which can be formmatted.
    • A. 

      Tick mark, background

    • B. 

      Chart area, plot area

    • C. 

      Data axis, value axis

  • 53. 
    A chart that occupies its own worksheet
    • A. 

      Embedded chart

    • B. 

      Chart sheet

    • C. 

      Stand alone chart

  • 54. 
    A key that identifies each of the data series in a chart.
    • A. 

      Key

    • B. 

      Map

    • C. 

      Legend

  • 55. 
    Name the three parts that are typically found in a chart.
    • A. 

      Data series, Series labels and Catefory labels

    • B. 

      Name box, value labels, name labels

    • C. 

      X axis, y axis, z axis

  • 56. 
    Name two of the several ways to enhance a Chart Background
    • A. 

      Delete table

  • 57. 
    A ______________ends the argument.
    • A. 

      Quotation mark

    • B. 

      Closed parenthesis

    • C. 

      Comma

    • D. 

      Period

  • 58. 
    Name three rules for naming ranges
    • A. 

      Spaces are allowed, can start with a range name, Y2008

    • B. 

      Spaces are not allowed, do not start with range names, may include letters, numbers, underscores,blackslashes

    • C. 

      Must make sense, can start with a number, spaces are allowed

  • 59. 
    To display a comment in a worksheet
    • A. 

      Roll mouse over red triangle

    • B. 

      Open comment cell

    • C. 

      Must highlight cell