Excel Basics Quiz (Level1)

Reviewed by Editorial Team

The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.

Learn about Our Editorial Process

| By Shivraam Mittal

Shivraam Mittal

Community Contributor

Quizzes Created: 1 | Total Attempts: 518

| Attempts: 520

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Easy First Hard First Sequential

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

1/9 Questions

When Excel Opens a new _____________ is displayed
- Workbook
- Document
- Powerpoint
- TextFile

About This Quiz

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

2.

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

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:

1
3.

When a range is selected, the name box displays the cell address of the first cell in the range
- True
- False
Correct Answer

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:
4.

The merge and center Button is in which of the following group on the home tab
- Alignment
- Numbers
- Page Setup
Correct Answer

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:

2
5.

Which cells are included in the notion A1:D1
- A1
- B1
- C1
- D1
Correct Answer(s)

A. A1
A. B1
A. C1
A. 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:

3
6.

Which list is very handy to fill a range of cells with your own personal list
- Our List
- Custom List
- Home List
- Array List
Correct Answer

A. 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:

1
7.

Excel is a spreadsheet it is also called

Correct Answer
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:
8.

Shortcut key to get a Format Cells dialog box
- Ctrl + F1
- Ctrl + 1
- Ctrl + F2
- Ctrl + 2
Correct Answer

A. 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:

1
9.

Please select doughnut chart from the following charts

Quiz Review Timeline (Updated): May 13, 2023 +

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

Excel Basics Quiz (Level1)

When Excel Opens a new _____________ is displayed

Quiz Preview

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

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

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

Which cells are included in the notion A1:D1

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

Excel is a spreadsheet it is also called

Shortcut key to get a Format Cells dialog box

Please select doughnut chart from the following charts