Microsoft Excel 2007 Quiz: Practice Exam!
Are you familiar with Microsoft Excel 2007, and would you be interested in answering these questions? In the 2007 version, you can learn how to create a simple budget spreadsheet. You can also format and write formulas. Microsoft Excel includes applications such as Word, Excel, PowerPoint, and Outlook. The application download includes the popular components of each of these programs. If you want to learn more about Microsoft Excel 2007, put your knowledge to the test.
- 1.
Reference to the above image of Command Group "Alignment" which of the following tabs consist it:
- A.
View
- B.
Formatting
- C.
Home
Correct Answer
C. HomeExplanation
The correct answer is "Home". Based on the image of the Command Group "Alignment", the Home tab is the tab that consists of this command group. The image does not show any other tabs such as View or Formatting, so they can be ruled out as options. Therefore, the Home tab is the only logical choice for the tab that consists of the Alignment command group.Rate this question:
-
- 2.
You can have results of any database table into Excel Worksheet, and by one click you can refresh the results?
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
This statement is true because Excel has a built-in feature called "External Data" that allows users to import data from a variety of sources, including database tables. Once the data is imported into an Excel worksheet, users can set it to refresh automatically with a single click, ensuring that the results are always up-to-date. This feature is particularly useful for users who need to regularly analyze and report on data from a database without having to manually update the information in Excel.Rate this question:
-
- 3.
What is the maximum number of rows that can be entered on a single Excel 2007 worksheet?
- A.
65536
- B.
Over 1 million
- C.
64000
- D.
256
Correct Answer
B. Over 1 millionExplanation
The correct answer is "Over 1 million" because Excel 2007 supports a maximum of 1,048,576 rows on a single worksheet. This is significantly more than the other options provided, which are 65,536, 64,000, and 256.Rate this question:
-
- 4.
When using a databar, 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 databar, changing the value of one cell in the range will affect the size of all the other cells. This is because databars are conditional formatting tools that visually represent the values in a range of cells. When the value of a cell changes, the databar will adjust its size accordingly to reflect the new value. Therefore, the statement given in the question is incorrect.Rate this question:
-
- 5.
The Insert Function dialog box tells you how to use functions.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The Insert Function dialog box provides information and guidance on how to use functions. It helps users understand the purpose and syntax of different functions and assists in correctly inputting the required arguments. This feature is commonly found in software applications like spreadsheets or programming environments, where functions play a crucial role in performing calculations or manipulating data. By selecting a function from the Insert Function dialog box, users can access detailed explanations and examples, ensuring accurate and efficient use of functions.Rate this question:
-
- 6.
When a worksheet is printed, the grid lines that surround the cells are printable by default.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
When a worksheet is printed, the grid lines that surround the cells are not printable by default.Rate this question:
-
- 7.
When you clear a filter, all filters in the worksheet are cleared, if worksheet contains more than one filters
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
When you clear a filter, only the specific filter that you cleared will be cleared, not all filters in the worksheet. This means that if the worksheet contains more than one filter, the other filters will still remain applied. Therefore, the correct answer is False.Rate this question:
-
- 8.
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 helps users understand the parameters and inputs required for a function, guiding them on how to correctly use the function in their code. This dialog box typically displays the function name, the type and order of arguments, and any additional information or examples that may be helpful. Overall, the function arguments dialog box serves as a valuable tool for developers to ensure they are using functions correctly and efficiently.Rate this question:
-
- 9.
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 easily accessible. By entering the data in the first blank row, it also avoids any potential conflicts or issues with existing data in the table. Therefore, it is the simplest and most convenient method for adding a record to a table.Rate this question:
-
- 10.
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
B. FalseExplanation
If you insert a new row at the top of the table, it does not automatically become the header row and is not formatted with the table style. The header row is typically the first row in a table and is used to label the columns.Rate this question:
-
- 11.
In Excel, charts do not remain linked or connected to the 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 the data sources even if they appear in different worksheets. This means that if the data in the source worksheet is updated, the chart will automatically reflect those changes. Therefore, the correct answer is False.Rate this question:
-
- 12.
After you merge a range into a single cell, you can't realign its content.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
After merging a range into a single cell, you can still realign its content. This means that even after combining multiple cells into one, you can adjust the positioning of the text or data within that merged cell.Rate this question:
-
- 13.
Once you hide a row, it remains hidden as long as the workbook is active.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
When a row is hidden in a workbook, it will remain hidden until it is manually unhidden or until the workbook is closed. Even if the workbook is saved and reopened, the row will still remain hidden. Therefore, the statement "Once you hide a row, it remains hidden as long as the workbook is active" is true.Rate this question:
-
- 14.
All functions have arguments.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
This statement is true because arguments are the values that are passed into a function when it is called. Even if a function does not require any arguments, it still technically has an empty argument list. Therefore, all functions have arguments, even if they are not used or required.Rate this question:
-
- 15.
Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see when slice is larger.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
3D charts can indeed be visually attractive but they can also make it difficult to accurately interpret the data. The use of depth and perspective in 3D charts can distort the sizes of the slices, making it harder to determine which slice is larger or smaller. This can lead to a misunderstanding of the relationships between the values in the chart. Therefore, the statement that 3D charts can obscure the relationship between the values in the chart is true.Rate this question:
-
- 16.
Excel has a builtin format to display 4 digit year values, so you do not need to create on.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Excel does indeed have a built-in format to display 4 digit year values. This means that users do not need to manually create a format for displaying 4 digit year values in Excel. Therefore, the statement is true.Rate this question:
-
- 17.
Formatting data only change the appearance of data, it does not affect the data itself.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Formatting data refers to changing the visual representation of data, such as changing font styles, colors, or adding borders. It does not alter the actual values or content of the data. Therefore, the statement that formatting data only changes the appearance of data and does not affect the data itself is true.Rate this question:
-
- 18.
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. This means that Excel first evaluates the functions that are nested inside other functions before evaluating the outermost function.Rate this question:
-
- 19.
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 quickly arrange the data in ascending (A to Z) or descending (Z to A) order based on the selected field. This eliminates the need for manual sorting or using complex sorting algorithms, making it a convenient option for simple sorting tasks.Rate this question:
-
- 20.
You can create maximum 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. Each table can have its own set of columns, rows, and formatting options. By creating multiple tables, you can easily manage and manipulate different sets of data within the same worksheet. Therefore, the statement "You can create maximum one Excel table in a worksheet" is false.Rate this question:
-
- 21.
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 begin with the letters you typed appears. This feature is called "AutoComplete" and it helps to suggest and complete the function name based on what you have typed so far. It saves time and helps to avoid spelling errors or forgetting the correct function name.Rate this question:
-
- 22.
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
A. TrueExplanation
The statement is true because in a 3D chart, you can rotate it horizontally along the x-axis to view it from different angles and vertically along the y-axis to change the perspective. These two directions of rotation allow for a comprehensive understanding of the data presented in the chart.Rate this question:
-
- 23.
Pressing ENTER moves the selection one cell to the right.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
Pressing ENTER does not move the selection one cell to the right. Instead, it moves the selection one cell down to the next row.Rate this question:
-
- 24.
Ctrl+B key makes the shortcut for making font in selected cell bold.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement is true because pressing the Ctrl+B key combination in a selected cell will indeed make the font bold. This is a commonly used shortcut in many applications, including spreadsheet software like Microsoft Excel.Rate this question:
-
- 25.
What key should be used to edit the content of a cell?
- A.
F1
- B.
F2
- C.
F3
Correct Answer
B. F2Explanation
The key that should be used to edit the content of a cell is F2.Rate this question:
-
- 26.
What function offers you the possibility to view different results depending on the entered condition?
- A.
=If()
- B.
=Sum()
- C.
=SumIf()
Correct Answer
A. =If()Explanation
The IF() function offers the possibility to view different results depending on the entered condition. It allows you to specify a condition and provides two possible outcomes based on whether the condition is true or false. This function is commonly used in spreadsheets to perform logical tests and make decisions based on the results.Rate this question:
-
- 27.
A user wishes to remove a worksheet from a workbook. Which is the correct sequence of events that will do this?
- A.
Go to file - save as - save as type - excel 4.0 worksheet
- B.
Right click on the worksheet tab and select delete
- C.
Right click on the worksheet and select insert - entire column
Correct Answer
B. Right click on the worksheet tab and select deleteExplanation
To remove a worksheet from a workbook, the correct sequence of events is to right-click on the worksheet tab and select delete. This action will delete the selected worksheet from the workbook.Rate this question:
-
- 28.
Which formula can add the all numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
- A.
Count
- B.
Average
- C.
Sum
Correct Answer
C. SumExplanation
The formula "Sum" can be used to add all the numeric values in a range of cells, excluding non-numeric values, and then place the result in a different cell.Rate this question:
-
- 29.
What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
- A.
F3
- B.
F7
- C.
F9
- D.
F11
Correct Answer
D. F11Explanation
Pressing the F11 key on the keyboard creates a chart from the selected cells.Rate this question:
-
- 30.
Using the autosum button will place in the selected cell _____.
- A.
The sum of values in the cell's column
- B.
Nothing until you selects a range of cells
- C.
The sum of the cell's row unless you change the range
- D.
A formula which will add values in the range Excel guesses you want to add
Correct Answer
D. A formula which will add values in the range Excel guesses you want to addExplanation
The correct answer is A formula which will add values in the range Excel guesses you want to add. When using the autosum button, Excel will automatically create a formula in the selected cell that adds up the values in the range it guesses you want to add. This can be a quick and convenient way to calculate the sum of a column or row without manually typing the formula.Rate this question:
-
- 31.
The view that puts a blue line around each page that would be printed is the _____.
- A.
Print Preview
- B.
Normal
- C.
Page Break Preview
- D.
Split View
Correct Answer
C. Page Break PreviewExplanation
The correct answer is "Page Break Preview" because this view allows users to see where page breaks will occur when printing a document. It is represented by a blue line around each page, making it easier for users to adjust the content and layout accordingly.Rate this question:
-
- 32.
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____.
- A.
B1-G10
- B.
B1.G10
- C.
B1;G10
- D.
B1:G10
Correct Answer
D. B1:G10Explanation
The correct answer is B1:G10. This is the correct cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10. The colon (:) is used to indicate a range, and B1 represents the starting cell while G10 represents the ending cell.Rate this question:
-
- 33.
If you press _____, the cell accepts your typing as its contents but the focus stays in the same cell.
- A.
ENTER
- B.
CTRL + ENTER
- C.
TAB
- D.
INSERT
Correct Answer
B. CTRL + ENTERExplanation
If you press CTRL + ENTER, the cell accepts your typing as its contents but the focus stays in the same cell. This means that after typing in the cell, you can press CTRL + ENTER to confirm the input without moving to the next cell. This is useful when you want to quickly input data in multiple cells without having to constantly navigate to the next cell.Rate this question:
-
- 34.
Once data is entered into a cell, can it be edited after saving the file?
- A.
Yes, but it has to be saved as a different file name.
- B.
No, once it is saved it cannot be changed.
- C.
Yes, even after saving the file, double click on the cell where data is to be changed to edit
Correct Answer
C. Yes, even after saving the file, double click on the cell where data is to be changed to editExplanation
After saving the file, the data entered into a cell can still be edited by double-clicking on the cell. This allows the user to make changes to the data without having to save it as a different file name or starting a new file.Rate this question:
-
- 35.
On an Excel spreadsheet the active cell is indicated by
- A.
A dark wide border
- B.
A dotted border
- C.
A blinking border
- D.
None of the above
Correct Answer
D. None of the aboveExplanation
The active cell on an Excel spreadsheet is not indicated by any of the options given. The active cell is typically indicated by a thick border that is not necessarily dark, dotted, or blinking.Rate this question:
-
- 36.
To select several cells or ranges that are not touching each other, you would _____ while selecting
- A.
Hold down the CTRL key
- B.
Hold down the SHIFT key
- C.
Hold down the ALT key
Correct Answer
A. Hold down the CTRL keyExplanation
To select several cells or ranges that are not touching each other, you would hold down the CTRL key while selecting. Holding down the CTRL key allows you to select multiple non-contiguous cells or ranges by clicking on each of them individually. This is a useful feature when you want to select specific cells or ranges from different parts of the spreadsheet without selecting everything in between.Rate this question:
-
- 37.
What is a Workbook?
- A.
A table of data that is organized into rows and columns
- B.
The Excel file that holds your worksheets
- C.
A built-in formula in Excel
Correct Answer
B. The Excel file that holds your worksheetsExplanation
A workbook in Excel refers to the file that contains multiple worksheets. It is the main file where you can organize and store various sheets of data. Each sheet within the workbook can be used to input and manipulate data in rows and columns. Therefore, the correct answer is "The Excel file that holds your worksheets."Rate this question:
-
- 38.
A Function is?
- A.
A symbol that represents a specific action
- B.
A way of arranging data in a particular order
- C.
A built-in formula in Excel
Correct Answer
C. A built-in formula in ExcelExplanation
A function is a built-in formula in Excel that performs a specific calculation or action on data. It is a predefined formula that can be used to perform various tasks such as mathematical calculations, logical operations, text manipulation, and more. Functions in Excel are designed to simplify complex calculations and automate repetitive tasks, making it easier for users to analyze and manipulate data.Rate this question:
-
- 39.
A Range in Microsoft Excel refers to...
- A.
A group of cells
- B.
A calculation that describes the relationship between cells
- C.
A way of arranging data in a particular order
Correct Answer
A. A group of cellsExplanation
A range in Microsoft Excel refers to a group of cells. This means that multiple cells can be selected and manipulated together as a single unit. Ranges are commonly used for performing calculations, applying formatting, or copying and pasting data. By selecting a range of cells, users can easily perform actions on multiple cells simultaneously, saving time and effort.Rate this question:
-
- 40.
Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before?
- A.
Ribbon
- B.
Formula Bar
- C.
Tab
Correct Answer
A. RibbonExplanation
The Ribbon is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before. It is located at the top of the Excel window and consists of different tabs, such as Home, Insert, Page Layout, etc. Each tab contains specific commands and options related to that particular category, allowing users to easily access and utilize various functions and features in Excel.Rate this question:
-
- 41.
What is the function of the autofit ?
- A.
A symbol that represents a specific action
- B.
A way of arranging data in a particular order
- C.
Automatically change the width of a column to fit the longest entry or change the height of a row to fit the font
Correct Answer
C. Automatically change the width of a column to fit the longest entry or change the height of a row to fit the fontExplanation
The function of autofit is to automatically change the width of a column to fit the longest entry or change the height of a row to fit the font.Rate this question:
-
- 42.
A worksheet is..
- A.
A symbol that represents a specific action
- B.
Refers to the change a formula makes when it is moved or copied to other cells with different data
- C.
A table of data that is organized into rows and columns
Correct Answer
C. A table of data that is organized into rows and columnsExplanation
The correct answer is "A table of data that is organized into rows and columns." This answer accurately describes what a worksheet is in the context of computer software, such as Microsoft Excel. A worksheet is a digital document that allows users to input, manipulate, and analyze data. It consists of a grid-like structure with rows and columns, where data can be organized and displayed. This answer distinguishes a worksheet from the other options, which do not accurately describe the purpose or functionality of a worksheet.Rate this question:
-
- 43.
What is a Chart?
- A.
It is a visual way to display and compare data
- B.
A way of arranging data in a particular order
- C.
A calculation that describes the relationship between cells
Correct Answer
A. It is a visual way to display and compare dataExplanation
A chart is a visual way to display and compare data. It allows for easy understanding and analysis of data by presenting it in a graphical format. Charts can be used to show trends, patterns, and relationships between different sets of data. They are commonly used in presentations, reports, and data analysis to make complex information more accessible and visually appealing.Rate this question:
-
- 44.
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
A. Type the data in A1 and Merge cells A1:A5Explanation
To center a title across the top of the data, one way is to type the data in cell A1 and then merge cells A1:A5. By merging these cells, the title will span across all five columns (A to E) and be centered within the merged cell range.Rate this question:
-
- 45.
In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1="NO"?
- A.
Formula returns the value
- B.
Formula will show an error
- C.
Formula returns the value
- D.
Formula returns the value
Correct Answer
C. Formula returns the valueExplanation
If A1 is "NO", the formula will return the value "RESTART".Rate this question:
-
- 46.
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. This means that the entered characters will be automatically completed with the existing entry, saving time and reducing the chances of errors. Pressing Shift, Esc, or Alt will not have the same effect and will not accept the entry.Rate this question:
-
- 47.
When creating an Excel workbook, 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
When creating an Excel workbook, it is advised to avoid using red and green text and background together. This is because red-green color blindness is the most common form of color blindness. People with this condition have difficulty distinguishing between these two colors, which can make it challenging for them to read or interpret the information presented in the workbook.Rate this question:
-
- 48.
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.
- A.
What-if analysis
- B.
Track Changes
Correct Answer
A. What-if analysisExplanation
What-if analysis 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. This feature is useful for exploring different scenarios and understanding the impact of changes on the overall calculations in the spreadsheet.Rate this question:
-
- 49.
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 of the options mentioned can be used to sort data in an Excel worksheet. The "Sort A to Z and Sort Z to A buttons" can be found in the Home tab and are commonly used to sort data alphabetically. The "Quicksort Options" provide additional sorting options and can be accessed by right-clicking on a cell or range of cells. The "Sort command on the Formulas tab" is another option to sort data, which can be found in the Data Tools group on the Formulas tab.Rate this question:
-
- 50.
FUNCTION(argument1,argument2, ...) Is ________.
- A.
The syntax of writing optional arguments.
- B.
An example of a formula.
- C.
The general syntax of all functions.
- D.
The general syntax of all formulas.
Correct Answer
C. The general syntax of all functions.Explanation
The correct answer is "The general syntax of all functions." This answer is supported by the statement that the given function is used to define the syntax of optional arguments in a function. Therefore, it can be inferred that the function represents the general syntax of all functions.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 -
Apr 05, 2011Quiz Created by
Nsurani
Back to top