Microsoft Excel 2007 Quiz: Exam!
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.
Questions and Answers
- 1.
In pie charts with legends, it's best to make the slice colors as similar as possible.
- A.
True
- B.
False
Correct Answer
B. 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:
-
- 2.
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.
- A.
True
- B.
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:
-
- 3.
You can rotate a 3D chart in only two directions: horizontally along the x-axis and vertically along the y-axis.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 4.
In excel, charts do not remain linked or connected to their data sources if they appear in different worksheets.
- A.
True
- B.
False
Correct Answer
B. 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:
-
- 5.
Excel has a built-in format to display 4 digit year values, so you do not need to create one.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 6.
One challenge of nesting functions is to make sure that you include all of the parentheses.
- A.
True
- B.
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:
-
- 7.
A "mixed reference" locks one part of the cell reference while the other part can change.
- A.
True
- B.
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:
-
- 8.
To enter a mixed reference, type $ after either the row or column reference.
- A.
True
- B.
False
Correct Answer
B. False -
- 9.
If a formula contains several functions, Excel starts with the outermost function and then moves inward.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 10.
As you begin to type a function name within a formula into a cell, a list of functions that begin with the letters you typed appears.
- A.
True
- B.
False
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:
-
- 11.
Pie charts are most effective with ___________ or fewer slices.
Correct Answer
six
6Explanation
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:
- 12.
This is a collection of one or more data series.
Correct Answer
data sourceExplanation
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:
- 13.
This compares three sets of values in a 3D chart.
Correct Answer
surface chartExplanation
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:
- 14.
This compares a collection of values from several different data sets.
Correct Answer
radar chartExplanation
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:
- 15.
This compares relative values of different categories to the whole; similar to the pie chart except that it can display multiple sets of data.
Correct Answer
doughnut chartExplanation
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:
- 16.
This compares value from different categories; often used to show trends and changes over time.
Correct Answer
line chartExplanation
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:
- 17.
What is a range of values that is plotted as a single unit on the chart.
Correct Answer
data seriesExplanation
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:
- 18.
What displays values in different categories; column chart on its side.
Correct Answer
bar chartExplanation
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:
- 19.
What uses vertical rectangles to compare values across categories.
Correct Answer
clustered columns chart
clustered column chart
cluster chart
column chartExplanation
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:
- 20.
In "SUM(number1 [,number2 ,number3 ...])", number 2 and number 3 are ________
Correct Answer
optionalExplanation
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:
- 21.
The numbers, text, or cell references used by the function to return a value are
- A.
Expressions
- B.
Arguments
- C.
Data
- D.
Values
Correct Answer
B. ArgumentsExplanation
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.Rate this question:
-
- 22.
In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1="NO"?
- A.
The formula returns the text "RESTART"
- B.
The formula returns the text "DONE"
- C.
The formula returns the text "NO"
- D.
The formula returns the text "NO, RESTART"
Correct Answer
A. The formula returns the text "RESTART"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".Rate this question:
-
- 23.
The ____ button is equivalent to using the sum button.
- A.
COUNT
- B.
ADD
- C.
AutoSum
- D.
AddSum
Correct Answer
C. 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:
-
- 24.
Formatting changes only the appearance of data- it does not affect the data itself.
- A.
True
- B.
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:
-
- 25.
After you merge a range into a single cell, you can't realign its content.
- A.
True
- B.
False
Correct Answer
B. 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:
-
- 26.
You can rotate cell contents in Excel so that they appear at any angle or orientation.
- A.
True
- B.
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:
-
- 27.
A conditional format can make negative numbers red and positive numbers black.
- A.
True
- B.
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:
-
- 28.
Once you hide a row, it remains hidden as long as the workbook is active.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
You can always choose to un-hide it.Rate this question:
-
- 29.
What is a workbook made up of?
Correct Answer
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:
- 30.
Multiplication before addition is an example of ____________________
Correct Answer
order of operations
order of operationExplanation
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:
- 31.
When you copy a range of cells, you must press the _____ key while you drag the selection to its new location.
Correct Answer
Ctrl
controlExplanation
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.Rate this question:
- 32.
A named operation that returns a value is a ______.
Correct Answer
functionExplanation
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:
- 33.
A group of worksheet cells is called a _________.
Correct Answer
rangeExplanation
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:
- 34.
Pressing Ctrl + ' switches to the _________ view.
Correct Answer
formulaExplanation
Pressing Ctrl + ' switches to the formula view.Rate this question:
- 35.
A _______________ is an excel document.
Correct Answer
workbookExplanation
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:
- 36.
___________ view shows the contents of a worksheet.
Correct Answer
NormalExplanation
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:
- 37.
The _____________ button quickly inserts Excel functions.
Correct Answer
AutoSum
auto sumExplanation
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:
- 38.
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.
Correct Answer
What-if analysis
what if analysisExplanation
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:
- 39.
The _________________ displays the name of the sheets in the workbook.
Correct Answer
sheet tabsExplanation
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:
- 40.
The ____________ displays the cell reference of the active cell.
Correct Answer
Explanation
The "formula bar" displays the cell reference of the active cell.Rate this question:
- 41.
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:
- A.
Reenter all the numbers
- B.
Decrease the column width
- C.
Decrease the font size
- D.
Use the Number group to decrease the number of digits displayed
Correct Answer
D. 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:
-
- 42.
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:
- A.
Type the data in A1 and Merge cells A1:A5
- B.
Type the data in A1 and Merge cells A1:E1
- C.
Type the data in C1
- D.
Choose Center from the Format menu
Correct Answer
B. Type the data in A1 and Merge cells A1:E1Explanation
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.Rate this question:
-
- 43.
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:
- A.
Abbreviate all text
- B.
Reduce the font size to 8 pt
- C.
Click Wrap text
- D.
Delete one column
Correct Answer
C. Click Wrap textExplanation
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.Rate this question:
-
- 44.
The most efficient way to format several cells with a specific font, number format, alignment, fon color would be to:
- A.
Use Format Painter
- B.
Format each element using the Toolbar
- C.
Select all and use the Formatting dialog box
- D.
Apply a table style
Correct Answer(s)
A. Use Format Painter
D. Apply a table styleExplanation
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.Rate this question:
-
- 45.
When creating an Excel document, you should avoid using ______ text and background together, since this is the most common form of color blindness.
- A.
Red and green
- B.
Yellow and blue
- C.
Black and white
- D.
Red and yellow
Correct Answer
A. Red and greenExplanation
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.Rate this question:
-
- 46.
As a general rule you should______________
- A.
Center column titles, left align text, and right align numbers
- B.
Center column titles, right align text, and left align numbers
- C.
Right column titles, left align text, and right align numbers
- D.
Left column titles, left align text, and right align numbers
Correct Answer
A. Center column titles, left align text, and right align numbersExplanation
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.Rate this question:
-
- 47.
The Paste Options button allows you to________.
- A.
Keep source formatting
- B.
Copy formatting only
- C.
Copy values only
- D.
All of the above
Correct Answer
D. 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:
-
- 48.
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 range2. Click the Paste button arrow in the Clipboard group3. Specify exactly what you want to paste4. Click Paste Special to open the dialog box5. Select the range where you want to pase the Clipboard contents
- A.
1, 2, 4, 3, 5
- B.
1, 2, 4, 5, 3
- C.
1, 5, 2, 4, 3
- D.
1, 5, 2, 3, 4
Correct Answer
D. 1, 5, 2, 3, 4Explanation
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.Rate this question:
-
- 49.
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.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 50.
The simplest and most convenient way to add a record to a table is to enter the data in the first blank row.
- A.
True
- B.
False
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:
-
Quiz Review Timeline +
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
Back to top