# 2nd Yr MS Excel 2007

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Asiangal1369
A
Asiangal1369
Community Contributor
Quizzes Created: 1 | Total Attempts: 415
Questions: 39 | Attempts: 415

Settings

Some people have had computers with them but are still unable to make maximum use of the excel sheet. As a second year student you should by now know how to use Microsoft office. Test your knowledge on Microsoft excel by taking this simple quiz. All The best in your studies!

• 1.

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

• A.

Expressions

• B.

Arguments

• C.

Data

• D.

Values

B. Arguments
Explanation
In this context, "arguments" refers to the numbers, text, or cell references that are used by a function to perform a calculation or operation and return a value. These arguments serve as inputs for the function and determine the result that is returned. Therefore, the correct answer is "arguments".

Rate this question:

• 2.

### The ____ button is equivalent to using the sum button.

• A.

COUNT

• B.

• C.

AutoSum

• D.

C. AutoSum
Explanation
The AutoSum button is equivalent to using the sum button because it automatically selects the range of cells containing numbers and inserts the SUM function, which adds up the values in those cells. This saves time and effort as it eliminates the need to manually select the range and enter the SUM function.

Rate this question:

• 3.

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

• A.

True

• B.

False

A. True
Explanation
Formatting refers to the visual presentation of data, such as changing font styles, colors, or adding borders. It does not alter the actual data or its content. For example, if you bold a word in a document, it does not change the meaning or value of the word itself. Therefore, the statement that formatting changes only the appearance of data and not the data itself is true.

Rate this question:

• 4.

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

• A.

True

• B.

False

B. False
Explanation
When you merge a range into a single cell, you can still realign its content. Merging cells simply combines multiple cells into one, but it does not restrict the ability to change the alignment of the text or other content within the merged cell. Therefore, the statement that you can't realign the content after merging is false.

Rate this question:

• 5.

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

• A.

True

• B.

False

A. True
Explanation
In Excel, it is possible to rotate cell contents so that they can be displayed at any angle or orientation. This feature allows users to customize the appearance of their data and make it easier to read. By rotating cell contents, users can present their data in a more visually appealing and organized manner. This can be particularly useful when working with large sets of data or when creating reports or presentations. Therefore, the statement "You can rotate cell contents in Excel so that they appear at any angle or orientation" is true.

Rate this question:

• 6.

### When a worksheet is printed, the grid lines that surround the cells are printed by default.

• A.

True

• B.

False

B. False
Explanation
By default, when a worksheet is printed, the grid lines that surround the cells are not printed. This means that when you print a worksheet, only the content within the cells will be printed without any visible grid lines. If you want to print the grid lines as well, you need to manually enable the "Print Gridlines" option in the print settings.

Rate this question:

• 7.

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

• A.

True

• B.

False

A. True
Explanation
A conditional format is a feature that allows you to apply formatting to cells based on certain conditions. In this case, the condition is whether a number is negative or positive. If a number is negative, the conditional format will be applied to make it red, indicating a negative value. If a number is positive, the conditional format will make it black, indicating a positive value. Therefore, the statement that a conditional format can make negative numbers red and positive numbers black is true.

Rate this question:

• 8.

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

• A.

True

• B.

False

B. False
Explanation
You can always choose to un-hide it.

Rate this question:

• 9.

### What is a workbook made up of?

Worksheet
worksheets
Explanation
A workbook is made up of one or more worksheets. Worksheets are individual spreadsheets within a workbook where data can be entered, organized, and manipulated. They are used to store and analyze data, perform calculations, and create charts and graphs. Multiple worksheets within a workbook allow for organizing and categorizing different sets of data or for creating different views or reports based on the same data.

Rate this question:

• 10.

### Multiplication before addition is an example of ____________________

order of operations
order of operation
Explanation
Multiplication before addition is an example of the order of operations. In mathematics, the order of operations is a set of rules that determines the sequence in which operations should be performed in an expression to obtain the correct result. According to these rules, multiplication should be performed before addition, ensuring that the multiplication operation is carried out first and then the addition operation. This specific order helps to maintain consistency and avoid ambiguity when evaluating mathematical expressions.

Rate this question:

• 11.

### When you copy a range of cells, you must press the _____ key while you drag the selection to its new location.

Ctrl
control
Explanation
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 is used to initiate the copy action and allows you to duplicate the selected cells in the desired location without removing them from their original position. By holding down the Ctrl or control key, you can easily copy and paste data within a spreadsheet or between different worksheets or workbooks.

Rate this question:

• 12.

### A named operation that returns a value is a ______.

function
Explanation
A named operation that returns a value is called a function. Functions are blocks of code that perform specific tasks and can be called multiple times throughout a program. They can accept input parameters and can also return a value as a result of their execution. Functions are essential in programming as they help in organizing code, promoting reusability, and improving overall efficiency.

Rate this question:

• 13.

### A group of worksheet cells is called a _________.

range
Explanation
A group of worksheet cells is called a range. A range allows you to select and manipulate multiple cells at once, making it easier to perform calculations or formatting changes across a specific set of cells. By referring to a range, you can apply formulas, formatting, or other actions to all the cells within that range simultaneously. This helps to streamline and organize data management in a spreadsheet.

Rate this question:

• 14.

### Pressing Ctrl + ' switches to the _________ view.

formula
Explanation
Pressing Ctrl + ' switches to the formula view.

Rate this question:

• 15.

### A _______________ is an excel document.

workbook
Explanation
A workbook is a term used to describe an excel document. It is a file that contains multiple worksheets, which are used to organize and store data. Workbooks are created and used in Microsoft Excel, a popular spreadsheet program. They allow users to input and manipulate data, perform calculations, and create charts and graphs. Workbooks are commonly used for financial analysis, data management, and reporting purposes. They provide a structured and organized way to store and analyze data in a tabular format.

Rate this question:

• 16.

### The _____________ button quickly inserts Excel functions.

AutoSum
auto sum
Explanation
The AutoSum button in Excel quickly inserts functions into a worksheet. It automatically selects the range of cells that it believes the user wants to include in the function and inserts the appropriate formula. This saves time and effort for the user, as they do not have to manually select the range and type in the formula. The AutoSum button is a convenient feature for users who frequently use functions in Excel.

Rate this question:

• 17.

### The _________________ displays the name of the sheets in the workbook.

sheet tabs
Explanation
The sheet tabs in a workbook display the names of the sheets. This allows users to easily navigate between different sheets within the workbook by clicking on the corresponding tab.

Rate this question:

• 18.

### The ____________ displays the cell reference of the active cell.

name box
Explanation
The name box in a spreadsheet program displays the cell reference of the active cell. It allows users to see and edit the location of the cell they are currently working on. This feature is useful for navigating and referencing specific cells within a large spreadsheet.

Rate this question:

• 19.

### 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

D. Use the Number group to decrease the number of digits displayed
Explanation
The correct answer suggests using the Number group to decrease the number of digits displayed in order to make the data appear cleaner. This means that instead of reentering all the numbers, decreasing the column width, or decreasing the font size, the Number group can be used to specifically adjust the number of digits displayed in the cell. This allows for a more efficient and targeted approach to cleaning up the data and removing any distracting decimal places.

Rate this question:

• 20.

### 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

B. Type the data in A1 and Merge cells A1:E1
Explanation
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 to E1. This will combine the cells into one large cell, allowing the title to be centered across the entire row.

Rate this question:

• 21.

### 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

A. Use Format Painter
D. Apply a table style
Explanation
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, saving time and effort. Additionally, applying a table style can also be an efficient way to format multiple cells, as it allows you to quickly apply a predefined set of formatting options to the entire table.

Rate this question:

• 22.

### 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

A. Red and green
Explanation
When creating an Excel document, it is important 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 colors, which can make it challenging for them to read or interpret the information in the document accurately.

Rate this question:

• 23.

### 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

A. Center column titles, left align text, and right align numbers
Explanation
As a general rule, when formatting a table, it is recommended to center column titles to make them stand out and easily distinguishable. Text should be left aligned to ensure readability and a consistent left margin. Numbers, on the other hand, should be right aligned to maintain a neat and organized appearance, making it easier to compare and analyze numerical data.

Rate this question:

• 24.

### The Paste Options button allows you to________.

• A.

Keep source formatting

• B.

Copy formatting only

• C.

Copy values only

• D.

All of the above

D. All of the above
Explanation
The Paste Options button allows you to perform multiple actions including keeping the source formatting, copying formatting only, and copying values only. This button provides a range of options for pasting content, giving users the flexibility to choose the desired action based on their specific needs.

Rate this question:

• 25.

### 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

D. 1, 5, 2, 3, 4
Explanation
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. From the drop-down menu, select Paste Special to open the dialog box. In the dialog box, specify exactly what you want to paste. Finally, select the range where you want to paste the Clipboard contents. Therefore, the correct order of steps is 1, 5, 2, 3, 4.

Rate this question:

• 26.

### 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

A. True
Explanation
When a new row is inserted at the top of a table, it becomes the header row. This means that the new row will have the same formatting as the rest of the table, including the table style. This is true and can be observed when adding a new row to the top of a table in various word processing software.

Rate this question:

• 27.

### 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

B. False
Explanation
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 tools that visually represent the values in a range of cells. The length of the data bar is determined by the relative value of each cell within the range. Therefore, if the value of one cell changes, the length of its data bar will change accordingly, causing the size of all the other cells' data bars to adjust as well.

Rate this question:

• 28.

### 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

A. True
Explanation
The statement is true because when adding a record to a table, it is common practice to enter the data in the first blank row. This ensures that the record is added in a sequential order and maintains the structure and organization of the table. It is also convenient as it eliminates the need to search for an empty row to add the data.

Rate this question:

• 29.

### 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

A. True
Explanation
Using the Sort A to Z or Sort Z to A buttons is indeed an easy way to sort data when there is only one sort field. These buttons allow you 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 writing complex sorting algorithms, making it a convenient option for simple sorting tasks.

Rate this question:

• 30.

### Removing the contents of a cell is known as ____ a cell.

• A.

Clearing

• B.

Emptying

• C.

Editing

• D.

Deleting

A. Clearing
Explanation
Removing the contents of a cell means clearing the cell. This action involves deleting the existing data or information present in the cell, leaving it empty. The term "clearing" accurately describes the process of eliminating the content within a cell without necessarily deleting the cell itself.

Rate this question:

• 31.

### 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

D. Any of the above
Explanation
The correct answer is "Any of the above." This is because all of the 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 specific requirements, any of these options can be used to arrange the data in ascending or descending order.

Rate this question:

• 32.

### You can create at most one Excel table in a worksheet

• A.

True

• B.

False

B. False
Explanation
In Excel, you can create multiple tables in a single worksheet. Tables are a powerful feature that allow you to organize and analyze data more efficiently. By creating multiple tables, you can separate different sets of data and apply different formatting or calculations to each table. This can help in keeping your data organized and making it easier to work with. Therefore, the statement "You can create at most one Excel table in a worksheet" is false.

Rate this question:

• 33.

### 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

A. True
Explanation
The statement is true because when adding a record to a table, it is common practice to enter the data in the first blank row below the last record. This ensures that the new record is added at the end of the table and maintains the order of the existing records. It is also convenient because it eliminates the need to search for an empty row to insert the new data.

Rate this question:

• 34.

### You can use a table's sizing handle to add columns or rows to a table

• A.

True

• B.

False

A. True
Explanation
A table's sizing handle allows you to add columns or rows to a table. By clicking on the sizing handle and dragging it, you can increase the size of the table by adding more columns or rows. This feature is useful when you need to expand the table to accommodate more data or adjust the layout of the table. Therefore, the statement "You can use a table's sizing handle to add columns or rows to a table" is true.

Rate this question:

• 35.

### When you clear a filter, all filters in the worksheet are cleared

• A.

True

• B.

False

B. False
Explanation
When you clear a filter, only the specific filter that you cleared is cleared, not all filters in the worksheet.

Rate this question:

• 36.

### 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

A. Table
Explanation
When you designate a range as a "Table" in Excel, it provides the same operations as are available for a structured range of data. This means that you can easily sort, filter, and analyze the data within the table. Tables also come with built-in features such as automatic row expansion, column headers, and the ability to easily create formulas that automatically apply to new data added to the table. By using tables, you can organize and manage your data more efficiently in Excel.

Rate this question:

• 37.

### 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

B. Tab
Explanation
When Excel displays an existing entry in the column that matches the characters you type, pressing the Tab key allows you to accept the entry and move to the next cell. The Tab key is commonly used in Excel to navigate between cells, and in this scenario, it confirms the displayed entry and allows for seamless data entry.

Rate this question:

• 38.

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

• A.

True

• B.

False

A. True
Explanation
The function arguments dialog box provides information on how to use functions. It likely includes details on the required arguments, optional arguments, and their respective data types. By referring to this dialog box, users can understand the correct syntax and usage of functions in a particular programming language or software.

Rate this question:

• 39.

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

• A.

True

• B.

False

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

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
• Sep 05, 2023
Quiz Edited by
ProProfs Editorial Team
• Jan 10, 2012
Quiz Created by
Asiangal1369

Related Topics