Microsoft Excel 2007 Quiz: Exam!

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 Karismalicious
K
Karismalicious
Community Contributor
Quizzes Created: 2 | Total Attempts: 3,014
| Attempts: 2,489 | Questions: 76
Please wait...
Question 1 / 76
0 %
0/100
Score 0/100
1. When you copy a range of cells, you must press the _____ key while you drag the selection to its new location.

Explanation

When copying a range of cells, you must press the Ctrl or control key while dragging the selection to its new location. This key is used to initiate the copy action and allows you to duplicate the selected cells in the desired location. By holding down the Ctrl or control key, you can easily copy and paste the cells without having to manually enter the data again.

Submit
Please wait...
About This Quiz
Microsoft Excel 2007 Quiz: Exam! - Quiz

Are you familiar with Microsoft Excel 2007? Would you like to attempt to answer these questions? One of the significant improvements in Microsoft Excel 2007 is the level of resting that can be achieved. Comparatively speaking, Excel 2003 only allowed seven resting functions, while Excel 2007 permits up to 64.... see moreAnother significant difference is that Excel 2007 provides more columns and rows if you want to learn more and complete this quiz.
see less

Personalize your quiz and earn a certificate with your name on it!
2. Pie charts are most effective with ___________ or fewer slices.

Explanation

Pie charts are most effective when they have fewer slices because having too many slices can make the chart cluttered and difficult to read. With six or fewer slices, the chart is more visually appealing and easier for the audience to interpret the data accurately.

Submit
3. A named operation that returns a value is a ______.

Explanation

A named operation that returns a value is referred to as a function. Functions are blocks of code that can be called and executed to perform a specific task. They can accept input parameters and produce an output result. By giving a name to an operation and defining its functionality, it can be easily reused and called multiple times throughout a program. The fact that it returns a value distinguishes it from other types of operations that may not produce any output.

Submit
4. A _______________ is an excel document.

Explanation

A workbook is a type of excel document that contains multiple spreadsheets or worksheets. It is used to organize and store data, calculations, and other information in a structured manner. Workbooks are commonly used in business and academic settings for tasks such as budgeting, financial analysis, data tracking, and reporting. They allow users to input, manipulate, and analyze data using various functions and formulas. Workbooks can also be customized with formatting options, charts, and graphs to present data in a visually appealing way.

Submit
5. The process of hiding certain records and viewing the ones you want is called ____________ your data.

Explanation

Filtering is the process of hiding certain records and viewing the ones you want. It allows you to refine your data by selecting specific criteria or conditions to display only the relevant information. By applying filters, you can focus on specific subsets of data, making it easier to analyze and interpret the information effectively. Filtering is commonly used in various applications, such as spreadsheets, databases, and data visualization tools, to extract meaningful insights from large datasets.

Submit
6. What displays values in different categories; column chart on its side.

Explanation

A bar chart is a visual representation that displays values in different categories using rectangular bars. The bars are typically arranged horizontally or vertically, with the length or height of each bar representing the value it represents. In this case, the question mentions that the chart is on its side, indicating that the bars are arranged vertically. Therefore, a bar chart is the correct answer as it fits the description provided.

Submit
7. A group of worksheet cells is called a _________.

Explanation

A group of worksheet cells is called a range. In Excel, a range refers to a collection of cells that are adjacent to each other, either horizontally or vertically. Ranges are commonly used for performing calculations, applying formatting, or referencing data within a specific area of a worksheet. By selecting a range, you can easily manipulate or analyze the data contained within those cells.

Submit
8. ___________ view shows the contents of a worksheet.

Explanation

The Normal view is a view in Microsoft Excel that displays the contents of a worksheet in a standard layout. It shows the cells, rows, and columns in a clear and organized manner, allowing users to easily read and edit the data. This view does not include any additional formatting or special features, making it the default and most commonly used view for working with worksheets in Excel.

Submit
9. A chart that combines two or more chart types into a single graph is called a(n) _____________ chart.

Explanation

A chart that combines two or more chart types into a single graph is called a combination chart. This type of chart allows for the visualization of multiple data sets using different chart types within the same graph. It is useful when comparing and contrasting different data sets or when presenting complex data in a clear and concise manner.

Submit
10. Multiplication before addition is an example of ____________________

Explanation

The statement "Multiplication before addition is an example of order of operations" is correct. The order of operations refers to the rules that dictate the sequence in which mathematical operations should be performed in an expression. According to these rules, multiplication should be performed before addition. This ensures that the expression is evaluated correctly and consistently.

Submit
11. The _____________ button quickly inserts Excel functions.

Explanation

The AutoSum button in Excel quickly inserts functions by automatically selecting the range of cells that need to be summed. This saves time and effort for the user, as they don't have to manually select the range and type out the function. The AutoSum button is a convenient feature that simplifies the process of adding up values in Excel.

Submit
12. This compares value from different categories; often used to show trends and changes over time.

Explanation

A line chart is a type of graph that compares values from different categories, typically used to display trends and changes over time. It is effective in visually representing data points and their progression over a continuous period. By plotting data points on a line, it becomes easier to identify patterns, fluctuations, and overall trends in the data. This makes it a useful tool for analyzing and interpreting data sets that involve multiple categories or variables.

Submit
13. What uses vertical rectangles to compare values across categories.

Explanation

A clustered columns chart, also known as a clustered column chart or a column chart, uses vertical rectangles to compare values across categories. This type of chart is commonly used to display and compare data in different categories or groups. Each vertical rectangle represents a category, and the height of the rectangle represents the value of that category. By comparing the heights of the rectangles, it becomes easy to understand and analyze the data across the categories.

Submit
14. What is a workbook made up of?

Explanation

A workbook is made up of multiple worksheets. Worksheets are individual pages within a workbook that allow users to organize and analyze data. Each worksheet can contain cells, rows, and columns where data can be entered and manipulated. Workbooks are commonly used in spreadsheet applications like Microsoft Excel to store and manage data in a structured manner.

Submit
15. Pressing Ctrl + ' switches to the _________ view.

Explanation

Pressing Ctrl + ' switches to the formula view.

Submit
16. When you are in _________ mode, some keyboard shortcuts will work differently.

Explanation

When you are in editing mode, some keyboard shortcuts will work differently. This suggests that there are different modes in which the keyboard shortcuts function differently. The answer "editing" implies that when the user is in the editing mode, certain keyboard shortcuts will have altered functions compared to other modes.

Submit
17. A field name is also called a(n)  _____________

Explanation

A field name is also called a column header because it represents the name or label given to a specific column in a table or database. The column header provides a clear and concise description of the data contained within that column, making it easier for users to understand and interpret the information displayed. It is commonly used in spreadsheet applications, databases, and other data management systems to organize and categorize data effectively.

Submit
18. In "SUM(number1 [,number2 ,number3 ...])", number 2 and number 3 are ________

Explanation

In the function "SUM(number1 [,number2 ,number3 ...])", the numbers number2 and number3 are considered optional. This means that they are not required for the function to work properly. The function can still perform the sum operation even if these numbers are not provided as arguments.

Submit
19. The ____________________ criteria filter requires that the records displaying begin with the specified text string.

Explanation

The "begins with" criteria filter is used to display records that start with a specific text string. This means that only the records that have their data starting with the specified text string will be shown.

Submit
20. In PivotTable terminology, the fields that you summarize are known as ______________ fields.

Explanation

In PivotTable terminology, the fields that you summarize are known as "value" fields. This is because these fields contain the numerical data that you want to analyze and summarize in the PivotTable. By selecting these fields, you can perform calculations such as sum, average, count, etc. on the data. The "value" fields play a crucial role in providing insights and understanding patterns in the data when creating a PivotTable.

Submit
21. This compares relative values of different categories to the whole; similar to the pie chart except that it can display multiple sets of data.

Explanation

A doughnut chart is a type of chart that compares the relative values of different categories to the whole. It is similar to a pie chart but can display multiple sets of data. In a doughnut chart, each category is represented by a segment of the doughnut, and the size of each segment corresponds to the proportion of that category compared to the total. This type of chart is useful for visualizing the distribution of data across different categories and comparing their relative sizes.

Submit
22. What is a range of values that is plotted as a single unit on the chart.

Explanation

A range of values that is plotted as a single unit on the chart is referred to as a data series. In a chart, data series are used to represent a set of related data points that are displayed together. It helps in visually representing the relationship or pattern between different data points within the series. By grouping data points into series, it becomes easier to compare and analyze the data in a chart.

Submit
23. 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.

Explanation

What-if analysis, also known as what if analysis, is a feature in Excel that allows users to change one or more values in a spreadsheet and observe the impact of those changes on the calculated values. It helps in exploring different scenarios and making informed decisions based on the results. With what-if analysis, users can easily analyze the consequences of various changes without manually recalculating the entire spreadsheet.

Submit
24. A(n) _______________ is a range of values that spans the vertical axis in a column chart.

Explanation

In a column chart, a scale is a range of values that spans the vertical axis. The scale helps to represent the data accurately and allows for easy interpretation of the chart. It provides a reference point for the data points plotted on the chart and helps to visually depict the magnitude of each value. Without a scale, the chart would lack context and it would be challenging to understand the relative values of the data being presented.

Submit
25. This is a collection of one or more data series.

Explanation

The correct answer is "data source" because a data source refers to a collection of one or more data series. A data source is where data is stored or obtained from, and it can include multiple data series that are related or connected in some way. Therefore, the given statement aligns with the definition of a data source.

Submit
26. This compares three sets of values in a 3D chart.

Explanation

A surface chart is a type of chart that displays three sets of values on a three-dimensional plane. It is used to visualize data that has two independent variables and one dependent variable. The chart consists of a series of data points connected by lines or shaded areas, creating a surface-like appearance. This type of chart is particularly useful for representing complex data relationships and patterns, as it allows for the visualization of data in three dimensions.

Submit
27. This compares a collection of values from several different data sets.

Explanation

A radar chart is a graphical representation that compares a collection of values from several different data sets. It is used to display multiple variables and their magnitudes in relation to a central point. Each variable is represented by a spoke-like line extending from the center, and the length of each line corresponds to the magnitude of the variable. By comparing these lines, it becomes easy to identify patterns and trends across the different data sets.

Submit
28. A(n)_____________________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.

Explanation

A planning and analysis sheet is a tool that consists of a series of questions designed to assist individuals in considering the purpose of a workbook and determining the steps required to achieve their desired outcomes. This sheet helps in organizing thoughts, identifying objectives, and strategizing the necessary actions to be taken. It serves as a guide to ensure effective planning and analysis, enabling individuals to make informed decisions and achieve their intended results.

Submit
29. The ____________ displays the cell reference of the active cell.

Explanation

The "formula bar" displays the cell reference of the active cell.

Submit
30. The _________________ displays the name of the sheets in the workbook.

Explanation

The sheet tabs in a workbook display the name of the sheets. These tabs are located at the bottom of the workbook window and allow users to easily navigate between different sheets within the workbook. By clicking on a specific sheet tab, users can quickly access and view the contents of that particular sheet. The sheet tabs provide a convenient way to organize and manage multiple sheets within a workbook.

Submit
31. One challenge of nesting functions is to make sure that you include all of the parentheses.

Explanation

When nesting functions, it is important to include all of the parentheses in order to ensure that the functions are properly executed. This is because parentheses are used to indicate the order in which the functions should be evaluated. If any parentheses are missing, the functions may not be nested correctly and the desired outcome may not be achieved. Therefore, the statement "One challenge of nesting functions is to make sure that you include all of the parentheses" is true.

Submit
32. 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.

Explanation

Using the Sort A to Z or Sort Z to A buttons is indeed an easy way to sort data when there is only one sort field. These buttons allow the data to be sorted in ascending (A to Z) or descending (Z to A) order based on the selected field. This simplifies the sorting process and eliminates the need for manual sorting or complex sorting algorithms. Therefore, the statement is true.

Submit
33. 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.

Explanation

When typing a function name within a formula into a cell, a list of functions that start with the letters you typed does appear. This feature is known as "AutoComplete" and it helps users by suggesting relevant functions, making it easier and quicker to select the desired function.

Submit
34. A conditional format can make negative numbers red and positive numbers black.

Explanation

A conditional format is a formatting rule that is applied to a cell or a range of cells based on certain conditions. In this case, the condition is whether a number is negative or positive. If the number is negative, the conditional format will be applied to make it red, indicating a negative value. If the number is positive, the conditional format will be applied to make it black, indicating a positive value. Therefore, the statement is true.

Submit
35. Formatting changes only the appearance of data- it does not affect the data itself.

Explanation

Formatting refers to the way data is presented or displayed, such as changing font style, size, color, or adding borders, shading, or alignment. It does not alter the actual content or values of the data. Therefore, formatting changes only the visual representation of data without impacting the underlying data itself. Hence, the statement is true.

Submit
36. The ____ button is equivalent to using the sum button.

Explanation

The AutoSum button is equivalent to using the sum button because it automatically selects the range of cells that need to be summed and inserts the SUM formula for you. It saves time and effort by simplifying the process of calculating the sum of a range of cells.

Submit
37. The simplest and most convenient way to add a record to a table is to enter the data in the first blank row below the last record.

Explanation

The statement is true because when adding a record to a table, it is common practice to enter the data in the first blank row below the last record. This ensures that the new record is added in a sequential order and maintains the organization of the table. By entering the data in the first blank row, it becomes easier to locate and manage the records in the table.

Submit
38. You can create at most one Excel table in a worksheet.

Explanation

In Excel, you can create multiple tables in a single worksheet. Tables are a useful feature that allows you to organize and analyze data more efficiently. By creating tables, you can easily sort, filter, and format your data, as well as apply formulas and create charts based on the table data. Therefore, the statement "You can create at most one Excel table in a worksheet" is false.

Submit
39. A(n) ________ function is conditional.

Explanation

A(n) conditional function is a type of function that executes different actions based on a specific condition. It allows the program to make decisions and choose different paths of execution depending on the value of the condition. This type of function is commonly used in programming to control the flow of the program and perform different tasks based on certain criteria.

Submit
40. If there are too many numbers after the decimal place displayed in a cell, creating a distraction from the data, you could make the data appear cleaner by:

Explanation

The Number group in Excel provides various options to format the appearance of numbers in a cell. By using this group, you can decrease the number of digits displayed after the decimal place, which will make the data appear cleaner and remove any distractions caused by excessive decimal places. This can be done without reentering all the numbers, decreasing the column width, or decreasing the font size.

Submit
41. You can rotate cell contents in Excel so that they appear at any angle or orientation.

Explanation

In Excel, it is possible to rotate cell contents so that they appear at any angle or orientation. This feature allows users to customize the appearance of their data and make it more visually appealing. By rotating cell contents, users can present their data in a way that best suits their needs and makes it easier to read and understand.

Submit
42. In excel, charts do not remain linked or connected to their data sources if they appear in different worksheets.

Explanation

Charts in Excel can remain linked or connected to their data sources even if they appear in different worksheets. This allows for dynamic updates of the chart when the data changes. By selecting the chart and going to the "Design" tab, you can access the "Select Data" option to modify the range of data used for the chart. Additionally, you can use the "Move Chart" option to move the chart to a different worksheet while keeping the link to its data source intact. Therefore, the statement that charts do not remain linked or connected to their data sources if they appear in different worksheets is false.

Submit
43. A "mixed reference" locks one part of the cell reference while the other part can change.

Explanation

A mixed reference is a type of cell reference in a spreadsheet that locks either the row or the column while allowing the other part to change. This means that when the formula is copied or filled to other cells, the locked part of the reference remains the same, while the other part adjusts according to the new location. This is helpful when you want to apply a formula to a range of cells but keep a specific row or column constant. Therefore, the statement that a "mixed reference" locks one part of the cell reference while the other part can change is true.

Submit
44. The Paste Options button allows you to________.

Explanation

The Paste Options button allows you to perform various actions when pasting content. It allows you to keep the source formatting, which means that the formatting of the original content will be preserved. It also allows you to copy formatting only, which means that only the formatting of the content will be copied without the actual values. Additionally, it allows you to copy values only, which means that only the values of the content will be copied without any formatting. Therefore, the correct answer is "all of the above" because the Paste Options button provides options for keeping source formatting, copying formatting only, and copying values only.

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

Explanation

When Excel displays an existing entry in the column that matches the characters you type, pressing the Tab key is the correct action to accept the entry. The Tab key allows you to move to the next cell in the column, confirming the entry and allowing you to continue entering data in the subsequent cells.

Submit
46. In pie charts with legends, it's best to make the slice colors as similar as possible.

Explanation

In pie charts with legends, it is not best to make the slice colors as similar as possible. The purpose of a legend in a pie chart is to provide a clear representation of the different categories or data points. By making the slice colors similar, it can become difficult to differentiate between the different sections of the chart, leading to confusion and misinterpretation of the data. It is recommended to use distinct and contrasting colors for each slice in order to enhance the clarity and understanding of the chart.

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

Explanation

The statement is true because when adding a record to a table, it is common practice to enter the data in the first available blank row. This ensures that the data is organized and follows a sequential order. It is also convenient as it allows for easy identification of the newest records.

Submit
48. Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see which slice is larger.

Explanation

The given statement is true because 3D charts, although visually appealing, can sometimes make it challenging to accurately compare the sizes of different slices or values in the chart. The added depth and perspective can create distortions that may mislead the viewer. Therefore, while 3D charts may be aesthetically pleasing, they can potentially obscure the true relationships and make it harder to interpret the data accurately.

Submit
49. After you merge a range into a single cell, you can't realign its content.

Explanation

When you merge a range into a single cell, you can still realign its content. Merging cells is a formatting option that combines multiple cells into a single larger cell. This can be useful for creating headings or labels that span across multiple columns or rows. However, it does not restrict the ability to realign the content within the merged cell. You can still adjust the alignment of the text or other elements within the merged cell as needed. Therefore, the statement "After you merge a range into a single cell, you can't realign its content" is incorrect.

Submit
50. If you have columns that are truncating your content, but you cannot increase the width of the worksheet and be able to print on one page, a solution for making the test visible without loosing data would be to:

Explanation

If you have columns that are truncating your content and you cannot increase the width of the worksheet, clicking "Wrap text" would be a solution to make the text visible without losing data. Wrapping the text allows it to be displayed on multiple lines within a cell, ensuring that all the content is visible. This way, even if the column width is limited, the text will still be readable.

Submit
51. When creating an Excel document, you should avoid using ______ text and background together, since this is the most common form of color blindness.

Explanation

Color blindness is a condition that affects the ability to distinguish certain colors, with the most common form being red-green color blindness. This means that individuals with this condition have difficulty differentiating between red and green. When creating an Excel document, it is important to avoid using red and green together in text and background as it may make it difficult for color-blind individuals to read and understand the content.

Submit
52. As a general rule you should______________

Explanation

As a general rule, column titles are centered to make them stand out and easily distinguishable from the rest of the content. Text in the columns is left aligned to ensure readability and a consistent starting point for each line. Numbers in the columns are right aligned to create a clear and organized appearance, making it easier to compare values.

Submit
53. If you insert a new row at the top of the table, the new row becomes the header row and is formatted with the table style.

Explanation

When a new row is inserted at the top of the table, it becomes the header row and is automatically formatted with the table style. This means that the new row will have the same formatting as the rest of the table, such as the font, color, and borders. This can be useful when adding a new section or category to the table and wanting it to be visually consistent with the rest of the data. Therefore, the correct answer is true.

Submit
54. The function arguments dialog box tells you how to use functions.

Explanation

The function arguments dialog box provides information on how to use functions. It likely includes details such as the number and order of arguments that the function expects, as well as any specific data types or formats that should be used. This information is helpful in ensuring that the function is used correctly and can produce the desired results. Therefore, the statement is true.

Submit
55. When you clear a filter, all filters in the worksheet are cleared.

Explanation

When you clear a filter, only the specific filter that you cleared is removed, not all filters in the worksheet. Therefore, the given statement is false.

Submit
56. To sort data in an Excel worksheet you can use the ______.

Explanation

The given correct answer is "Any of the above". This is because all three options mentioned (Sort A to Z and Sort Z to A buttons, QuickSort Options, Sort command on the Formulas tab) can be used to sort data in an Excel worksheet. Depending on the user's preference or the specific requirements of the data, any of these options can be used to sort the data effectively.

Submit
57. When you designate a range as a(n) ______, Excel provides the same operations as are available for a structured range of data.

Explanation

When you designate a range as a "Table" in Excel, it provides the same operations as are available for a structured range of data. This means that you can easily sort, filter, and analyze the data within the table. Additionally, tables in Excel have built-in features such as automatic formatting, total rows, and the ability to easily expand or shrink the table as needed. Using a table can make it easier to manage and work with data in Excel.

Submit
58. With the Last Quarter criteria filter, quarters are defined as, for example_________.

Explanation

The Last Quarter criteria filter defines quarters as April, May, and June.

Submit
59. If you have data that runs across five columns, from column A to column E, one way to center a title across the top of the data would be to:  

Explanation

To center a title across the top of the data, the correct option is to type the data in A1 and merge cells A1:E1. This will allow the title to be entered in cell A1 and then merged across cells A1 to E1, resulting in the title being centered across the top of the data in all five columns.

Submit
60. Removing the contents of a cell is known as ____ a cell.

Explanation

Clearing a cell refers to the action of removing the contents of a cell, leaving it empty. This can be done to erase any data or formulas that were previously entered in the cell. The term "clearing" implies that the cell is being emptied, but it does not necessarily mean that the cell itself is being deleted or removed from the spreadsheet.

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

Explanation

If A1 is equal to "NO", the formula will return the text "RESTART". This is because the formula uses the IF function to check if the value in cell A1 is equal to "YES". If it is not equal to "YES", the formula will return the value "RESTART". Since A1 is equal to "NO", the condition is not met and the formula returns "RESTART".

Submit
62. The numbers, text, or cell references used by the function to return a value are

Explanation

The correct answer is "arguments". In a function, arguments are the numbers, text, or cell references that are used to calculate and return a value. They are the input values provided to the function, and they determine the result of the function's calculation.

Submit
63. The amount of money being loaned is known as the _____.

Explanation

The correct answer is "principal." In the context of loans, the principal refers to the initial amount of money that is being borrowed. It is the original sum that the borrower receives from the lender and is expected to repay, excluding any interest or fees. The principal amount is an essential factor in determining the total cost of the loan and the repayment terms.

Submit
64. If a formula contains several functions, Excel starts with the outermost function and then moves inward.

Explanation

Excel actually starts with the innermost function and then moves outward when evaluating a formula that contains several functions. This means that the innermost function is calculated first, and then the result is used as an argument for the next outer function, and so on, until the outermost function is calculated. Therefore, the correct answer is False.

Submit
65. 60%-Accent is an example of a cell _____.

Explanation

The correct answer is "style" because an accent is a visual element that enhances the appearance of a cell. Style refers to the formatting options that can be applied to a cell, such as font size, font color, background color, and borders. Therefore, style is the most appropriate option to describe an accent in the context of cell formatting.

Submit
66. To enter a mixed reference, type $ after either the row or column reference.

Explanation

not-available-via-ai

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

Explanation

The statement is false because a 3D chart can be rotated in three directions: horizontally along the x-axis, vertically along the y-axis, and depth-wise along the z-axis. This allows for a complete view of the chart from all angles, providing a better understanding of the data presented.

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

Explanation

The correct answer is "criteria". In this context, criteria filters are used to search for objects that meet specific conditions, such as having a value greater than X or being acquired after a certain date. These filters allow for a more targeted and precise search, helping to narrow down the results and find the desired objects.

Submit
69. Once you hide a row, it remains hidden as long as the workbook is active.

Explanation

You can always choose to un-hide it.

Submit
70. Item ______ in the figure indicates the fields you want to summarize.

Explanation

In the given figure, the item labeled as 4 indicates the fields that you want to summarize.

Submit
71. The Insert Function dialog box tells you how to use functions.

Explanation

It gives you a list of the functions and all of their categories.

Submit
72. None of the data shown is _________.

Explanation

The correct answer is "truncated" because the question states that none of the data shown is truncated. Truncation refers to the process of cutting off or shortening something, usually in the context of data or text. Therefore, if none of the data shown is truncated, it means that all the information is complete and not cut off or shortened in any way.

Submit
73. Excel has a built-in format to display 4 digit year values, so you do not need to create one.

Explanation

Excel does not have a built-in format to display 4 digit year values. Therefore, if you want to display 4 digit year values in Excel, you would need to create a custom format.

Submit
74. If you want to use your PivotTable to combine items into groups, which of the following would not be true?

Explanation

not-available-via-ai

Submit
75. Put the following five steps in the order in which you would perform them to use the Paste Special function:

1. Select and copy a range
2. Click the Paste button arrow in the Clipboard group
3. Specify exactly what you want to paste
4. Click Paste Special to open the dialog box
5. Select the range where you want to pase the Clipboard contents

Explanation

To use the Paste Special function, the first step is to select and copy a range of data. Then, the next step is to select the range where you want to paste the copied data. After that, you need to click the Paste button arrow in the Clipboard group. Following that, you should specify exactly what you want to paste. Finally, you click Paste Special to open the dialog box.

Submit
76. The most efficient way to format several cells with a specific font, number format, alignment, fon color would be to:

Explanation

The most efficient way to format several cells with a specific font, number format, alignment, and font color would be to use Format Painter and apply a table style. Format Painter allows you to copy the formatting of one cell and apply it to multiple cells quickly. Applying a table style can also help to format multiple cells consistently and efficiently.

Submit
View My Results

Quiz Review Timeline (Updated): Mar 21, 2023 +

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

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 04, 2009
    Quiz Created by
    Karismalicious
Cancel
  • All
    All (76)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
When you copy a range of cells, you must press the _____ key while you...
Pie charts are most effective with ___________ or fewer slices.
A named operation that returns a value is a ______.
A _______________ is an excel document.
The process of hiding certain records and viewing the ones you want is...
What displays values in different categories; column chart on its...
A group of worksheet cells is called a _________.
___________ view shows the contents of a worksheet.
A chart that combines two or more chart types into a single graph is...
Multiplication before addition is an example of ____________________
The _____________ button quickly inserts Excel functions.
This compares value from different categories; often used to show...
What uses vertical rectangles to compare values across categories.
What is a workbook made up of?
Pressing Ctrl + ' switches to the _________ view.
When you are in _________ mode, some keyboard shortcuts will work...
A field name is also called a(n)  _____________
In "SUM(number1 [,number2 ,number3 ...])", number 2 and number 3 are...
The ____________________ criteria filter requires that the records...
In PivotTable terminology, the fields that you summarize are known as...
This compares relative values of different categories to the whole;...
What is a range of values that is plotted as a single unit on the...
The  ___________ allows you to use excel to change one or more...
A(n) _______________ is a range of values that spans the vertical axis...
This is a collection of one or more data series.
This compares three sets of values in a 3D chart.
This compares a collection of values from several different data sets.
A(n)_____________________________ includes a series of questions that...
The ____________ displays the cell reference of the active cell.
The _________________ displays the name of the sheets in the workbook.
One challenge of nesting functions is to make sure that you include...
An easy way to sort data when there is only one sort field is to use...
As you begin to type a function name within a formula into a cell, a...
A conditional format can make negative numbers red and positive...
Formatting changes only the appearance of data- it does not affect the...
The ____ button is equivalent to using the sum button.
The simplest and most convenient way to add a record to a table is to...
You can create at most one Excel table in a worksheet.
A(n) ________ function is conditional.
If there are too many numbers after the decimal place displayed in a...
You can rotate cell contents in Excel so that they appear at any angle...
In excel, charts do not remain linked or connected to their data...
A "mixed reference" locks one part of the cell reference...
The Paste Options button allows you to________.
After Excel displays an existing entry in the column that matches the...
In pie charts with legends, it's best to make the slice colors as...
The simplest and most convenient way to add a record to a table is to...
Although 3D Charts are visually attractive, they can obscure the...
After you merge a range into a single cell, you can't realign its...
If you have columns that are truncating your content, but you cannot...
When creating an Excel document, you should avoid using ______ text...
As a general rule you should______________
If you insert a new row at the top of the table, the new row becomes...
The function arguments dialog box tells you how to use functions.
When you clear a filter, all filters in the worksheet are cleared.
To sort data in an Excel worksheet you can use the ______.
When you designate a range as a(n) ______, Excel provides the same...
With the Last Quarter criteria filter, quarters are defined as, for...
If you have data that runs across five columns, from column A to...
Removing the contents of a cell is known as ____ a cell.
In the following formula: =IF(A1="YES","DONE","RESTART"), what happens...
The numbers, text, or cell references used by the function to return a...
The amount of money being loaned is known as the _____.
If a formula contains several functions, Excel starts with the...
60%-Accent is an example of a cell _____.
To enter a mixed reference, type $ after either the row or column...
You can rotate a 3D chart in only two directions: horizontally along...
You use ______ filters to find all objects with a value greater than X...
Once you hide a row, it remains hidden as long as the workbook is...
Item ______ in the figure indicates the fields you want to summarize.
The Insert Function dialog box tells you how to use functions.
None of the data shown is _________.
Excel has a built-in format to display 4 digit year values, so you do...
If you want to use your PivotTable to combine items into groups, which...
Put the following five steps in the order in which you would perform...
The most efficient way to format several cells with a specific font,...
Alert!

Advertisement