Microsoft Excel 2007 Quiz: Exam!
-
When you copy a range of cells, you must press the _____ key while you drag the selection to its new location.
About This 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. Another significant difference is that Excel 2007 provides more columns and rows if you want to learn more and complete this quiz.
Quiz Preview
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 12.
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.Rate this question:
- 13.
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.Rate this question:
- 14.
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.Rate this question:
- 15.
Pressing Ctrl + ' switches to the _________ view.
Explanation
Pressing Ctrl + ' switches to the formula view.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 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.Rate this question:
- 29.
The ____________ displays the cell reference of the active cell.
Explanation
The "formula bar" displays the cell reference of the active cell.Rate this question:
- 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.Rate this question:
- 31.
One challenge of nesting functions is to make sure that you include all of the parentheses.
-
True
-
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 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.
-
True
-
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 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.
-
True
-
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 34.
A conditional format can make negative numbers red and positive numbers black.
-
True
-
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 35.
Formatting changes only the appearance of data- it does not affect the data itself.
-
True
-
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 36.
The ____ button is equivalent to using the sum button.
-
COUNT
-
ADD
-
AutoSum
-
AddSum
Correct Answer
A. AutoSumExplanation
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.Rate this question:
-
- 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.
-
True
-
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 38.
A(n) ________ function is conditional.
Correct Answer
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.Rate this question:
- 39.
You can create at most one Excel table in a worksheet.
-
True
-
False
Correct Answer
A. FalseExplanation
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.Rate this question:
-
- 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:
-
Reenter all the numbers
-
Decrease the column width
-
Decrease the font size
-
Use the Number group to decrease the number of digits displayed
Correct Answer
A. Use the Number group to decrease the number of digits displayedExplanation
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.Rate this question:
-
- 41.
You can rotate cell contents in Excel so that they appear at any angle or orientation.
-
True
-
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 42.
In excel, charts do not remain linked or connected to their data sources if they appear in different worksheets.
-
True
-
False
Correct Answer
A. FalseExplanation
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.Rate this question:
-
- 43.
A "mixed reference" locks one part of the cell reference while the other part can change.
-
True
-
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 44.
The Paste Options button allows you to________.
-
Keep source formatting
-
Copy formatting only
-
Copy values only
-
All of the above
Correct Answer
A. All of the aboveExplanation
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.Rate this question:
-
- 45.
After Excel displays an existing entry in the column that matches the characters you type, press the ______ key to accept the entry.
-
Shift
-
Tab
-
Esc
-
Alt
Correct Answer
A. TabExplanation
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.Rate this question:
-
- 46.
In pie charts with legends, it's best to make the slice colors as similar as possible.
-
True
-
False
Correct Answer
A. FalseExplanation
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.Rate this question:
-
- 47.
The simplest and most convenient way to add a record to a table is to enter the data in the first blank row.
-
True
-
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 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.
-
True
-
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 49.
After you merge a range into a single cell, you can't realign its content.
-
True
-
False
Correct Answer
A. FalseExplanation
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.Rate this question:
-
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, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 04, 2009Quiz Created by
Karismalicious