MS Excel 2016 Test: Quiz

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Romana Short
R
Romana Short
Community Contributor
Quizzes Created: 1 | Total Attempts: 3,236
Questions: 40 | Attempts: 3,236

SettingsSettingsSettings
MS Excel 2016 Test: Quiz - Quiz

Put your Excel skills to the test by taking this "MS Excel 2016 Test: Quiz". The quiz contains various questions ranging from easy and moderate to the hard level that will help you assess your Excel and knowledge and provide valuable feedback. Excel skills are a must-have in the cutthroat job industry today. Having good knowledge of Excel ensures you climb the career ladder faster than anyone. If you like the quiz, share it with your friends and family. All the best


Questions and Answers
  • 1. 

    What is the keyboard shortcut command to move the mouse pointer to cell A1?

    • A.

      Control + Home

    • B.

      Control + F4 key

    • C.

      Name box

    • D.

      Control + A1

    • E.

      Control + Tab key

    Correct Answer
    A. Control + Home
    Explanation
    The keyboard shortcut command "Control + Home" is used to move the mouse pointer to cell A1. This shortcut is commonly used in spreadsheet applications such as Microsoft Excel to quickly navigate to the top-left cell of a worksheet. By pressing the Control key and the Home key simultaneously, the user can easily jump to cell A1 without having to manually scroll or use the mouse.

    Rate this question:

  • 2. 

    A workbook contains:

    • A.

      1 worksheet

    • B.

      2 worksheets

    • C.

      3 worksheets

    • D.

      4 worksheets

    • E.

      No worksheets

    Correct Answer
    C. 3 worksheets
    Explanation
    The workbook contains 3 worksheets. This means that there are three separate sheets within the workbook where data can be entered and organized. Each worksheet can be used for different purposes or categories of information, allowing for better organization and management of data within the workbook.

    Rate this question:

  • 3. 

    The feature that enables you to automatically complete a list of 12 months after you key one month is:

    • A.

      Cell style

    • B.

      Fill handle or Autofill

    • C.

      Page layout

    • D.

      Find

    • E.

      Replace

    Correct Answer
    B. Fill handle or Autofill
    Explanation
    The feature that enables you to automatically complete a list of 12 months after you key one month is the Fill handle or Autofill. This feature allows you to drag the fill handle (a small square located in the bottom right corner of a cell) over a range of cells to automatically fill them with a series or pattern. In this case, after typing one month, you can use the fill handle to drag down and it will automatically fill the subsequent cells with the remaining 11 months.

    Rate this question:

  • 4. 

    What is the default alignment for values and dates in a cell?

    • A.

      Justified

    • B.

      Left aligned

    • C.

      Centered

    • D.

      Bottom aligned

    • E.

      Right aligned

    Correct Answer
    E. Right aligned
    Explanation
    The default alignment for values and dates in a cell is right aligned. This means that the content in the cell is aligned towards the right side of the cell. This is the standard alignment for numerical values and dates in most spreadsheet programs. Right alignment helps in visually organizing and comparing numerical data as it aligns the digits in a column, making it easier to read and understand the data.

    Rate this question:

  • 5. 

    How would the cell reference $F$4 be described?

    • A.

      Mixed reference

    • B.

      Absolute reference

    • C.

      Relative reference

    • D.

      Additional reference

    • E.

      Money reference

    Correct Answer
    B. Absolute reference
    Explanation
    The cell reference $F$4 is described as an absolute reference because the dollar signs before the column and row identifiers indicate that the reference is fixed and will not change when copied or filled. This means that no matter where the reference is copied to, it will always refer to cell F4.

    Rate this question:

  • 6. 

    What type of operation is being performed in the formula =A4*B5?

    • A.

      Addition

    • B.

      Subtraction

    • C.

      Division

    • D.

      Percentage

    • E.

      Multiplication

    Correct Answer
    E. Multiplication
    Explanation
    The formula =A4*B5 is performing a multiplication operation. It is multiplying the values in cell A4 and B5 together.

    Rate this question:

  • 7. 

    Which orientation is taller than it is wide?

    • A.

      Landscape

    • B.

      Portrait

    Correct Answer
    B. Portrait
    Explanation
    Portrait orientation is taller than it is wide. This means that the height of the image or document is greater than its width. It is commonly used for displaying vertical images or documents, such as portraits or pages of a book. In contrast, landscape orientation is wider than it is tall, making it suitable for displaying horizontal images or documents, such as landscapes or wide-angle photographs.

    Rate this question:

  • 8. 

    What term describes a model workbook used as the basis for other workbooks?

    • A.

      Form

    • B.

      Demonstration

    • C.

      Template

    • D.

      Cell styles

    • E.

      Page Layout

    Correct Answer
    C. Template
    Explanation
    A template is a model workbook that serves as the foundation for creating other workbooks. It provides a pre-designed structure and formatting, including formulas, macros, and layouts, that can be customized and reused for different purposes. Templates save time and effort by eliminating the need to recreate the same formatting and structure from scratch in every workbook.

    Rate this question:

  • 9. 

    How can you start Edit mode to edit a formula?

    • A.

      Tools

    • B.

      Format

    • C.

      F4

    • D.

      F2 or double-click cell

    • E.

      Find and replace

    Correct Answer
    D. F2 or double-click cell
    Explanation
    To start Edit mode and edit a formula, you can either press the F2 key on your keyboard or simply double-click on the cell containing the formula. This will allow you to directly modify the formula and make any necessary changes.

    Rate this question:

  • 10. 

    Three types of data visualation are:

    • A.

      Tools, Columns, Styles

    • B.

      Data bars, Color scales, Icon sets

    • C.

      Cell styles, Bold, Italics

    • D.

      Home, Edit, Fill

    • E.

      Shapes, Arrows, Clip art

    Correct Answer
    B. Data bars, Color scales, Icon sets
    Explanation
    The correct answer is Data bars, Color scales, Icon sets. These are three types of data visualization techniques commonly used in spreadsheets or data analysis tools. Data bars are horizontal bars that represent the values of cells, with longer bars indicating higher values. Color scales use different colors to represent different values, making it easy to identify patterns or trends in the data. Icon sets are small icons or symbols that can be used to visually represent different data categories or levels. These visualization techniques help to enhance the understanding and interpretation of data.

    Rate this question:

  • 11. 

    Name the function that adds cell values only if they meet your criteria.

    • A.

      Average()

    • B.

      Count()

    • C.

      Mean()

    • D.

      SumIF()

    • E.

      Round

    Correct Answer
    D. SumIF()
    Explanation
    The function "SumIF()" is the correct answer because it allows you to add cell values only if they meet specific criteria. This function is commonly used in spreadsheet programs like Microsoft Excel or Google Sheets to calculate the sum of a range of cells that meet a given condition or criteria. It is useful when you want to perform calculations on a subset of data based on certain criteria.

    Rate this question:

  • 12. 

    What function would display the highest sales amount in a column?

    • A.

      Min()

    • B.

      Avg()

    • C.

      Max()

    • D.

      Most()

    • E.

      Sum()

    Correct Answer
    C. Max()
    Explanation
    The Max() function is used to find the highest value in a given set of data. In this case, if we want to display the highest sales amount in a column, we would use the Max() function. This function will scan the column and return the maximum value, which represents the highest sales amount. Therefore, the Max() function is the correct choice for displaying the highest sales amount in a column.

    Rate this question:

  • 13. 

    Which logical function shows the opposite of the condition?

    • A.

      NOT function

    • B.

      False function

    • C.

      Nper function

    • D.

      Sum function

    • E.

      PMT function

    Correct Answer
    A. NOT function
    Explanation
    The NOT function is the logical function that shows the opposite of a condition. It returns the opposite Boolean value of the input. For example, if the input is TRUE, the NOT function will return FALSE, and vice versa. This function is commonly used to negate or reverse the outcome of a logical expression or condition.

    Rate this question:

  • 14. 

    Which financial function would help you determine how much money will be in your account at the end of a year if you make regular payments?

    • A.

      NPER function

    • B.

      Sum function

    • C.

      FV function

    • D.

      PMT function

    • E.

      Today function

    Correct Answer
    C. FV function
    Explanation
    The FV (Future Value) function would help determine how much money will be in your account at the end of a year if you make regular payments. The FV function calculates the future value of an investment based on a series of regular payments, a constant interest rate, and a specified number of periods. It is commonly used to forecast the growth of savings or investments over time.

    Rate this question:

  • 15. 

    What is the term used to describe a function inside a function?

    • A.

      Conditional

    • B.

      Argument

    • C.

      Nested

    • D.

      Double

    • E.

      Hyperlink

    Correct Answer
    C. Nested
    Explanation
    A nested function refers to a function that is defined inside another function. It is used to encapsulate and organize code, allowing the inner function to access variables and parameters from the outer function. This helps in creating modular and reusable code, as the inner function can only be accessed within the scope of the outer function.

    Rate this question:

  • 16. 

    What does a hyperlink do?

    • A.

      Adds another argument

    • B.

      Displays a website

    • C.

      Formats worksheet

    • D.

      Hides worksheets

    Correct Answer
    B. Displays a website
    Explanation
    A hyperlink is a clickable element that allows users to navigate to another webpage or website. It is commonly used in documents, emails, and websites to provide a quick and easy way to access additional information or related content. When a hyperlink is clicked, it opens the specified webpage or website in a new browser window or tab, allowing the user to view the content. Therefore, the correct answer is "Displays a website."

    Rate this question:

  • 17. 

    Which function enters the current date?

    • A.

      Now()

    • B.

      Days()

    • C.

      DDYYMM

    • D.

      TODAY()

    Correct Answer
    D. TODAY()
    Explanation
    The function TODAY() enters the current date.

    Rate this question:

  • 18. 

    What does Excel do if a function is volatile?

    • A.

      Renames the workbook

    • B.

      Closes the program

    • C.

      Recaculates it based on the computer where it is opened

    • D.

      Nothing changes

    Correct Answer
    C. Recaculates it based on the computer where it is opened
    Explanation
    When a function in Excel is marked as volatile, it means that the function's result can change even if its input values remain the same. In such cases, Excel will recalculate the function every time the workbook is opened on a different computer. This ensures that the function's result is always up-to-date and accurate, taking into account any changes or updates that may have occurred on the specific computer where the workbook is being opened.

    Rate this question:

  • 19. 

    How are data organized in a spreadsheet?  

    • A.

      Lines and spaces

    • B.

      Layers and planes

    • C.

      Rows and columns

    • D.

      Height and width

    Correct Answer
    C. Rows and columns
    Explanation
    Data in a spreadsheet are organized using rows and columns. Rows are horizontal lines that run across the spreadsheet, while columns are vertical lines that run down the spreadsheet. Each row represents a separate record or entry, while each column represents a specific attribute or field. This organization allows for easy data entry, sorting, and analysis in a structured and organized manner.

    Rate this question:

  • 20. 

    Which types of charts can excel produce?

    • A.

      Line graphs and pie charts only

    • B.

      Only line graphs

    • C.

      Bar charts, line graphs and pie charts

    • D.

      Bar charts and line graphs only

    Correct Answer
    C. Bar charts, line graphs and pie charts
    Explanation
    Excel can produce various types of charts including bar charts, line graphs, and pie charts. These charts are commonly used to visually represent data and provide a clear understanding of trends, comparisons, and proportions. Bar charts are effective for comparing different categories or groups, line graphs are useful for showing trends over time, and pie charts are ideal for illustrating proportions or percentages. With these three chart types, Excel offers a versatile range of options for data visualization and analysis.

    Rate this question:

  • 21. 

    Each excel file is called a workbook because:  

    • A.

      It can contain text and data

    • B.

      It can be modified

    • C.

      It can contain many sheets including worksheets and chart sheets

    • D.

      You have to work hard to create it

    Correct Answer
    C. It can contain many sheets including worksheets and chart sheets
    Explanation
    Each Excel file is called a workbook because it can contain many sheets, including worksheets and chart sheets. This means that within a single file, users can organize and manage different types of data and information by using multiple sheets. Worksheets allow for data entry, calculations, and analysis, while chart sheets enable the creation of visual representations of the data. This feature enhances the functionality and versatility of Excel as a tool for organizing and presenting information.

    Rate this question:

  • 22. 

    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 worksheet

    • B.

      Right click on the spreadsheet tab and select DELETE

    • C.

      Right click on the spreadsheet and select Insert – Entire Column

    • D.

      None of above

    Correct Answer
    B. Right click on the spreadsheet tab and select DELETE
    Explanation
    To remove a spreadsheet from a workbook, the correct sequence of events is to right-click on the spreadsheet tab and select DELETE. This action will delete the specific spreadsheet from the workbook. The other options mentioned in the question, such as going to File-Save As or inserting an entire column, are not relevant to removing a spreadsheet.

    Rate this question:

  • 23. 

    What is an expression that tells how the numbers in a determined set of cells are to be calculated? 

    • A.

      Formula

    • B.

      Field

    • C.

      Data

    • D.

      Query Correct Answer:

    Correct Answer
    A. Formula
    Explanation
    An expression that tells how the numbers in a determined set of cells are to be calculated is called a formula. A formula is a mathematical equation or operation that is used to perform calculations in spreadsheets or programming languages. It allows users to manipulate and analyze data by performing calculations based on the values in the specified cells.

    Rate this question:

  • 24. 

    You can use the formula palette to:

    • A.

      Format cells containing numbers

    • B.

      Create and edit formulas containing functions

    • C.

      Entered assumptions data

    • D.

      Copy a range of cells

    Correct Answer
    B. Create and edit formulas containing functions
    Explanation
    The formula palette in Excel allows users to create and edit formulas containing functions. Functions are predefined formulas that perform calculations or manipulate data in a specific way. By using the formula palette, users can easily access and insert various functions into their formulas, such as SUM, AVERAGE, or IF. This feature is essential for performing complex calculations and data manipulation tasks in Excel.

    Rate this question:

  • 25. 

    The autofill feature:

    • A.

      Extends a sequential series of data

    • B.

      Automatically adds a range of cell values

    • C.

      Applies a boarder around selected cells

    • D.

      None of above

    Correct Answer
    A. Extends a sequential series of data
    Explanation
    The autofill feature in Excel allows users to extend a sequential series of data by automatically filling in the remaining values based on the pattern of the initial selection. This saves time and effort by eliminating the need to manually enter each value in the series.

    Rate this question:

  • 26. 

    Where can you set the shedding color for a range of cells in Excel?  

    • A.

      Choose required color form Patterns tab of Format Cells dialog box

    • B.

      Choose required color on Fill Color tool in Formatting toolbar

    • C.

      Choose required color on Fill Color tool in Drawing toolbar

    • D.

      All of above

    Correct Answer
    D. All of above
    Explanation
    You can set the shedding color for a range of cells in Excel by choosing the required color from the Patterns tab of the Format Cells dialog box, by choosing the required color on the Fill Color tool in the Formatting toolbar, or by choosing the required color on the Fill Color tool in the Drawing toolbar.

    Rate this question:

  • 27. 

    How can you remove borders applied in cells?

    • A.

      Choose None on Border tab of Format cells

    • B.

      Open the list on Border tool in Formatting toolbar then choose first tool (no border)

    • C.

      Both of above

    • D.

      None of above

    Correct Answer
    C. Both of above
    Explanation
    You can remove borders applied in cells by either choosing "None" on the Border tab of the Format cells option or by opening the list on the Border tool in the Formatting toolbar and choosing the first tool, which represents no border. Both of these options will remove the borders from the cells.

    Rate this question:

  • 28. 

    Which function will you use to enter the current time in a worksheet cell?

    • A.

      =today()

    • B.

      =now()

    • C.

      =time()

    • D.

      =currentTime()

    Correct Answer
    B. =now()
    Explanation
    The correct answer is "=now()" because the NOW function is used to enter the current date and time in a worksheet cell. This function updates automatically whenever the worksheet is recalculated or opened, providing the most accurate and up-to-date information.

    Rate this question:

  • 29. 

    Formatting a cell in Number format you can’t set:  

    • A.

      Decimal Places

    • B.

      Use 1000 separator

    • C.

      Negative numbers

    • D.

      Currency Symbol

    Correct Answer
    D. Currency Symbol
    Explanation
    When formatting a cell in Number format, you have the ability to set the decimal places, use a 1000 separator, and display negative numbers. However, you cannot set the currency symbol. This means that if you want to display a currency symbol in a cell, you would need to use a different formatting option, such as Currency format.

    Rate this question:

  • 30. 

    Formatting a cell in Currency, you can specify

    • A.

      Decimal Places

    • B.

      Currency Symbol

    • C.

      Both of above

    • D.

      None of above

    Correct Answer
    C. Both of above
    Explanation
    When formatting a cell in Currency, you have the option to specify both the number of decimal places and the currency symbol. This means that you can control how many decimal places are displayed for the currency value, and also choose the appropriate currency symbol to be displayed alongside the value. By selecting "Both of above" as the answer, it indicates that both the decimal places and currency symbol can be specified when formatting a cell in Currency.

    Rate this question:

  • 31. 

    You can automatically adjust the size of the text in a cell if they do not fit in width by

    • A.

      Double clicking on the right border of column header

    • B.

      From Format choose Columns and then Autofit Selection

    • C.

      From Format Cells dialog box mark Shrink to fit check box

    • D.

      All of above

    Correct Answer
    C. From Format Cells dialog box mark Shrink to fit check box
    Explanation
    By selecting the "Shrink to fit" option in the Format Cells dialog box, the size of the text in a cell can be automatically adjusted to fit within the width of the cell. This means that if the text is too long to fit in the cell, it will be automatically resized to fit without altering the width of the column. This option is useful when working with large amounts of data and limited space, as it allows for the efficient display of information without sacrificing readability.

    Rate this question:

  • 32. 

    Which of the cell pointer indicates that you can move the content to another cell?

    • A.

      Doctor’s symbol (Big Plus)

    • B.

      Small thin plus icon

    • C.

      Mouse Pointer with anchor at the tip

    • D.

      None of above

    Correct Answer
    C. Mouse Pointer with anchor at the tip
    Explanation
    The mouse pointer with an anchor at the tip indicates that you can move the content to another cell. This symbol is commonly used to represent the drag-and-drop functionality in spreadsheet programs. By clicking and dragging the content with this pointer, you can easily move it to a different cell within the spreadsheet.

    Rate this question:

  • 33. 

    To apply conditional formatting, you do the following except:

    • A.

      Select the cells you would like to format

    • B.

      Select the color scales

    • C.

      Select Home tab

    • D.

      Locate the styles group

    Correct Answer
    B. Select the color scales
    Explanation
    To apply conditional formatting, you need to select the cells you would like to format, locate the styles group in the Home tab, and then choose the desired formatting option. However, selecting the color scales is not necessary to apply conditional formatting.

    Rate this question:

  • 34. 

    The fill handle doesn't always copy information from one cell directly into another cell.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The fill handle in Excel is a feature that allows users to quickly copy and fill data in adjacent cells. However, it doesn't always copy information directly from one cell to another. In some cases, it may apply a pattern or formula to the data before filling it into the adjacent cells. This can be useful when creating number sequences, dates, or applying formulas to a range of cells. Therefore, the statement "The fill handle doesn't always copy information from one cell directly into another cell" is true.

    Rate this question:

  • 35. 

    When you open an Excel workbook, there are__________ sheets by default.

    • A.

      Four

    • B.

      Three

    • C.

      Two

    • D.

      One

    Correct Answer
    B. Three
    Explanation
    When you open an Excel workbook, there are three sheets by default. This means that when you create a new workbook, it will already have three sheets named Sheet1, Sheet2, and Sheet3. These sheets allow you to organize your data and work on multiple sheets within the same workbook. You can rename or delete these sheets as needed, but initially, there are three sheets provided.

    Rate this question:

  • 36. 

    What command combines several cells into one cell occupying the same screen space?

    • A.

      Merge and Center

    • B.

      Align

    • C.

      Freeze columns

    • D.

      Indent

    • E.

      Split

    Correct Answer
    A. Merge and Center
    Explanation
    Merge and Center is the correct answer because this command allows you to combine multiple cells into one, while also centering the content within the merged cell. This is useful when you want to create a title or header that spans across multiple columns or rows, but still want it to be visually centered on the screen.

    Rate this question:

  • 37. 

    How would Excel display this value =ROUND(1.567) in the cell?

    • A.

      1

    • B.

      2

    • C.

      1.57

    • D.

      1.6

    Correct Answer
    B. 2
    Explanation
    The ROUND function in Excel rounds a number to the nearest integer. Since 1.567 is closer to 2 than it is to 1, it will be rounded up to 2. Therefore, the value displayed in the cell would be 2.

    Rate this question:

  • 38. 

    What does the VLOOKUP function do?  

    • A.

      Looks up text that contain ‘v’

    • B.

      Checks whether text is the same in one cell as in the next

    • C.

      Finds related records

    • D.

      All of above

    Correct Answer
    C. Finds related records
    Explanation
    The VLOOKUP function is used to find related records in a table or range. It searches for a specified value in the leftmost column of a table and returns a corresponding value from a specified column in the same row. This allows users to retrieve information from a large dataset based on a specific criteria or lookup value.

    Rate this question:

  • 39. 

    Excel is a:

    • A.

      Graphic program

    • B.

      None of these

    • C.

      Word processor

    • D.

      A spreadsheet Program

    Correct Answer
    D. A spreadsheet Program
    Explanation
    Excel is a spreadsheet program developed by Microsoft. It is used for creating, organizing, and analyzing data in a tabular format. It allows users to perform calculations, create charts and graphs, and automate tasks using formulas and functions. Unlike graphic programs, word processors, or other software, Excel is specifically designed for working with numerical data and performing calculations. Therefore, the correct answer is "A spreadsheet".

    Rate this question:

  • 40. 

    Which of the following is not an option in the spelling dialog?

    • A.

      Ignore

    • B.

      Edit

    • C.

      Ignore all

    • D.

      Change

    Correct Answer
    B. Edit
    Explanation
    The given question asks for the option that is not included in the spelling dialog. The options "ignore," "ignore all," and "change" are all common options found in a spelling dialog. However, "edit" is not typically found as an option in a spelling dialog. Therefore, "edit" is the correct answer as it is not an option in the spelling dialog.

    Rate this question:

Quiz Review Timeline +

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

  • Current Version
  • Feb 13, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Dec 04, 2017
    Quiz Created by
    Romana Short
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.