Microsoft Excel 2007 Analysis Trivia Quiz
Excel 2007 Analysis
Questions and Answers
- 1.
The Insert Function dialog box tells you how to use functions.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
It gives you a list of the functions and all of their categories.Rate this question:
-
- 2.
The function arguments dialog box tells you how to use functions.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The function arguments dialog box provides information on how to use functions. It likely includes details such as the number and types of arguments the function expects, as well as any additional parameters or options that can be used. This dialog box is a helpful tool for understanding and correctly using functions in a program or software. Therefore, the statement is true.Rate this question:
-
- 3.
The ____________________ criteria filter requires that the records displaying begin with the specified text string.
Correct Answer
begins withExplanation
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 the specified text string at the beginning will be shown, while any records that have the text string in the middle or at the end will be excluded.Rate this question:
- 4.
In PivotTable terminology, the fields that you summarize are known as ______________ fields.
Correct Answer
valueExplanation
In PivotTable terminology, the fields that you summarize are known as "value" fields. This term refers to the specific data that is being summarized or aggregated in the PivotTable. The value field is the one that provides the numerical or quantitative information that is used to calculate totals, averages, or other summary statistics in the PivotTable.Rate this question:
- 5.
A(n) _______________ is a range of values that spans the vertical axis in a column chart.
Correct Answer
scaleExplanation
In a column chart, a scale is a range of values that spans the vertical axis. It helps to represent the data accurately and proportionally by dividing the vertical axis into equal intervals. The scale allows viewers to interpret the height of each column and compare the values effectively. Without a scale, the chart would lack context and make it difficult to understand the data being presented.Rate this question:
- 6.
If you want to use your PivotTable to combine items into groups, which of the following would not be true?
- A.
Items that appear as row labels cannot be grouped
- B.
Items that appear as column labels can be grouped
- C.
If items are dates, they can be grouped automatically using the Grouping dialog box
- D.
If items are numbers, they can be grouped manually using the Ctrl key to select items in a group and then choosing Group from the shortcut menu
Correct Answer
A. Items that appear as row labels cannot be groupedExplanation
In a PivotTable, items that appear as row labels can be grouped. Grouping allows you to combine similar items into categories or ranges. Therefore, the statement "Items that appear as row labels cannot be grouped" is not true.Rate this question:
-
- 7.
A field name is also called a(n) _____________
Correct Answer
column headerExplanation
A field name is also called a column header because it is the title or label given to a column in a table or spreadsheet. It identifies the type of data that is stored in that particular column and helps users understand the information presented in the table. The column header serves as a reference point for organizing and analyzing data, allowing users to easily navigate and manipulate the information within the table.Rate this question:
- 8.
The process of hiding certain records and viewing the ones you want is called ____________ your data.
Correct Answer
filteringExplanation
Filtering refers to the process of selectively hiding certain records and displaying only the desired ones in a dataset. It allows users to narrow down the information they are viewing by applying specific criteria or conditions to the data. By filtering data, users can easily focus on relevant information and remove any unnecessary or unwanted records, making it easier to analyze and work with the dataset.Rate this question:
- 9.
After Excel displays an existing entry in the column that matches the characters you type, press the ______ key to accept the entry
- A.
Shift
- B.
Tab
- C.
Esc
- D.
Alt
Correct Answer
B. TabExplanation
When Excel displays an existing entry in the column that matches the characters you type, pressing the Tab key will accept the entry. The Tab key is commonly used to move between cells in Excel, and in this case, it is used to confirm and accept the displayed entry as the desired input.Rate this question:
-
- 10.
You use ______ filters to find all objects with a value greater than X or acquired after a certain date
- A.
Custom
- B.
Criteria
- C.
Index
- D.
Pivot
Correct Answer
B. CriteriaExplanation
To find all objects with a value greater than X or acquired after a certain date, you would use "criteria" filters. These filters allow you to set specific conditions or requirements for your search, such as filtering objects based on their values or acquisition dates. By applying criteria filters, you can narrow down your search results to only include objects that meet the specified conditions.Rate this question:
-
- 11.
With the Last Quarter criteria filter, quarters are defined as, for example_________.
- A.
April, May, June
- B.
March, April, May
- C.
May, June, July
- D.
March, April, May, June, July
Correct Answer
A. April, May, JuneExplanation
The Last Quarter criteria filter defines quarters as April, May, and June.Rate this question:
-
- 12.
When you designate a range as a(n) ______, Excel provides the same operations as are available for a structured range of data
- A.
Table
- B.
Catalogue
- C.
Index
- D.
Roster
Correct Answer
A. TableExplanation
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 filter, sort, and analyze the data within the table. Additionally, tables in Excel have built-in features such as automatic row expansion, column headers, and the ability to easily create formulas that reference the table data. Overall, using a table in Excel helps to organize and manage data effectively.Rate this question:
-
- 13.
You can create at most one Excel table in a worksheet
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
In Excel, you can create multiple tables in a single worksheet. Tables are a powerful feature that allows you to organize and analyze data more efficiently. By converting a range of data into a table, you gain access to various table-specific functionalities, such as sorting, filtering, and using structured references. This can be particularly useful when working with large datasets or when you need to perform complex calculations or analysis on your data. Therefore, the statement that you can create only one Excel table in a worksheet is false.Rate this question:
-
- 14.
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.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement is true because adding a record to a table by entering the data in the first blank row below the last record is indeed the simplest and most convenient way. This ensures that the new record is placed in the correct order and maintains the integrity of the table structure. By doing so, it is easy to keep track of the records and maintain the organization of the table.Rate this question:
-
- 15.
When you clear a filter, all filters in the worksheet are cleared
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
When you clear a filter, only the specific filter that you cleared is cleared. The other filters in the worksheet remain unaffected and will still be applied to the data. Therefore, the given statement is false.Rate this question:
-
- 16.
You can use a table's sizing handle to add columns or rows to a table
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A table's sizing handle can be used to add columns or rows to a table. This feature allows users to easily modify the structure of a table by simply dragging the sizing handle to increase the number of rows or columns. By using this functionality, users can quickly adjust the size and layout of a table to accommodate their specific needs.Rate this question:
-
- 17.
A(n)_____________________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.
Correct Answer
planning and analysis sheetExplanation
A planning and analysis sheet is a tool that consists of a series of questions aimed at assisting individuals in considering the purpose of a workbook and determining the steps needed to achieve their desired outcomes. This sheet helps users think critically about their goals and provides a structured framework for effective planning and analysis.Rate this question:
- 18.
When you are in _________ mode, some keyboard shortcuts will work differently.
Correct Answer
editingExplanation
When you are in editing mode, some keyboard shortcuts will work differently. This means that the functionality of certain keyboard shortcuts will be altered or modified when you are actively editing a document or file. It implies that the keyboard shortcuts that are typically used in other modes or situations may not have the same effect or perform the same actions when you are in editing mode.Rate this question:
- 19.
A chart that combines two or more chart types into a single graph is called a(n) _____________ chart.
Correct Answer
combinationExplanation
A chart that combines two or more chart types into a single graph is called a combination chart. This type of chart is useful when you want to display different types of data or variables together in one visual representation. By combining different chart types, such as line charts, bar charts, or pie charts, you can effectively present complex data sets and highlight relationships or patterns between different variables. The combination chart allows for a comprehensive and visually appealing way to present multiple types of information simultaneously.Rate this question:
- 20.
To sort data in an Excel worksheet you can use the ______.
- A.
Sort A to Z and Sort Z to A buttons
- B.
QuickSort Options
- C.
Sort command on the Formulas tab
- D.
Any of the above
Correct Answer
D. Any of the aboveExplanation
The correct answer is "Any of the above". This is because all three options mentioned - the Sort A to Z and Sort Z to A buttons, QuickSort Options, and the 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 in either ascending or descending order.Rate this question:
-
- 21.
Item ______ in the figure indicates the fields you want to summarize.
- A.
1
- B.
2
- C.
3
- D.
4
Correct Answer
D. 4Explanation
In the given figure, the number 4 indicates the fields that you want to summarize.Rate this question:
-
- 22.
60%-Accent is an example of a cell _____.
- A.
Size
- B.
Style
- C.
Border color
- D.
Height
Correct Answer
B. StyleExplanation
The given answer "style" is correct because accent is a characteristic or attribute of a cell that affects its appearance or formatting. Style refers to the visual design or layout of a cell, including aspects such as font, color, alignment, and other formatting options. Therefore, accent can be considered as a style element that enhances the visual appeal or emphasis of a cell.Rate this question:
-
- 23.
Removing the contents of a cell is known as ____ a cell.
- A.
Clearing
- B.
Emptying
- C.
Editing
- D.
Deleting
Correct Answer
A. ClearingExplanation
When we remove the contents of a cell, we are essentially clearing it. Clearing a cell means that we are erasing or deleting the data that was previously entered in that cell. This action leaves the cell empty and ready to be filled with new data. Therefore, the correct answer is "clearing".Rate this question:
-
- 24.
The amount of money being loaned is known as the _____.
- A.
Mortgage
- B.
Principal
- C.
Loan amount
- D.
Proposed principal
Correct Answer
B. PrincipalExplanation
The correct answer is "principal". In the context of a loan, 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 over time, along with any interest or fees. The principal amount does not include any additional charges or interest that may be added to the loan.Rate this question:
-
- 25.
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.
- A.
True
- B.
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 user to arrange the data in ascending (A to Z) or descending (Z to A) order based on the selected field. This simplifies the sorting process and saves time compared to manually rearranging the data. Therefore, the given answer "True" is correct.Rate this question:
-
- 26.
None of the data shown is _________.
- A.
Aligned
- B.
Truncated
- C.
Formatted
- D.
Formulated
Correct Answer
B. TruncatedExplanation
The given answer is "truncated" because the question states that none of the data shown is _________. "Truncated" means that the data has been cut off or shortened, so if none of the data is truncated, it means that all of the data is complete and not cut off. The other options - aligned, formatted, and formulated - do not make sense in the context of data being cut off or shortened.Rate this question:
-
- 27.
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 blank row. This ensures that the data is added in a sequential and organized manner, making it easier to retrieve and analyze the information later on. Additionally, entering the data in the first blank row helps to maintain the integrity and consistency of the table structure.Rate this question:
-
- 28.
When using a data bar, changing the value of one cell in the range will not affect the size of all the other cells.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
When using a data bar, changing the value of one cell in the range will affect the size of all the other cells. This is because data bars are conditional formatting features that visually represent the values in a range of cells by varying the length of the bars. When the value in one cell changes, the length of the data bar for that cell will adjust accordingly, impacting the size of the other cells in the range. Therefore, the correct answer is False.Rate this question:
-
- 29.
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 a 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 font style, color, and borders. This is a useful feature as it ensures consistency and makes the table visually appealing. Therefore, the statement "True" is correct.Rate this question:
-
- 30.
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
- 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 cells. Then, click the Paste button arrow in the Clipboard group, which opens a drop-down menu. In this menu, the fourth step is to click Paste Special, which opens a dialog box. In the dialog box, the third step is to specify exactly what you want to paste, such as values, formulas, or formats. Finally, the fifth step is to select the range where you want to paste the contents of the clipboard. Therefore, the correct order of the steps is 1, 5, 2, 3, 4.Rate this question:
-
- 31.
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 multiple actions, including keeping the source formatting, copying formatting only, and copying values only. This means that you can choose to paste the content with its original formatting, paste only the formatting without the content, or paste only the values without any formatting. Therefore, the correct answer is "all of the above" as it encompasses all the possible actions that can be performed using the Paste Options button.Rate this question:
-
- 32.
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 in which individuals have difficulty distinguishing certain colors, particularly red and green. Therefore, when creating an Excel document, it is important to avoid using red and green together as text and background colors. This is because individuals with color blindness may not be able to differentiate between the two colors, leading to confusion and difficulty in reading the document.Rate this question:
-
- 33.
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, centering column titles helps to visually distinguish them from the rest of the content and make them stand out. Left aligning the text in the columns ensures that the content is easy to read and scan, as it follows the natural reading pattern. Right aligning the numbers in the columns helps to align them vertically and make it easier to compare and perform calculations.Rate this question:
-
- 34.
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 the Format Painter. This tool allows you to copy the formatting from one cell and apply it to multiple cells with just a few clicks. Additionally, applying a table style can also be an efficient way to format cells as it applies a predefined set of formatting options to the selected range of cells.Rate this question:
-
- 35.
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
The correct answer is to click Wrap text. This option allows the text in the cells to wrap within the cell boundaries, ensuring that all content is visible without truncation. By selecting this option, the text will be displayed on multiple lines within the cell, making it fully readable without losing any data.Rate this question:
-
- 36.
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, you would need to type the data in cell A1 and then merge cells A1 to E1. This will combine the cells into one larger cell, allowing the title to span across all five columns. By merging the cells, the title will be centered horizontally within the merged cell, creating a visually appealing and organized layout for the data.Rate this question:
-
- 37.
The ____________ displays the cell reference of the active cell.
Correct Answer
name boxExplanation
The name box in Excel displays the cell reference of the active cell. This allows users to easily identify and keep track of the specific cell they are working on. By showing the cell reference, it helps users navigate and locate cells within the spreadsheet.Rate this question:
- 38.
I the background color for a workbook is green, what color should you not use for any of the font or highlight colors?
- A.
Red
- B.
White
- C.
Black
- D.
Any color is fine
Correct Answer
A. RedExplanation
If the background color for a workbook is green, using the color red for any of the font or highlight colors would create poor visibility and contrast. Red and green are complementary colors, meaning they are opposite each other on the color wheel. When used together, they can create visual discomfort and make it difficult to read or distinguish the text. Therefore, it is advisable not to use red as a font or highlight color in this scenario.Rate this question:
-
- 39.
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
By using the Number group to decrease the number of digits displayed, you can control the precision of the numbers in the cell. This means that you can choose to display only a certain number of decimal places or round the numbers to a specific precision. This will help in making the data appear cleaner and reduce the distraction caused by too many numbers after the decimal place.Rate this question:
-
- 40.
The _____________ button quickly inserts Excel functions.
Correct Answer
AutoSum
auto sumExplanation
The AutoSum button is used to quickly insert Excel functions. It automatically selects the range of cells that it believes you want to sum, making it easier and faster to perform calculations. The button is named "AutoSum" and can also be accessed by typing "auto sum" in the function bar.Rate this question:
- 41.
The _________________ displays the name of the sheets in the workbook.
Correct Answer
sheet tabsExplanation
The sheet tabs in a workbook display the names 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, the user can quickly access and view the contents of that particular sheet.Rate this question:
- 42.
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 is a useful tool for scenario planning and decision-making, as it enables users to explore different possibilities and evaluate the potential outcomes. By performing what-if analysis, users can gain insights into how changes in variables can affect the overall results and make informed decisions based on the data.Rate this question:
- 43.
Pressing Ctrl + ' switches to the _________ view.
Correct Answer
formulaExplanation
Pressing Ctrl + ' switches to the formula view.Rate this question:
- 44.
A _______________ is an excel document.
Correct Answer
workbookExplanation
A workbook is a term used to describe an excel document. It refers to a file that contains multiple worksheets or spreadsheets where data can be organized and manipulated. Workbooks are used to store and analyze data, perform calculations, and create charts and graphs. They provide a structured and organized way to manage and present information in a tabular format.Rate this question:
- 45.
___________ view shows the contents of a worksheet.
Correct Answer
NormalExplanation
The Normal view in Excel shows the contents of a worksheet without any additional formatting or layout changes. It displays the worksheet in a standard format, allowing users to view and edit the data easily. This view is commonly used for everyday tasks such as data entry, editing, and reviewing the contents of the worksheet.Rate this question:
- 46.
A group of worksheet cells is called a _________.
Correct Answer
rangeExplanation
A group of worksheet cells is called a range. A range is a collection of cells that are adjacent to each other or selected together. It can include a single cell or multiple cells, and is often used to perform calculations or apply formatting to a specific set of cells in a worksheet.Rate this question:
- 47.
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 you copy a range of cells, you must press the Ctrl or control key while you drag the selection to its new location. This key combination allows you to duplicate the selected cells and place them in a different location without removing the original data. By holding down the Ctrl or control key, you can easily copy and paste the selected cells to another part of the spreadsheet.Rate this question:
- 48.
A named operation that returns a value is a ______.
Correct Answer
functionExplanation
A named operation that returns a value is called a function. Functions are blocks of code that can be executed by calling their name and can perform specific tasks or calculations. They can take input parameters and produce output values, making them useful for organizing and reusing code. By using functions, programmers can break down complex tasks into smaller, more manageable parts, improving the efficiency and readability of their code.Rate this question:
- 49.
What is a workbook made up of?
Correct Answer
Worksheet
worksheetsExplanation
A workbook is made up of one or more worksheets. Worksheets are individual pages within a workbook that contain data, formulas, and other elements. They allow users to organize and manipulate data in a structured manner. By including multiple worksheets in a workbook, users can create a comprehensive collection of related data and analysis.Rate this question:
- 50.
Multiplication before addition is an example of ____________________
Correct Answer
order of operations
order of operationExplanation
Multiplication before addition is an example of the order of operations. The order of operations is a set of rules that dictate the sequence in which mathematical operations should be performed in an expression. According to this rule, multiplication should be performed before addition. This ensures that the mathematical expression is evaluated correctly and consistently.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 22, 2023Quiz Edited by
ProProfs Editorial Team -
May 02, 2012Quiz Created by
Cburke14
Back to top