# Excel Basics Quiz (Level1)

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 Shivraam Mittal
S
Shivraam Mittal
Community Contributor
Quizzes Created: 1 | Total Attempts: 362
Questions: 9 | Attempts: 362

Settings

This quiz depicts some of the many different question of Excel Basics

• 1.

• 2.

### When Excel Opens a new _____________ is displayed

• A.

Workbook

• B.

Document

• C.

Powerpoint

• D.

TextFile

A. Workbook
Explanation
When Excel opens, a new workbook is displayed. A workbook in Excel is a collection of worksheets where data can be entered and manipulated. Each workbook can contain multiple worksheets, allowing users to organize and analyze data effectively. Therefore, when Excel is opened, a new workbook is created and presented to the user for data input and analysis.

Rate this question:

• 3.

### Which cells are included in the notion A1:D1

• A.

A1

• B.

B1

• C.

C1

• D.

D1

A. A1
B. B1
C. C1
D. D1
Explanation
The notion A1:D1 includes cells A1, B1, C1, and D1. This means that the range of cells from A1 to D1, inclusive, are included in the notion.

Rate this question:

• 4.

### Colon symbol is inserted between two cell address indicates a range (True/False)

• A.

True

• B.

False

A. True
Explanation
When a colon symbol is inserted between two cell addresses in a spreadsheet, it indicates a range. A range refers to a group of cells that are adjacent to each other and can be selected or manipulated as a single entity. For example, if cell A1 and cell B5 are separated by a colon symbol (A1:B5), it means that all the cells from A1 to B5, including both endpoints, are included in the range. This allows for easier and more efficient manipulation of data within the specified range.

Rate this question:

• 5.

### Excel is a spreadsheet it is also called

Worksheet
Explanation
Excel is a spreadsheet software that allows users to create and manipulate data in a grid format. One of the terms used to refer to a single sheet within an Excel file is a "worksheet." This term is commonly used to describe the individual pages or tabs where data can be entered, organized, and analyzed. Therefore, the answer "Worksheet" accurately describes one of the names used to refer to a sheet within Excel.

Rate this question:

• 6.

### The merge and center Button is in which of the following group on the home tab

• A.

Alignment

• B.

Numbers

• C.

Page Setup

A. Alignment
Explanation
The merge and center button is located in the Alignment group on the home tab. This group contains various formatting options related to aligning and merging cells in a spreadsheet or document. The merge and center function allows users to combine multiple cells into one and center the content within that merged cell. It is commonly used to create headings or titles that span across multiple columns or rows.

Rate this question:

• 7.

### When a range is selected, the name box displays the cell address of the first cell in the range

• A.

True

• B.

False

A. True
Explanation
When a range of cells is selected in a spreadsheet, the name box, which is usually located next to the formula bar, shows the cell address of the first cell in that range. This allows the user to easily identify and remember the starting point of the selected range. This feature is particularly useful when working with large datasets or when performing calculations or formatting on multiple cells at once.

Rate this question:

• 8.

### Shortcut key to get a Format Cells dialog box

• A.

Ctrl + F1

• B.

Ctrl + 1

• C.

Ctrl + F2

• D.

Ctrl + 2

B. Ctrl + 1
Explanation
The shortcut key Ctrl + 1 is used to open the Format Cells dialog box in various applications, including Microsoft Excel. This dialog box allows users to modify the formatting of selected cells, such as changing the font, alignment, borders, and number formatting. By pressing Ctrl + 1, users can quickly access this dialog box and make formatting changes without having to navigate through multiple menus or options.

Rate this question:

• 9.

### Which list is very handy to fill a range of cells with your own personal list

• A.

Our List

• B.

Custom List

• C.

Home List

• D.

Array List

B. Custom List
Explanation
A "Custom List" is a list that you can create and customize according to your own preferences. It allows you to fill a range of cells with your own personal list of items, making it very handy for this purpose. The other options, such as "Array List," "Our List," and "Home List," do not specifically refer to a feature or functionality that allows you to create and fill cells with your own personal list.

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
• May 13, 2023
Quiz Edited by
ProProfs Editorial Team
• Apr 28, 2020
Quiz Created by
Shivraam Mittal

Related Topics