# Excel 2 Final

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.
Learn about Our Editorial Process
| By Frespana
F
Frespana
Community Contributor
Quizzes Created: 2 | Total Attempts: 1,208
Questions: 24 | Attempts: 627

Settings

Final of concepts and terms for level 2.

• 1.

### To arrange rows in alphabetical order based on column A, you need to use the command _____.

• A.

Tools | Sort

• B.

Data | Sort

• C.

Edit | Data | Sort

• D.

None of the above

B. Data | Sort
Explanation
To arrange rows in alphabetical order based on column A, you need to use the command "Data | Sort". This command allows you to sort the data in a spreadsheet based on a specific column, in this case, column A. By selecting this option, you can easily organize the rows in alphabetical order according to the values in column A.

Rate this question:

• 2.

### To edit existing data in a cell without having to retype it all, you should _____.

• A.

Double-click the cell

• B.

Click in the Formatting toolbar

• C.

Hold SHIFT down while clicking the cell

• D.

None of the above - you must retype

A. Double-click the cell
Explanation
To edit existing data in a cell without having to retype it all, you should double-click the cell. Double-clicking the cell allows you to directly access the cell's content and make changes to it. This saves time and effort compared to retyping the entire content of the cell.

Rate this question:

• 3.

### If you select a cell with a date in it and drag the fill handle down across several cells, what happens is that _____.

• A.

The date is copied to each cell

• B.

The date is increased by 1 day into each cell

• C.

The date is increased by 1 week into each cell

• D.

Nothing as AutoFill applies only to numbers

B. The date is increased by 1 day into each cell
Explanation
When you select a cell with a date in it and drag the fill handle down across several cells, the date is increased by 1 day into each cell. This is because the fill handle automatically increments the date by one day as you drag it down.

Rate this question:

• 4.

### To print just part of a sheet, you would select what you want to print and _____

• A.

Click the Print button

• B.

Press the PRINT SCREEN key

• C.

Select Print selection on Page Setup | Sheet and then print

• D.

Select Print selection in the Print dialog and then print

D. Select Print selection in the Print dialog and then print
Explanation
To print just part of a sheet, you would select what you want to print and then choose the option to print the selection in the Print dialog. This allows you to specify which specific part of the sheet you want to print, rather than printing the entire sheet.

Rate this question:

• 5.

### To remove the contents of several cells at once, you can _____.

• A.

Select the cells and press DELETE.

• B.

Select the cells and choose Edit | Clear... | Contents

• C.

Select the cells and drag the fill handle back up over them

• D.

All of the above

D. All of the above
Explanation
To remove the contents of several cells at once, you have multiple options. One way is to select the cells and press the DELETE key on your keyboard. Another option is to select the cells and choose "Edit | Clear... | Contents" from the menu. Additionally, you can select the cells and drag the fill handle back up over them. Therefore, all of the above methods can be used to remove the contents of several cells at once.

Rate this question:

• 6.

### The formula that will add the value of cell D4 to the value of C2 and then multiply by the value in B2 is _____.

• A.

(D4+C2)*B2

• B.

D4+C2*B2

• C.

=(D4+C2)*B2

• D.

=(B2*(D4+C2)

C. =(D4+C2)*B2
Explanation
The correct answer is =(D4+C2)*B2. This formula correctly adds the value of cell D4 to the value of C2 and then multiplies it by the value in B2.

Rate this question:

• 7.

### The default orientation for the printed page is _____.

• A.

Portrait

• B.

Landscape

• C.

Whatever was last used

• D.

Vertical

A. Portrait
Explanation
The default orientation for a printed page is typically set to portrait. This means that the page is taller than it is wide, resembling the orientation of a portrait photograph. The other options, landscape and vertical, refer to orientations where the page is wider than it is tall. The option "whatever was last used" suggests that the default orientation is determined by the previous selection made by the user. However, in most cases, the default setting is portrait.

Rate this question:

• 8.

### Cell A4 =2 and A5 = 4. You select both cells and drag the fill handle down to A8. The contents of cells A6, A7, and A8 are _____.

• A.

8,16,32

• B.

2,4,2

• C.

2,2,2

• D.

6,8,10

D. 6,8,10
Explanation
When you select both cells A4 and A5 and drag the fill handle down to A8, Excel automatically fills the cells with a series based on the pattern it detects. In this case, the pattern is an increment of 2. So, starting from A6, the contents of the cells would be 6 (2+4), 8 (6+2), and 10 (8+2). Therefore, the correct answer is 6, 8, 10.

Rate this question:

• 9.

### If a cell shows  ####### , it means that _____.

• A.

Your formula has a syntax error

• B.

The row is too short to show the number at the current font size

• C.

The column is too narrow to show all the digits of the number

• D.

Either a or b

C. The column is too narrow to show all the digits of the number
Explanation
If a cell shows #######, it means that the column is too narrow to show all the digits of the number. This happens when the number in the cell is too long to fit within the width of the column. The cell displays ####### as a way to indicate that the number cannot be fully displayed.

Rate this question:

• 10.

### The default number of worksheets in an Excel Workbooks is ___?

• A.

There is no default. It has to be set each time Excel is opened.

• B.

3

• C.

255

• D.

1

B. 3
• 11.

### One way to enter data into a cell is by typing into the formula bar and clicking on the check mark button.

• A.

True

• B.

False

A. True
Explanation
Typing into the formula bar and clicking on the check mark button is indeed one way to enter data into a cell. The formula bar is located at the top of the Excel window and allows users to directly input or edit the contents of a selected cell. By typing into the formula bar and clicking on the check mark button, the input data is confirmed and entered into the selected cell. Therefore, the statement is true.

Rate this question:

• 12.

### Which of the following is not a valid method for selecting a range of cells?

• A.

Click in the cell to be the upper left corner, press and hold your left mouse button while dragging your mouse to the cell that will be the lower right corner of your range.

• B.

Click in the cell to be the upper left corner, hold your shift key down and then click in the cell that will be the lower right corner of your range.

• C.

Click in the cell to be the upper left corner, hold your shift key down and then use your tab key to move to the cell that will be the lower right corner of your range.

• D.

Click in the cell to be the upper left corner, hold your shift key down and then use your arrow keys to move to the cell that will be the lower right corner of your range.

C. Click in the cell to be the upper left corner, hold your shift key down and then use your tab key to move to the cell that will be the lower right corner of your range.
Explanation
This method is not a valid method for selecting a range of cells because using the tab key will move the selection to the next cell in the same row, rather than selecting a range of cells.

Rate this question:

• 13.

### There are 3 possible cursors when you point to an Excel cell. Which of the following statements is true?

• A.

The white cross is used to select or move a cell or a range of cells.

• B.

The small black crosshair on the lower right corner of a cell can be used to create a series or copy the contents from one cell to another.

• C.

Pointing to a border with the mouse will allow you to enlarge the cell.

• D.

A cell cannot be moved with the mouse.

B. The small black crosshair on the lower right corner of a cell can be used to create a series or copy the contents from one cell to another.
Explanation
The small black crosshair on the lower right corner of a cell can be used to create a series or copy the contents from one cell to another. This is true because when you drag the small black crosshair, Excel automatically fills in a series of values based on the pattern it detects, or it copies the content of the selected cell to adjacent cells. This feature is useful for quickly populating a column or row with a sequence of values or copying a formula or data to multiple cells.

Rate this question:

• 14.

### If a cell has the contents, 12032.50 and has been formatted to a currency format with no decimals places, which of the following will appear in the cell?

• A.

12,032

• B.

\$12,032

• C.

\$12,033

• D.

\$12033

D. \$12033
Explanation
The cell has been formatted to a currency format with no decimal places, which means that the decimal portion of the number will be rounded up. Therefore, the number 12032.50 will be rounded up to the nearest whole number, resulting in \$12,033 appearing in the cell.

Rate this question:

• 15.

### When you use the spellchecker feature, if Excel displays "no suggestion" you don't have to close the spellchecker dialog box in order to correct your entry.

• A.

True

• B.

False

A. True
Explanation
When using the spellchecker feature in Excel, if the program displays "no suggestion," it means that the word you entered is spelled correctly and does not require any corrections. Therefore, you do not need to close the spellchecker dialog box in order to correct your entry. This statement is true.

Rate this question:

• 16.

### You can rename worksheets by either double clicking or right clicking on the tab. When the tab is highlighted, you can retype the new name.

• A.

True

• B.

False

A. True
Explanation
You can rename worksheets by either double clicking or right clicking on the tab and then retyping the new name. This suggests that the statement is true.

Rate this question:

• 17.

### When you create a chart on the same sheet as your worksheet it is called:

• A.

An embedded chart

• B.

An exception chart

• C.

A companion chart

• D.

There is no special name

A. An embedded chart
Explanation
An embedded chart refers to a chart that is created on the same sheet as the worksheet. It is called "embedded" because it is inserted within the worksheet itself, allowing for easy reference and analysis of the data. This type of chart is commonly used to visually represent and interpret data within the context of the worksheet, making it a convenient and effective way to present information.

Rate this question:

• 18.

### The only formats you can choose for numbers in a chart are currency, fractions, or percentages.

• A.

True

• B.

False

B. False
Explanation
The statement is false because there are more formats available for numbers in a chart than just currency, fractions, or percentages. Other common formats include dates, times, decimals, scientific notation, and general number formats.

Rate this question:

• 19.

### Which method is the correct one to draw a perfect square after you have chosen the rectangle drawing tool?

• A.

Draw a rectangle and then double clicking the lower right sizing handle.

• B.

Use the ruler on the top and sides as a guide.

• C.

Hold the shift key down while dragging the crosshair with your left mouse button.

• D.

Right click and drag the crosshair into the shape you want.

C. Hold the shift key down while dragging the crosshair with your left mouse button.
Explanation
Holding the shift key down while dragging the crosshair with the left mouse button ensures that the shape drawn remains proportional and forms a perfect square. This method allows for precise control and accuracy in creating a square shape using the rectangle drawing tool.

Rate this question:

• 20.

### If the dates "07/15/00" and "July 15, 2000" were in cells that are part of formulas, they would be treated exactly the same by Excel because all dates are actually numbers no matter how they are formatted.

• A.

True

• B.

False

A. True
Explanation
The explanation for the given correct answer is that Excel treats dates as numbers, regardless of their formatting. This means that the dates "07/15/00" and "July 15, 2000" would be considered the same by Excel because they are both representing the same date, just in different formats. Excel internally stores dates as sequential serial numbers, with January 1, 1900 being represented by the number 1. Therefore, regardless of the format, Excel will treat both dates as numbers and perform calculations accordingly.

Rate this question:

• 21.

### In order for filters to work correctly, the data must be Excel list format. The rules that define sorting also define filtering.

• A.

True

• B.

False

A. True
Explanation
The explanation for the given answer is that filters in Excel require the data to be in Excel list format in order to work correctly. This means that the data should be organized in a tabular format with each column representing a different attribute and each row representing a different record. The rules that define sorting, such as arranging data in ascending or descending order, also define filtering. Therefore, if the data is not in Excel list format, the filters may not function properly.

Rate this question:

• 22.

### In order to customize a toolbar, you must have the Customize dialog box open or attempting to move it will execute the button's functions.

• A.

True

• B.

False

A. True
Explanation
To customize a toolbar, it is necessary to have the Customize dialog box open. If the dialog box is not open, attempting to move the toolbar will instead execute the functions of the buttons on the toolbar. This implies that the Customize dialog box is crucial for customizing the toolbar, and without it, the toolbar functions will be executed instead of allowing customization. Therefore, the statement is true.

Rate this question:

• 23.

### The IF function will enable you to perform a calculation if a certain condition is true and to perform a different calculation if that condition is false.

• A.

True

• B.

False

A. True
Explanation
The explanation for the given correct answer is that the IF function in Excel allows for conditional calculations. It evaluates a specified condition and if the condition is true, it performs one calculation, and if the condition is false, it performs a different calculation. This functionality is useful for creating dynamic formulas that can adapt based on certain criteria or conditions.

Rate this question:

• 24.

### Which of the following statements about Consolidate is not true?

• A.

Consolidating data enables you to summarize data from several ranges in a single range.

• B.

To consolidate data, you must specify where to place the result (destination) and you must specify the various ranges that will be consolidated (source areas).

• C.

The source for the data must be from the same worksheet or workbook.

• D.

The source for the data must be from the same worksheet or workbook, or can also come from another workbook.

C. The source for the data must be from the same worksheet or workbook.
Explanation
The statement "The source for the data must be from the same worksheet or workbook" is not true. The source for the data can come from the same worksheet or workbook, but it can also come from another workbook.

Rate this question:

Related Topics