The Ultimate Microsoft Excel Quiz

115 Questions
The Ultimate Microsoft Excel Quiz

Do you want to test your knowledge on microsoft excel? Let's play this Excel practice quiz and prove yourself!

Please wait...
Questions and Answers
  • 1. 
    • A. 

      65536

    • B. 

      256

    • C. 

      64536

    • D. 

      1048576

  • 2. 
    • A. 

      View

    • B. 

      Formatting

    • C. 

      Home

  • 3. 
    You can have results of any database table into Excel Worksheet, and by one click you can refresh the results?
    • A. 

      True

    • B. 

      False

  • 4. 
    When using a databar, changing the value of one cell in the range will not affect the barsize of all the other cells.
    • A. 

      True

    • B. 

      False

  • 5. 
    The Insert Function dialog box tells you how to use functions.
    • A. 

      True

    • B. 

      False

  • 6. 
    When a worksheet is printed, the grid lines that surround the cells are printable by default.
    • A. 

      True

    • B. 

      False

  • 7. 
    When you clear a filter, all filters in the worksheet are cleared, if worksheet contains more than one filters
    • A. 

      True

    • B. 

      False

  • 8. 
    • A. 

      True

    • B. 

      False

  • 9. 
    The simplest and most convenient way to add a record to a table is to enter the data in the first blank row.
    • A. 

      True

    • B. 

      False

  • 10. 
    Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see when slice is larger.
    • A. 

      True

    • B. 

      False

  • 11. 
    Excel has a builtin format to display 4 digit year values, so you do not need to create one.
    • A. 

      True

    • B. 

      False

  • 12. 
    Formatting data only change the appearance of data, it does not affect the data itself.
    • A. 

      True

    • B. 

      False

  • 13. 
    If a formula contains several functions, Excel starts with the outermost function and then moves inward.
    • A. 

      True

    • B. 

      False

  • 14. 
    An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.
    • A. 

      True

    • B. 

      False

  • 15. 
    You can create maximum one Excel table in a worksheet
    • A. 

      True

    • B. 

      False

  • 16. 
    As you begin to type a function name within a formula into a cell, a list of functions that begin with the letters you typed appears.
    • A. 

      True

    • B. 

      False

  • 17. 
    You can rotate a 3D chart in only two directions: horizontally along the x-axis and vertically along the y-axis.
    • A. 

      True

    • B. 

      False

  • 18. 
    Pressing ENTER moves the selection one cell to the right by default.
    • A. 

      True

    • B. 

      False

  • 19. 
    Ctrl+B key makes the shortcut for making font in selected cell bold.
    • A. 

      True

    • B. 

      False

  • 20. 
    What key should be used to edit the content of a cell?
    • A. 

      F1

    • B. 

      F2

    • C. 

      F3

  • 21. 
    What function offers you the possibility to view different results depending on the entered condition?
    • A. 

      =If()

    • B. 

      =Sum()

    • C. 

      =SumIf()

  • 22. 
    A user wishes to remove a worksheet 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 worksheet

    • B. 

      Right click on the worksheet tab and select delete

    • C. 

      Right click on the worksheet and select insert - entire column

  • 23. 
    Which formula can add the all 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

  • 24. 
    What is the keyboard shortcut for creating a chart from the selected cells?
    • A. 

      F3

    • B. 

      F7

    • C. 

      F9

    • D. 

      F11

  • 25. 
    • A. 

      The sum of values in the cell's column

    • B. 

      Nothing until you selects a range of cells

    • C. 

      The sum of the cell's row unless you change the range

    • D. 

      A formula which will add values in the range Excel guesses you want to add

  • 26. 
    The view that puts a blue line around each page that would be printed is the _____.  
    • A. 

      Print Preview

    • B. 

      Normal

    • C. 

      Page Break Preview

    • D. 

      Split View

  • 27. 
    The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____.  
    • A. 

      B1-G10

    • B. 

      B1.G10

    • C. 

      B1;G10

    • D. 

      B1:G10

  • 28. 
    If you press _____, the cell accepts your typing as its contents but the focus stays in the same cell.  
    • A. 

      ENTER

    • B. 

      CTRL + ENTER

    • C. 

      TAB

    • D. 

      INSERT

  • 29. 
    Once data is entered into a cell, can it be edited after saving the file?
    • A. 

      Yes, but it has to be saved as a different file name.

    • B. 

      No, once it is saved it cannot be changed.

    • C. 

      Yes, even after saving the file, double click on the cell where data is to be changed to edit

  • 30. 
    On an Excel spreadsheet the active cell is indicated by
    • A. 

      A dark wide border

    • B. 

      A dotted border

    • C. 

      A blinking border

    • D. 

      None of the above

  • 31. 
    To select several cells or ranges that are not touching each other, you would _____ while selecting
    • A. 

      Hold down the CTRL key

    • B. 

      Hold down the SHIFT key

    • C. 

      Hold down the ALT key

  • 32. 
    What is a Workbook?
    • A. 

      A table of data that is organized into rows and columns

    • B. 

      The Excel file that holds your worksheets

    • C. 

      A built-in formula in Excel

  • 33. 
    A Function is?
    • A. 

      A symbol that represents a specific action

    • B. 

      A way of arranging data in a particular order

    • C. 

      A built-in formula in Excel

  • 34. 
    A Range in Microsoft Excel refers to...
    • A. 

      A group of cells

    • B. 

      A calculation that describes the relationship between cells

    • C. 

      A way of arranging data in a particular order

  • 35. 
    Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before?  
    • A. 

      Ribbon

    • B. 

      Formula Bar

    • C. 

      Tab

  • 36. 
    • A. 

      A symbol that represents a specific action

    • B. 

      A way of arranging data in a particular order

    • C. 

      Automatically change the width of a column to fit the longest entry or change the height of a row to fit the font

  • 37. 
    • A. 

      A symbol that represents a specific action

    • B. 

      Refers to the change a formula makes when it is moved or copied to other cells with different data

    • C. 

      A table of data that is organized into rows and columns

  • 38. 
    What is a Chart?  
    • A. 

      It is a visual way to display and compare data

    • B. 

      A way of arranging data in a particular order

    • C. 

      A calculation that describes the relationship between cells

  • 39. 
    • A. 

      Type the data in A1 and Merge cells A1:A5

    • B. 

      Type the data in A1 and Merge cells A1:E1

    • C. 

      Type the data in C1

    • D. 

      Choose Center from the Format menu

  • 40. 
    In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1="NO"?  
    • A. 

      Formula returns the value "DONE"

    • B. 

      Formula will show an error

    • C. 

      Formula returns the value "RESTART"

    • D. 

      Formula returns the value "YES"

  • 41. 
    After Excel displays an existing entry in the column that matches the characters you type, press the ______ key to accept the entry.
    • A. 

      Shift

    • B. 

      Tab

    • C. 

      Esc

    • D. 

      Alt

  • 42. 
    When creating an Excel workbook, you should avoid using ______ text and background together, since this is the most common form of color blindness.  
    • A. 

      Red and green

    • B. 

      Yellow and blue

    • C. 

      Black and white

    • D. 

      Red and yellow

  • 43. 
    The  ___________ allows you to use Excel to change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values.
    • A. 

      What-if analysis

    • B. 

      Track Changes

  • 44. 
    • A. 

      Sort A to Z and Sort Z to A buttons

    • B. 

      Quicksort Options

    • C. 

      Sort command on the Formulas tab

    • D. 

      Any of the above

  • 45. 
    =FUNCTION(argument1,argument2, ...) Is ________.
    • A. 

      The syntax of writing optional arguments.

    • B. 

      An example of a formula.

    • C. 

      The general syntax of all functions.

    • D. 

      The general syntax of all formulas.

  • 46. 
    • A. 

      Abbreviate all text

    • B. 

      Reduce the font size to 8 pt

    • C. 

      Click Wrap text

    • D. 

      Delete one column

  • 47. 
    • A. 

      Use Format Painter

    • B. 

      Format each element using the Toolbar

    • C. 

      Select all and use the Formatting dialog box

    • D. 

      Apply a table style

  • 48. 
    What is a workbook made up of?
    • A. 

      Rows & Columns

    • B. 

      Worksheets

    • C. 

      Files

  • 49. 
    To format a cell like an already formated one you can use ------------------------------- .
    • A. 

      The Fill down command

    • B. 

      The Autosum command

    • C. 

      The Format Painter command

    • D. 

      None of the above.

  • 50. 
    You use ______ filters to find all objects with a value greater than X or acquired after a certain date
    • A. 

      Custom

    • B. 

      Criteria

    • C. 

      Index

    • D. 

      Pivot

  • 51. 
    in "=SUM(number1 [,number2 ,number3 ...])" number 1, number 2, and number 3 may be numbers or __________.
    • A. 

      Letters

    • B. 

      Cell references

    • C. 

      Symbols

    • D. 

      Operators

  • 52. 
    You can use a spreadsheets package like the Microsoft Excel To _________________
    • A. 

      Design speadsheets models.

    • B. 

      Create charts.

    • C. 

      Perform mathematical operations

    • D. 

      All of the above

  • 53. 
    The name of the active cell appeares in the -----------------------.    
    • A. 

      Formula Bar

    • B. 

      Name box

    • C. 

      Column

  • 54. 
    Microsoft Excel 2007 is a ___________________?
    • A. 

      Word Processing Package

    • B. 

      Graphics Package

    • C. 

      Spreadsheets Package

    • D. 

      Multimedia Package

    • E. 

      None of the above

  • 55. 
    • A. 

      Go to the insert tab on the ribbon and select object. Choose Adobe Photoship Image from the box and select Ok

    • B. 

      Microsoft Office is not compatible with Adobe products

    • C. 

      Select Open from the Office Button. Browse to your image file, select the checkbox labeled Insert into current document and hit open.

    • D. 

      Simply drag and drop your Adobe Photoshop image file directly onto the worksheet you want to add it to

  • 56. 
    One person in the office is working on Excel 97, another in Excel 2000 and you are working in Excel 2007. How would you save it in order for other users can open and edit the file?
    • A. 

      Template

    • B. 

      Excel 97-2003 Workbook (*.xls)

    • C. 

      CSV

    • D. 

      HTML

  • 57. 
    Which Excel 2007 feature can be used to keep user desired rows or columns visible at all times when scrolling around the sheet?
    • A. 

      Headers

    • B. 

      Filter

    • C. 

      Freeze Panes

    • D. 

      Data Validation

  • 58. 
    What is the purpose of the Add-In Manager?    
    • A. 

      To allow administrative control over all projects on the system

    • B. 

      To add or remove templates, macros and wizards

    • C. 

      To allow insertion or deletion of data over the internet

    • D. 

      To create and manage additional protocols and data types for use in custom forms

  • 59. 
    Which of the Excel 2007 ribbon tab allow you to check spelling, add a comment, or protect your workbook?
    • A. 

      Data

    • B. 

      Review

    • C. 

      Preview

    • D. 

      Home

  • 60. 
    Which of the following keys/key can be used to check spelling and grammar?
    • A. 

      F1

    • B. 

      Ctrl-End

    • C. 

      F7

    • D. 

      Crt-Home

  • 61. 
    When using Excel 2007 which sign is used to create a formula or function in a cell?
    • A. 

      Single Quotes

    • B. 

      Double Quotes

    • C. 

      Equal Sign

    • D. 

      Parentheses

  • 62. 
    Which of the following would you use in an Excel formula to reference the cell located at column G row 17?
    • A. 

      G(17)

    • B. 

      G17

    • C. 

      Cgr17

    • D. 

      A cell is a dynamic value and cannot be referenced in a formula.

  • 63. 
    Which mathematical operation is performed by the ^ key in an Excel formula?
    • A. 

      Multiplication

    • B. 

      Factorial

    • C. 

      Power

    • D. 

      Logical

  • 64. 
    What is the area at the intersection of a single row and column in an Excel spreadsheet referred to as?    
    • A. 

      Matrix

    • B. 

      Window

    • C. 

      Sheet

    • D. 

      Cell

  • 65. 
    • A. 

      Multiply the value in A1 by the value in A2

    • B. 

      Raise the value in cell A1 to the power of A2

    • C. 

      Change cell values in A1 and A2 to text

    • D. 

      Compare the values in A1 and A2 and display the larger one

  • 66. 
    When creating an Excel formula, what does the cell reference with dollar signs like $A$1 do?
    • A. 

      Changes the cell format to currency with a dollar sign as the default

    • B. 

      Allows only numbers to be input into the cell

    • C. 

      Generates an error

    • D. 

      Creates an absolute reference

  • 67. 
    • A. 

      =ADD(J1-J8)

    • B. 

      =SUM(J1:J8)

    • C. 

      =J:1+J:8

    • D. 

      =SUM J:1-8

  • 68. 
    Which of Excel’s ribbon tabs is shown in the figure below?
    • A. 

      Review

    • B. 

      Home

    • C. 

      Data

    • D. 

      View

  • 69. 
    An Excel spreadsheet is also called a _______________________ .
    • A. 

      Document

    • B. 

      Worksheet

    • C. 

      Workbook

  • 70. 
    __________________ is the vertical part of the spreadsheet.
    • A. 

      Row

    • B. 

      Cell

    • C. 

      Columns

  • 71. 
    _____________ is the horizontal part of the spreadsheet.
    • A. 

      Rows

    • B. 

      Cell

    • C. 

      Column

  • 72. 
    Columns are identified by a _______________ .  
    • A. 

      Letter

    • B. 

      Number

    • C. 

      Word

  • 73. 
    Rows are identified by a _______________________
    • A. 

      Cell

    • B. 

      Column

    • C. 

      Number

  • 74. 
    The "Go To" dialogue appears when you press the _____________ key from keyboard.  
    • A. 

      F5

    • B. 

      F6

    • C. 

      F7

  • 75. 
    After writing the formula you have to press _____________________ key from the keyboard to see the answer.  
    • A. 

      Enter

    • B. 

      Shift-Enter

    • C. 

      Ctrl-Enter

    • D. 

      Any of the above

  • 76. 
    When a formula is written in a cell. It appears in the the active cell in which it is being written and in the __________________ bar as well.  
    • A. 

      Formula

    • B. 

      Name Box

    • C. 

      Title bar

  • 77. 
    Pie charts are most effective with ___________ or fewer slices.
    • A. 

      Six

    • B. 

      Seven

    • C. 

      Four

  • 78. 
    The _________________ displays the name of the sheets in the workbook.
    • A. 

      Sheet Tabs

    • B. 

      Book Tabs

    • C. 

      Menu Bar

  • 79. 
    A Logical test in Excel can contain =, >=, <=, >,<, <>, $
    • A. 

      All Except $

    • B. 

      All Except <>

    • C. 

      All Except =

    • D. 

      All Except >=

  • 80. 
    • A. 

      The Logical test and value if test is true, value if test is false

    • B. 

      The Logical test and the three possible outcomes

    • C. 

      The Logical test plus initial outcome plus true and false

    • D. 

      Logical test and value if true, value if test is false plus formatting options

  • 81. 
    Which of the following functions is correctly written?
    • A. 

      =IF(B2>50000,"rich","poor")

    • B. 

      =IF(B2>50000."rich","poor")

    • C. 

      IF(B2>50000,rich,poor)

    • D. 

      =IF(B2>50000),"rich","poor"))

  • 82. 
    Except for the ______________ function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
    • A. 

      =AND()

    • B. 

      =NOT()

    • C. 

      =OR()

    • D. 

      =COUNT()

  • 83. 
    What function would you use to display today's date so that tomorrow it will updates automatically
    • A. 

      =TODAY()

    • B. 

      =[date]

    • C. 

      =[system date]

    • D. 

      =datevalue()

  • 84. 
    Which function does not exist in Excel's function library?
    • A. 

      Upper

    • B. 

      Lower

    • C. 

      Proper

    • D. 

      Uppercase

  • 85. 
    What is the purpose of range lookup in VLOOKUP (lookup_value, table_array, col_index_num, range_lookup)?
    • A. 

      To identify exact matches

    • B. 

      To identify closest min value matches

    • C. 

      To identify closest max value matches

    • D. 

      To identify postive values

  • 86. 
    What feature enables you to adjust or solve the value in a cell to reach a desired outcome/result?
    • A. 

      Goal Seek

    • B. 

      Forcasting

    • C. 

      TrendLine

    • D. 

      Scenario Summary

  • 87. 
    A function inside another function is called a _____________ function.
    • A. 

      Nested

    • B. 

      Round

    • C. 

      Complex

    • D. 

      None of the above

  • 88. 
    What is the shortcut to add a hyperlink to your worksheet?
    • A. 

      Alt+H

    • B. 

      Alt+K

    • C. 

      Control+K

    • D. 

      Control+L

  • 89. 
    You can press ___________ to move between open Workbook
    • A. 

      F6

    • B. 

      Control + F6

    • C. 

      Shift + F6

    • D. 

      Control + Page down

  • 90. 
     You can select the current Row by pressing
    • A. 

      Control + spacebar

    • B. 

      Shift + spacebar

    • C. 

      Alt spacebar

    • D. 

      Shift + Tab

  • 91. 
    What chart object is a horizontal/vertical line extending across the plot area aiding reading values
    • A. 

      Catogory Axis

    • B. 

      Data Marker

    • C. 

      Data Point

    • D. 

      Grid line

  • 92. 
    You can use an operator to concatenate (join) text from two cells into one cell. Which operator is that?
    • A. 

      & (ampersand)

    • B. 

      $ (Dollar)

    • C. 

      Alt spacebar

    • D. 

      All of the previous options

  • 93. 
    Two common wildcard characters that Excel recognizes are
    • A. 

      * and /

    • B. 

      < and >

    • C. 

      * and ?

    • D. 

      + and –

  • 94. 
    What does SUMIFS function do?
    • A. 

      Add up cell values based on a condition

    • B. 

      Add all the numbers in a range of cells

    • C. 

      Returns a subtotal in a list or database

    • D. 

      All of Above

  • 95. 
    • A. 

      =COUNTIF(criteria, field_name, list_range)

    • B. 

      =COUNTIF(criteria, field_range)

    • C. 

      =COUNTIF(field_range, criteria)

    • D. 

      =COUNTIF(list_range, field_name, criteria_range)

    • E. 

      =COUNTIF(field_name, list_range, criteria_range)

  • 96. 
    You can display all formulas in an active worksheet by pressing the _____ keys
    • A. 

      Alt+~

    • B. 

      Ctrl+~

    • C. 

      Ctrl+W

    • D. 

      Ctrl+¬

  • 97. 
    Whict PivotTable toolbar button updates the data in a PivotTable if the data has changed?
    • A. 

      Show Detail

    • B. 

      Refresh Data

    • C. 

      Show Detail

    • D. 

      Group

  • 98. 
    What does the LEN() function do?
    • A. 

      Deletes Trailing spaces

    • B. 

      Splits the Cell contents

    • C. 

      Counts the number of characters in a cell

    • D. 

      All of the choices

  • 99. 
    Cell A5 shows a figure of 645123.875. Which of the following functions will display to the number is thousand?
    • A. 

      =Round(A5,-3)

    • B. 

      =Round(A5,-2)

    • C. 

      =Round(A5,-1)

    • D. 

      =Round(A5,1)

  • 100. 
    The divide symbol is
    • A. 

      /

    • B. 

      D

    • C. 

      \

    • D. 

      )

  • 101. 
    To add two cells (A1 and A2) together you use the following formula
    • A. 

      =A1+A2

    • B. 

      =Add(A1+A2)

    • C. 

      =together(A1:A2)

    • D. 

      A1 plus A2

  • 102. 
    You can print
    • A. 

      A range of cells by range name

    • B. 

      An entire workbook

    • C. 

      A single worksheet

    • D. 

      All of the above

  • 103. 
    Which is not an advantage of using computerized spreadsheets?
    • A. 

      Flexibility of moving entries

    • B. 

      Speed of calculation

    • C. 

      Ability of generate tables

    • D. 

      Cost of initial setup

  • 104. 
    Graphics objects on a chart are used to
    • A. 

      Add emphasis to chart data

    • B. 

      Add interest to a chart

    • C. 

      Help explain the chart data

    • D. 

      All of Above

  • 105. 
    To open the Format Cells dialog box, press
    • A. 

      Alt + 1

    • B. 

      Ctrl + 1

    • C. 

      Ctrl + Shift + 1

    • D. 

      F1

  • 106. 
    What term describes explanatory text attached to a cell
    • A. 

      Callouts

    • B. 

      Comments

    • C. 

      Dialogs

    • D. 

      Extensions

  • 107. 
    You can use the drag and drop method to
    • A. 

      Copy cell contents

    • B. 

      Delete cells contents

    • C. 

      Add cell contents

    • D. 

      Move cell contents

  • 108. 
    Which function converts miles to kilometers, kilograms to pounds, and so on?
    • A. 

      Convert

    • B. 

      Product

    • C. 

      Change

    • D. 

      All of above

  • 109. 
    To name a cell or range, you use the _______________
    • A. 

      Names Box

    • B. 

      Define name

    • C. 

      Paste name

    • D. 

      Format cells

  • 110. 
    • A. 

      =SUM(B3+B4+B5+B6)/4

    • B. 

      =AVE(B3:B6)

    • C. 

      =AVERAGE(B3:B6)

    • D. 

      =AVERAGE(B3+B4+B5+B6)/4

    • E. 

      =AVE(B3+B4+B5+B6)/4

  • 111. 
    • A. 

      This would select D9 and E9 and create an average from sheet2

    • B. 

      This would select D9 and E9 and add the two together from sheet2

    • C. 

      This would select D9 and E9 and add the two together from sheet1

    • D. 

      This forumla doesn't do anything.

  • 112. 
    What is the short key to enter the current date in a cell?
    • A. 

      CTRL+SHIFT+: (colon)

    • B. 

      CTRL+ ; (semicolon)

    • C. 

      CTRL+F10

    • D. 

      None of these

  • 113. 
    Which number formatting style adds the dollar signs and commas to values?
    • A. 

      Comma

    • B. 

      Currency

    • C. 

      Percent

    • D. 

      AdjustDecimal

  • 114. 
    The cell labeled F5 refers to
    • A. 

      Row F column 5

    • B. 

      Column F row 5

    • C. 

      Functions available in cells

    • D. 

      Function key F4

  • 115. 
    How would you print formulas?
    • A. 

      Click the Microsoft Office Button and then click Print.

    • B. 

      Click Normal on the View tab at the top of the screen, click the Microsoft Office Button, and then click Print.

    • C. 

      Point to Formula Auditing on the Formulas tab, click Show Formulas, click the Microsoft Office Button, and then click Print.