# Excel - Pre Test

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 Bhavanabhagat
B
Bhavanabhagat
Community Contributor
Quizzes Created: 1 | Total Attempts: 403
Questions: 13 | Attempts: 403

Settings

-

• 1.

### Which view shows margins and the rulers?

• A.

Normal

• B.

Page Layout

• C.

Page Setup

• D.

Review

B. Page Layout
Explanation
The Page Layout view shows margins and rulers. This view allows users to see how the document will look when printed and adjust margins accordingly. The rulers help in aligning and positioning text, images, and other elements on the page.

Rate this question:

• 2.

### Which function results can be displayed in AutoCalculate?

• A.

SUM and AVERAGE

• B.

MAX and AVERAGE

• C.

LABEL and AVERAGE

• D.

MIN and BLANK

A. SUM and AVERAGE
Explanation
The AutoCalculate feature in Excel allows users to quickly view the sum and average of selected cells without having to manually input formulas. This feature is useful for quickly obtaining basic calculations without the need for complex formulas. Therefore, the correct answer is SUM and AVERAGE.

Rate this question:

• 3.

### Which of these references is an example of a mixed reference?

• A.

B1

• B.

\$B\$1

• C.

\$B1

• D.

AB1

C. \$B1
Explanation
A mixed reference is a reference that contains both absolute and relative references. In this case, the correct answer is \$B1 because the column reference (\$B) is absolute, while the row reference (1) is relative. This means that when the formula is copied or filled down to other cells, the column reference will stay the same (\$B), but the row reference will change based on the relative position of the new cell.

Rate this question:

• 4.

### How is a relative reference different from an absolute reference?

• A.

It includes column and row references.

• B.

It adjusts to its location on the worksheet.

• C.

It refers to an existing cell on the worksheet.

• D.

It resets to its original value.

B. It adjusts to its location on the worksheet.
Explanation
A relative reference is different from an absolute reference because it adjusts to its location on the worksheet. Unlike an absolute reference, which always refers to a specific cell, a relative reference is flexible and changes its reference based on its position relative to other cells. This means that if the relative reference is copied or moved to a different cell, it will automatically adjust its reference accordingly. This allows for more dynamic and flexible formulas in Excel.

Rate this question:

• 5.

### What category in the Format Cells dialog box is used to define a unique format for a date?

• A.

Custom

• B.

Date

• C.

Special

• D.

Text

A. Custom
Explanation
The category in the Format Cells dialog box that is used to define a unique format for a date is "Custom". This category allows users to create their own customized formats for dates, such as displaying the date in a specific order or including additional text or symbols. By selecting the "Custom" category, users have the flexibility to design a format that meets their specific needs and preferences for displaying dates.

Rate this question:

• 6.

### What statement describes this function: =SUMIF(D7:D14, ">1")?

• A.

It adds the values in cells D7:D14 if the value is greater than 1.

• B.

It adds all the negative values in cells D7:D14.

• C.

If the value in a cell is greater than 1, it is added to the other values in column D.

• D.

If the value in a cell is greater than 1, the range D7:D14 is placed on a summary sheet.

A. It adds the values in cells D7:D14 if the value is greater than 1.
Explanation
The function =SUMIF(D7:D14, ">1") calculates the sum of values in cells D7:D14 only if the value is greater than 1.

Rate this question:

• 7.

### Which of the following arguments in a financial function indicates the interest for a period?

• A.

FV

• B.

PV

• C.

Nper

• D.

Rate

D. Rate
Explanation
The argument "Rate" in a financial function indicates the interest for a period. This parameter is used to specify the interest rate per period in financial calculations. It is an essential component in calculations such as determining the future value or present value of an investment, calculating loan payments, or evaluating the profitability of an investment. The "Rate" argument allows for accurate and precise financial analysis by considering the interest rate associated with a specific period.

Rate this question:

• 8.

### If a cell contains =ROUND(3.4567,2), what value would be used in a formula that refers to that cell?

• A.

3.45

• B.

3.46

• C.

3.457

• D.

3.4567

B. 3.46
Explanation
The ROUND function is used to round a number to a specified number of decimal places. In this case, the number 3.4567 is being rounded to 2 decimal places. The ROUND function rounds up if the next digit is 5 or greater, and rounds down if the next digit is 4 or less. Therefore, the value that would be used in a formula that refers to the cell containing =ROUND(3.4567,2) is 3.46.

Rate this question:

• 9.

### Which of the following is the correct order for an A to Z sort?

• A.

1, 3, 5, 7

• B.

7, 5, 3, 1

• C.

• D.

May 1, 2007; April 1, 2007; March 1, 2007

A. 1, 3, 5, 7
• 10.

### Which category of functions obtains data or displays information from the current or other workbooks?

• A.

Financial

• B.

Database

• C.

Lookup and Reference

• D.

Logical

C. Lookup and Reference
Explanation
Lookup and Reference functions are used to obtain data or display information from the current or other workbooks. These functions allow users to search for specific values in a table or range and retrieve corresponding data or information. They are commonly used in Excel to perform tasks such as searching for a specific value in a large dataset, retrieving values from different worksheets or workbooks, and creating dynamic formulas that automatically update when the referenced data changes. Therefore, the correct answer is Lookup and Reference.

Rate this question:

• 11.

### Which of the following statements about range names is false?

• A.

They are easier to remember than cell addresses.

• B.

They can be used for navigation.

• C.

They automatically substitute the relevant cell addresses.

• D.

They make formulas easier to understand.

B. They can be used for navigation.
Explanation
Range names can be used for navigation within a worksheet, allowing users to quickly jump to specific areas. This feature enhances the ease of use and navigation within a large worksheet. Therefore, the statement "They can be used for navigation" is true, not false.

Rate this question:

• 12.

### What is a macro?

• A.

Solver scenario

• B.

Visual Basic scenario

• C.

Visual Basic routine

• D.

Solver routine

C. Visual Basic routine
Explanation
A macro is a set of instructions or commands that are recorded and can be executed to automate tasks in a software program. In this context, a Visual Basic routine refers to a macro that is written using the Visual Basic programming language. Therefore, the correct answer is Visual Basic routine.

Rate this question:

• 13.

### Why are PivotTables considered interactive?

• A.

They allow you to add dynamic data.

• B.

They allow you to rearrange row and column data.

• C.

They allow you to generate e-mail enabled reports.

• D.

They allow you to print the reports with various settings.

B. They allow you to rearrange row and column data.
Explanation
PivotTables are considered interactive because they allow users to rearrange row and column data. This means that users can easily change the layout of the data to analyze it from different perspectives. By rearranging the rows and columns, users can quickly summarize and compare different aspects of the data, making the analysis process more dynamic and flexible. This interactivity enables users to explore and understand the data more effectively.

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, 2023
Quiz Edited by
ProProfs Editorial Team
• Oct 31, 2010
Quiz Created by
Bhavanabhagat

Related Topics