# Excel Proficiency Quiz AFS

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 AmericanFleet
A
AmericanFleet
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,118
Questions: 10 | Attempts: 1,118

Settings

This is to Enhance your Excel Skills

• 1.

### Labels are aligned at the ________ edge of the cell.

• A.

Left

• B.

Right

• C.

Top

• D.

Bottom

A. Left
Explanation
Labels are aligned at the left edge of the cell.

Rate this question:

• 2.

### You can complete a cell entry by pressing

• A.

Enter

• B.

Tab

• C.

Shift+tab

• D.

An arrow key

• E.

Another cell

• F.

All of the Above

F. All of the Above
Explanation
Pressing "enter", "tab", "shift+tab", an arrow key, or moving to another cell are all ways to complete a cell entry in a spreadsheet. Therefore, the correct answer is "All of the Above" as all of these options can be used to finalize a cell entry.

Rate this question:

• 3.

### The default font keyed in a new work book is.

• A.

12 pt. Times New Romans

• B.

10 pt. Arial

• C.

• D.

10 pt. Times New Roman

B. 10 pt. Arial
Explanation
The default font in a new workbook is 10 pt. Arial.

Rate this question:

• 4.

### True or False.  If you choose a larger font size, the height of the row is automatically made taller.

• A.

True

• B.

False

A. True
Explanation
If you choose a larger font size, the height of the row is automatically made taller. This is because the font size determines the amount of vertical space that each character occupies. When the font size is increased, the characters become larger and require more vertical space, thus causing the row height to increase.

Rate this question:

• 5.

### Which button allows you to copy cell formats from one cell to another?

• A.

Enter

• B.

Autofit

• C.

Format painter

• D.

Esc

C. Format painter
Explanation
The format painter button allows you to copy cell formats from one cell to another. This tool is useful when you want to apply the same formatting, such as font style, font size, and cell borders, to multiple cells without manually adjusting each one. By selecting the cell with the desired format and clicking on the format painter button, you can then apply the formatting to other cells by clicking on them.

Rate this question:

• 6.

### A_______ is a group of cells that form a retangle on the screen.

• A.

Label

• B.

Workbook

• C.

Worksheet

• D.

Column

• E.

Range

E. Range
Explanation
A range is a group of cells that form a rectangle on the screen. It can be a selection of cells, a specific row or column, or even multiple rows and columns. Ranges are commonly used in spreadsheet programs to perform calculations, apply formatting, or manipulate data within a specific area of a worksheet.

Rate this question:

• 7.

### How do you know a range is active?

• A.

It is highlighted on the screen.

• B.

It has a marquee around it.

• C.

The data changes to Bold to let me know it's active

A. It is highlighted on the screen.
Explanation
The correct answer is that a range is active when it is highlighted on the screen. This means that the range is currently selected or being worked on. This visual indicator helps the user identify which range they are currently working with and ensures that any actions or changes made will apply to that specific range. The other options, having a marquee around it or the data changing to bold, are not mentioned as indicators of an active range, making them incorrect choices.

Rate this question:

• 8.

### True or False.  A range has an address called an range address.

• A.

True

• B.

False

A. True
Explanation
A range in computer programming refers to a group of cells or values within a spreadsheet or document. Each range has an address called a range address, which helps identify and locate the specific range within the document. Therefore, the statement that a range has an address called a range address is true.

Rate this question:

• 9.

### An example of a  range address.

• A.

A1:B3

• B.

A1;B3

• C.

A1-B3

• D.

A1=B3

• E.

A1*B3

A. A1:B3
Explanation
The correct answer is A1:B3 because it represents a range of cells in a spreadsheet. The "A1" refers to the top-left cell of the range, and the "B3" refers to the bottom-right cell of the range. This notation is commonly used in spreadsheet programs to specify a group of cells that are adjacent to each other and need to be selected or manipulated together.

Rate this question:

• 10.

### When you start to select a range of cells, you will see a thick white, cross shaped pointer called a ________________.

• A.

Cell selector

• B.

Cell cross

• C.

Selection pointer

• D.

Range selector

C. Selection pointer
Explanation
When you start to select a range of cells, you will see a thick white, cross-shaped pointer called a selection pointer. This pointer helps you visually identify and indicate the cells that you are selecting. It allows you to easily choose multiple cells or a range of cells in a spreadsheet or document.

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 04, 2023
Quiz Edited by
ProProfs Editorial Team
• Oct 01, 2012
Quiz Created by
AmericanFleet

Related Topics