MS Excel 2016 Test: Quiz

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Romana Short
R
Romana Short
Community Contributor
Quizzes Created: 1 | Total Attempts: 4,292
| Attempts: 4,292 | Questions: 40
Please wait...
Question 1 / 40
0 %
0/100
Score 0/100
1. How are data organized in a spreadsheet?  

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.

Submit
Please wait...
About This Quiz
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... see morelevel 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
see less

2. Excel is a:

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".

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

Explanation

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

Submit
4. Which types of charts can excel produce?

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.

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

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.

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

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.

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

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.

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

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.

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

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.

Submit
10. Each excel file is called a workbook because:  

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.

Submit
11. Which orientation is taller than it is wide?

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.

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

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.

Submit
13. What does a hyperlink do?

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."

Submit
14. You can use the formula palette to:

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.

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

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.

Submit
16. How can you remove borders applied in cells?

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.

Submit
17. A workbook contains:

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.

Submit
18. How can you start Edit mode to edit a formula?

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.

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

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.

Submit
20. How would the cell reference $F$4 be described?

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.

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

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.

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

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.

Submit
23. Formatting a cell in Currency, you can specify

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.

Submit
24. What does Excel do if a function is volatile?

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.

Submit
25. Three types of data visualation are:

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.

Submit
26. Which function enters the current date?

Explanation

The function TODAY() enters the current date.

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

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.

Submit
28. Which logical function shows the opposite of the condition?

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.

Submit
29. What does the VLOOKUP function do?  

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.

Submit
30. What is the term used to describe a function inside a function?

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.

Submit
31. The autofill feature:

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.

Submit
32. Formatting a cell in Number format you can't set:  

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.

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

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.

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

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.

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

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.

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

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.

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

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.

Submit
38. 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?

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.

Submit
39. To apply conditional formatting, you do the following except:

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.

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

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.

Submit
View My Results

Quiz Review Timeline (Updated): Feb 13, 2024 +

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
Cancel
  • All
    All (40)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
How are data organized in a spreadsheet?  
Excel is a:
What type of operation is being performed in the formula =A4*B5?
Which types of charts can excel produce?
What is an expression that tells how the numbers in a determined set...
A user wishes to remove a spreadsheet from a workbook. Which is the...
What function would display the highest sales amount in a column?
The feature that enables you to automatically complete a list of 12...
What command combines several cells into one cell occupying the same...
Each excel file is called a workbook because:  
Which orientation is taller than it is wide?
Name the function that adds cell values only if they meet your...
What does a hyperlink do?
You can use the formula palette to:
What term describes a model workbook used as the basis for other...
How can you remove borders applied in cells?
A workbook contains:
How can you start Edit mode to edit a formula?
The fill handle doesn't always copy information from one cell...
How would the cell reference $F$4 be described?
When you open an Excel workbook, there are__________ sheets by...
What is the keyboard shortcut command to move the mouse pointer to...
Formatting a cell in Currency, you can specify
What does Excel do if a function is volatile?
Three types of data visualation are:
Which function enters the current date?
Which of the cell pointer indicates that you can move the content to...
Which logical function shows the opposite of the condition?
What does the VLOOKUP function do?  
What is the term used to describe a function inside a function?
The autofill feature:
Formatting a cell in Number format you can't set:  
How would Excel display this value =ROUND(1.567) in the cell?
Which of the following is not an option in the spelling dialog?
Where can you set the shedding color for a range of cells in Excel?...
Which function will you use to enter the current time in a worksheet...
What is the default alignment for values and dates in a cell?
Which financial function would help you determine how much money will...
To apply conditional formatting, you do the following except:
You can automatically adjust the size of the text in a cell if they do...
Alert!

Advertisement