# Excel Assessment - Level 1

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 Management
M
Management
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,260
Questions: 8 | Attempts: 1,260

Settings

This assessment will be used to measure your knowledge of Excel.

• 1.

### C4:D11 is an example of a .

• A.

Formula

• B.

Range

• C.

Column

• D.

Cell

B. Range
Explanation
C4:D11 is an example of a range because it represents a group or collection of cells in a spreadsheet. A range is defined by specifying the starting cell and the ending cell, separated by a colon. In this case, the range starts at cell C4 and ends at cell D11, encompassing all the cells in between.

Rate this question:

• 2.

### What symbol is missing in the beginning of this formula? SUM(B2:B11)

• A.

;

• B.

*

• C.

=

• D.

/

• E.

//

C. =
Explanation
The symbol that is missing in the beginning of the formula is the equals sign (=). The equals sign is used in formulas to indicate that a calculation or function is being performed. In this case, the formula is SUM(B2:B11), which calculates the sum of the values in cells B2 to B11.

Rate this question:

• 3.

### There are multiple ways to insert a hyperlink into a cell.

• A.

True

• B.

False

A. True
Explanation
The statement is true because in most spreadsheet programs, such as Microsoft Excel or Google Sheets, you can insert a hyperlink into a cell by selecting the cell, right-clicking on it, and choosing the "Insert Hyperlink" option. Alternatively, you can use the keyboard shortcut Ctrl+K to open the hyperlink dialog box and enter the desired link. This allows users to easily add clickable links to their spreadsheet cells, which can be useful for referencing external websites, documents, or other resources.

Rate this question:

• 4.

### Data can be sorted by ____________ ? (Please check all answers that apply)

• A.

Font type

• B.

Value

• C.

Cell Color

• D.

Alphabetically

• E.

All of the above

B. Value
C. Cell Color
D. Alphabetically
Explanation
Data can be sorted by value, cell color, and alphabetically. Sorting by value means arranging the data in ascending or descending order based on the numerical values. Sorting by cell color involves arranging the data based on the color of the cells, which can be useful for categorizing or highlighting specific data. Sorting alphabetically means arranging the data in alphabetical order based on the text or characters. Therefore, all of the given options are correct for sorting data.

Rate this question:

• 5.

### The two orientation styles of a page layout are landscape and .

Portrait
Explanation
The two orientation styles of a page layout are landscape and portrait. Landscape refers to a layout where the width of the page is greater than its height, while portrait refers to a layout where the height of the page is greater than its width. These two styles offer different options for displaying and arranging content, allowing for flexibility in design and presentation.

Rate this question:

• 6.

### If you need a total of C1:D2, which of the following would you use? (Check all answers that apply)

• A.

Sum(C1:D2)

• B.

Total(C1:D2)

• C.

C1+D2

• D.

C1+C2+D1+D2

A. Sum(C1:D2)
D. C1+C2+D1+D2
Explanation
To calculate the total of the range C1:D2, you can use the formula Sum(C1:D2). This formula will add up all the values within the range and give you the sum. Additionally, you can also use the formula C1+C2+D1+D2 to manually add up the individual values in the range. Both of these methods will give you the total of the range C1:D2.

Rate this question:

• 7.

### Select the best description(s) for applying a macro to a sheet.

• A.

Insert -> Sheet Options -> Insert Macro

• B.

View -> Record Macro -> Stop Recording

• C.

Developer -> Design Mode -> Run Macro -> Stop Macro

• D.

Developer -> Record Macro -> Stop Recording

• E.

Both B and D

E. Both B and D
Explanation
Both options B and D are correct because they both involve recording a macro. In option B, the user goes to the View tab, selects Record Macro, and then stops recording. In option D, the user goes to the Developer tab, selects Record Macro, and then stops recording. Both options involve the process of recording a macro, which allows the user to automate a series of actions in Excel.

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
• Mar 14, 2012
Quiz Created by
Management

Related Topics