How Well Do You Know MS EXCEL?

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 Themes

Themes

Community Contributor

Quizzes Created: 424 | Total Attempts: 1,002,807

| Attempts: 818

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/21 Questions

You can use Excel to create budgets, to work with taxes, or to record student grades
- True
- False
- Option 3
- Option 4

About This Quiz

Microsoft Excel plays a key role in many sectors. It is used for spreadsheets in a lot of business activities, and the organization of personal data. Ever wondered how much you know about MS Excel? Take the online quiz and find out.

2.

_______, ________ and _______ are what you see when you open Excel
- Columns, rows, and charts
- Columns, rows, and formulas
- Columns, rows, and cells
- Non of the above
Correct Answer

A. Columns, rows, and cells

Explanation

When you open Excel, you see columns, rows, and cells. Columns are vertical and labeled with letters, rows are horizontal and labeled with numbers, and cells are the individual boxes where you can enter data or formulas.

Rate this question:

3
3.

___________ are where you get down to business and enter data in a worksheet.
- Cells
- Fields
- Tables
- None of the above
Correct Answer

A. Cells

Explanation

Cells are where you get down to business and enter data in a worksheet. In a spreadsheet program like Microsoft Excel, a worksheet is made up of a grid of cells. Each cell can contain data, such as numbers, text, or formulas. By entering data into cells, you can perform calculations, organize information, and create charts or graphs. Therefore, cells are the correct answer as they are the fundamental units for data entry and manipulation in a worksheet.

Rate this question:

2
4.

Numbers and Letters are called Data
- True
- False
Correct Answer

A. True

Explanation

The given statement is true because numbers and letters are both types of data. Data refers to any information that can be stored and processed by a computer or used to make decisions. Numbers can represent quantities or values, while letters can represent characters or symbols. Therefore, both numbers and letters are considered data in the context of computing.

Rate this question:

1
5.

The cell in the worksheet in which you can type data is called the stem cells.
- True
- False
Correct Answer

A. False

Explanation

The statement is false. The cell in the worksheet in which you can type data is not called the stem cells. The correct term for the cell in which you can type data is simply called a "cell" or "data cell". Stem cells, on the other hand, are a type of biological cell that can differentiate into other types of cells in the body.

Rate this question:
6.

(Asterisk) is used as the 'Multiplication operator' in MS Excel
- True
- False
Correct Answer

A. True

Explanation

In MS Excel, the asterisk symbol (*) is indeed used as the multiplication operator. This means that when you want to multiply two or more numbers together in a formula, you would use the asterisk symbol between them. For example, if you want to multiply the numbers in cell A1 and A2, you would write the formula "=A1*A2". Therefore, the statement "Asterisk is used as the 'Multiplication operator' in MS Excel" is true.

Rate this question:
7.

A formula result is in cell C6. You wonder how you got the result. To see the formula, you:
- Click in cell C6, and then press CTRL+SHIFT.
- Click in cell C6, and then press CTRL+SHIFT.
- Click in cell C6.
- Non of the above
Correct Answer

A. Click in cell C6.

Explanation

To see the formula in cell C6, you simply need to click on the cell C6. This will highlight the cell and display the formula in the formula bar at the top of the Excel window. Pressing CTRL+SHIFT is not necessary in this case.

Rate this question:

1
8.

I plays na important role in performing any calculation, for any formula or as logical operator in excel. Who am i.. (used symbol not word)

Correct Answer
=

Explanation
The symbol "=" is used as an assignment operator in Excel. It is used to perform calculations and formulas, as well as to compare values and determine logical outcomes. It is an important symbol in Excel as it allows users to input formulas and equations to perform calculations and manipulate data.

Rate this question:
9.

I am result of adding two or more numbers. Who am i?

Correct Answer
Sum

Explanation
The given correct answer for this question is "Sum". The term "sum" refers to the result obtained by adding two or more numbers together. It is a mathematical operation that involves combining the values of different numbers to find their total. In this context, "sum" accurately describes the outcome of adding numbers, making it the correct answer.

Rate this question:

1
10.

Quotient is the product of the sum of two numbers
- True
- False
Correct Answer

A. False

Explanation

The given statement "Quotient is the product of the sum of two numbers" is false. The quotient is actually the result of dividing one number by another. It is not related to the product or the sum of two numbers.

Rate this question:
11.

=A1-B2= Difference
- True
- False
Correct Answer

A. True

Explanation

The given statement "A1-B2 = Difference" is true. In mathematics, the symbol "-" represents subtraction. Therefore, subtracting the value of B2 from A1 will give us the difference between the two values.

Rate this question:
12.

Which one do you like?
- Option 1
- Option 2
- Option 3
- Option 4
Correct Answer

A. Option 1
13.

When you start Excel, you open a file that's called a workbook. Each new workbook comes with_____________ worksheet(s), like pages in a document. You enter data into the worksheets. (Worksheets are sometimes called spreadsheets.)
- 1
- 2
- 3
- 4
Correct Answer

A. 1

Explanation

When you start Excel, you open a file that's called a workbook. Each new workbook comes with 1 worksheet, like pages in a document. You enter data into the worksheets. (Worksheets are sometimes called spreadsheets.)

Rate this question:

1
14.

A1:20 defines as the range of the value of A1:A20
- True
- False
Correct Answer

A. True

Explanation

The statement is true because it states that A1:20 defines the range of values from A1 to A20. This means that the range includes all the values from A1 to A20, indicating that A1:20 is a valid range.

Rate this question:

1
15.

To divide 853 by 16 in a formula in Excel, you would use what math operator?

Correct Answer
/

Explanation
To divide 853 by 16 in a formula in Excel, you would use the forward slash (/) math operator. The forward slash is the division operator in Excel and is used to perform division calculations. By using the forward slash in the formula, Excel will divide the value 853 by the value 16 and provide the result.

Rate this question:
16.

Product is the sum of two numbers
- True
- False
Correct Answer

A. False

Explanation

The statement "Product is the sum of two numbers" is incorrect. A product is the result of multiplying two or more numbers, while a sum is the result of adding two or more numbers. Therefore, the correct answer is False.

Rate this question:
17.

In MS Excel +,-,*,/ are called Mathematical operation while Addition, Subtraction, Multiplication, Division are called Symbols
- True
- False
Correct Answer

A. False

Explanation

The given statement is false. In MS Excel, +, -, *, / are not called Mathematical operations, but rather they are symbols used to represent mathematical operations. Addition, Subtraction, Multiplication, and Division are the actual mathematical operations that these symbols represent.

Rate this question:

1
18.

RESULT ARE THE NUMBERS ENTERED IN A CELL?
- True
- False
Correct Answer

A. False

Explanation

The given answer is False because the statement "RESULT ARE THE NUMBERS ENTERED IN A CELL?" is grammatically incorrect and does not make sense. It seems like there might be a typographical error or missing information in the question. Without proper context or clarification, it is not possible to determine the correct answer.

Rate this question:
19.

In MS Excel, A Data is an equation that calculates a new value from values currently in a worksheet
- True
- False
Correct Answer

A. False

Explanation

In MS Excel, a formula is an equation that calculates a new value from values currently in a worksheet. A data, on the other hand, refers to the values or information that is entered into the cells of a worksheet. Therefore, the statement that a data is an equation is incorrect.

Rate this question:
20.

A1=10 B2=20 C3=30 BASED ON THE GIVEN DATA. USING THE MS EXCEL A1+B2=30? THE EXPRESSION IS TRUE?
- True
- False
Correct Answer

A. False

Explanation

The expression A1+B2=30 is false because A1 is equal to 10 and B2 is equal to 20. Therefore, when you add them together, the result is 30, not equal to 30.

Rate this question:

1

Quiz Review Timeline (Updated): Jan 3, 2024 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Jan 03, 2024

Quiz Edited by
ProProfs Editorial Team
Mar 09, 2021

Quiz Created by
Themes

How Well Do You Know MS Excel?

You can use Excel to create budgets, to work with taxes, or to record student grades

Quiz Preview

_, and _ are what you see when you open Excel

___________ are where you get down to business and enter data in a worksheet.

Numbers and Letters are called Data

The cell in the worksheet in which you can type data is called the stem cells.

(Asterisk) is used as the 'Multiplication operator' in MS Excel

A formula result is in cell C6. You wonder how you got the result. To see the formula, you:

I plays na important role in performing any calculation, for any formula or as logical operator in excel. Who am i.. (used symbol not word)

I am result of adding two or more numbers. Who am i?

Quotient is the product of the sum of two numbers

=A1-B2= Difference

Which one do you like?

When you start Excel, you open a file that's called a workbook. Each new workbook comes with_____________ worksheet(s), like pages in a document. You enter data into the worksheets. (Worksheets are sometimes called spreadsheets.)

A1:20 defines as the range of the value of A1:A20

To divide 853 by 16 in a formula in Excel, you would use what math operator?

Product is the sum of two numbers

In MS Excel +,-,*,/ are called Mathematical operation while Addition, Subtraction, Multiplication, Division are called Symbols

RESULT ARE THE NUMBERS ENTERED IN A CELL?

In MS Excel, A Data is an equation that calculates a new value from values currently in a worksheet

A1=10 B2=20 C3=30 BASED ON THE GIVEN DATA. USING THE MS EXCEL A1+B2=30? THE EXPRESSION IS TRUE?