MS Excel Basics Quiz Questions And Answers
(159).jpg "MS Excel Basics Quiz Questions And Answers - Quiz")
.
Questions and Answers
- 1.
_______, ________ and _______ are what you see when you open Excel
- A.
Columns, rows, and charts
- B.
Columns, rows, and formulas
- C.
Columns, rows, and cells
- D.
Non of the above
Correct Answer
C. Columns, rows, and cellsExplanation
When you open Excel, you will see columns, rows, and cells. Columns are the vertical sections labeled with letters, rows are the horizontal sections labeled with numbers, and cells are the individual rectangular boxes formed by the intersection of columns and rows. These elements are the basic building blocks of an Excel spreadsheet and allow you to organize and input data in a structured manner.Rate this question:
-
- 2.
Ribbon is MS Excel is
- A.
Commands organized in small related groups is called Ribbon
- B.
The band at the top of the Excel 2007 window is the Ribbon
- C.
All of the above
- D.
Non of the above
Correct Answer
B. The band at the top of the Excel 2007 window is the RibbonExplanation
The correct answer is "The band at the top of the Excel 2007 window is the Ribbon." This statement accurately describes the Ribbon in MS Excel as the band located at the top of the Excel 2007 window. It is where commands are organized in small related groups, allowing users to easily access and navigate through different features and functionalities in Excel.Rate this question:
-
- 3.
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.)
- A.
One
- B.
Two
- C.
Three
- D.
Four
Correct Answer
C. ThreeExplanation
When you start Excel, you open a file that's called a workbook. Each new workbook comes with three worksheet(s), like pages in a document. You enter data into the worksheets. (Worksheets are sometimes called spreadsheets.)Rate this question:
-
- 4.
___________ are where you get down to business and enter data in a worksheet.
- A.
Cells
- B.
Fields
- C.
Tables
- D.
None of the above
Correct Answer
A. CellsExplanation
Cells are where you get down to business and enter data in a worksheet. In a spreadsheet program like Microsoft Excel, a cell is a basic unit of a worksheet that is used to store and manipulate data. It is identified by a unique combination of a column letter and a row number. Cells allow you to input text, numbers, formulas, and perform various calculations. They are the building blocks of a worksheet and are essential for organizing and analyzing data.Rate this question:
-
- 5.
In a new worksheet, you must start by typing in cell A1.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
In a new worksheet, you are not required to start by typing in cell A1. You can start typing in any cell of your choice.Rate this question:
-
- 6.
You can use Excel to create budgets, to work with taxes, or to record student grades
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Excel is a powerful tool that can be used for various purposes, including creating budgets, working with taxes, and recording student grades. It provides features such as formulas, functions, and formatting options that make it easy to organize and analyze data. By using Excel, users can create and manage budgets, calculate taxes, and track student grades efficiently. Therefore, the statement "You can use Excel to create budgets, to work with taxes, or to record student grades" is true.Rate this question:
-
- 7.
You can enter two basic kinds of data into worksheet cells:
- A.
Numbers and text
- B.
Numbers and figures
- C.
Text and charts
- D.
None of the above
Correct Answer
A. Numbers and textExplanation
In a worksheet, you can enter two basic kinds of data: numbers and text. Numbers can be used for calculations and mathematical operations, while text can be used for labels, descriptions, or any non-numeric information. This allows for a versatile and comprehensive representation of data in the worksheet.Rate this question:
-
- 8.
To enter a date in a cell, you should use a slash or a hyphen to separate the parts: 7/16/2009 or 16-July-2009. Excel will recognize this as a text
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
When entering a date in a cell in Excel, you should use a slash or a hyphen to separate the parts. For example, 7/16/2009 or 16-July-2009. Excel will recognize this as a date value, not as text. Therefore, the correct answer is False.Rate this question:
-
- 9.
You learned in the practice that ###### means:
- A.
You've entered a number wrong
- B.
You've misspelled something
- C.
The cell is not wide enough
Correct Answer
C. The cell is not wide enoughExplanation
The correct answer is "The cell is not wide enough." This means that when entering data into a cell in a spreadsheet or table, the width of the cell is not sufficient to display the entire content. This can result in the data being cut off or displayed in a way that is not fully visible. To fix this issue, the cell width needs to be adjusted to accommodate the content.Rate this question:
-
- 10.
What do you type into an empty cell to start a formula?
- A.
An equal sign (=)
- B.
A plus sign (+)
- C.
Number
- D.
Fx
Correct Answer
A. An equal sign (=)Explanation
To start a formula in an empty cell, you need to type an equal sign (=). This is because the equal sign is used to indicate that the cell will contain a formula and not just a regular value. By typing the equal sign, you are telling the spreadsheet software that you want to perform a calculation or use a function in that cell.Rate this question:
-
- 11.
A formula result is in cell C6. You wonder how you got the result. To see the formula, you:
- A.
Click in cell C6, and then press CTRL+SHIFT.
- B.
Click in cell C6, and then press CTRL+SHIFT.
- C.
Click in cell C6.
- D.
Non of the above
Correct Answer
C. Click in cell C6.Explanation
Clicking in cell C6 allows you to select the cell and view its contents, including any formula that may be present. This will allow you to see the formula that was used to calculate the result in cell C6.Rate this question:
-
- 12.
To divide 853 by 16 in a formula in Excel, you would use what math operator?
- A.
+
- B.
=
- C.
%
- D.
/
Correct Answer
D. /Explanation
To divide 853 by 16 in a formula in Excel, you would use the "/" math operator. The "/" operator is used for division in Excel formulas.Rate this question:
-
- 13.
Cell Reference:A10,A20Refer to values in
- A.
The cell in column A and row 10
- B.
Cell A10 and cell A20
- C.
The range of cells in column A and rows 10 through 20
- D.
The range of cells in row 15 and columns B through E
Correct Answer
B. Cell A10 and cell A20Explanation
The correct answer is "cell A10 and cell A20." This is because the cell reference "A10" refers to the specific cell in column A and row 10, and the cell reference "A20" refers to the specific cell in column A and row 20. Therefore, the answer is that the cell reference refers to both cell A10 and cell A20.Rate this question:
-
- 14.
A10:A20Refer to values in
- A.
The cell in column A and row 10
- B.
Cell A10 and cell A20
- C.
The range of cells in column A and rows 10 through 20
- D.
The range of cells in row 15 and columns B through E
Correct Answer
C. The range of cells in column A and rows 10 through 20Explanation
The correct answer is "the range of cells in column A and rows 10 through 20". This answer indicates that the reference A10:A20 refers to a range of cells in column A, specifically from row 10 to row 20.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 22, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 04, 2010Quiz Created by
Agazaheer
Back to top