Microsoft Office 2013: Excel 101 Quiz!
(130).jpg "Microsoft Office 2013: Excel 101 Quiz! - Quiz")
Welcome to this short yet important Microsoft Office 2013 quiz on Excel. Here, you will be asked ten fundamental questions of this application just to test your basic understanding of the same. Let's see if you can pass all the questions without getting a single one wrong or not.
- 1.
The first cell in EXCEL worksheet is labeled as:
- A.
AA
- B.
A1
- C.
Aa
- D.
A0
Correct Answer
B. A1Explanation
The first cell in an Excel worksheet is labeled as A1 because the letters represent the column and the number represents the row. In Excel, columns are labeled with letters starting from A and going up to Z, then continuing with AA, AB, AC, and so on. Rows are labeled with numbers starting from 1 and going up as the number of rows increase. Therefore, the first cell in the worksheet is labeled as A1 to indicate it is in the first column and first row.Rate this question:
-
- 2.
What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)
- A.
An absolute cell address is created.
- B.
Cell address will change when it is copied to another cell.
- C.
The sheet tab is changed.
- D.
The status bar does not display the cell address.
Correct Answer
A. An absolute cell address is created.Explanation
When dollar signs ($) are entered in a cell address, it creates an absolute cell address. This means that the cell reference will not change when it is copied to another cell. Absolute cell references are useful when you want to keep a specific cell reference constant, such as when creating formulas that need to refer to a specific cell regardless of where it is copied.Rate this question:
-
- 3.
What are the tabs that appear at the bottom of each workbook called?
- A.
Reference tabs
- B.
Position tabs
- C.
Location tabs
- D.
Sheet tabs
Correct Answer
D. Sheet tabsExplanation
The tabs that appear at the bottom of each workbook are called sheet tabs. These tabs allow users to navigate between different sheets or worksheets within the workbook. Each sheet tab typically displays the name of the sheet, making it easier for users to locate and access specific sheets within the workbook.Rate this question:
-
- 4.
What is represented by the small, black square in the lower-right corner of an active cell or range?
- A.
Copy handle
- B.
Fill handle
- C.
Insert handle
- D.
Border
Correct Answer
B. Fill handleExplanation
The small, black square in the lower-right corner of an active cell or range is known as the fill handle. It is used to quickly fill adjacent cells with a series, such as numbers or dates, based on the pattern of the selected cells. By dragging the fill handle, the pattern is extended to the desired range of cells, saving time and effort in data entry.Rate this question:
-
- 5.
In Excel, a Data Series is defined as what?
- A.
A type of chart
- B.
A cell reference
- C.
A collection of related data
- D.
A division of results
Correct Answer
C. A collection of related dataExplanation
A Data Series in Excel refers to a collection of related data. It is used to organize and analyze data that is related or connected in some way. This can include a series of numbers, dates, or any other type of data that is related and needs to be grouped together for analysis or presentation purposes.Rate this question:
-
- 6.
In Excel, the Fill Color button on the Formatting toolbar is used for what?
- A.
To insert a background.
- B.
To add borders.
- C.
To select a distribution of figures.
- D.
To add shading or color to a cell range.
Correct Answer
D. To add shading or color to a cell range.Explanation
The Fill Color button on the Formatting toolbar in Excel is used to add shading or color to a cell range. This allows users to visually differentiate and highlight specific cells or ranges within their worksheet. By selecting a particular color or shade, users can enhance the readability and organization of their data, making it easier to interpret and analyze.Rate this question:
-
- 7.
In help menu of Excel, which of the following tabs are found?
- A.
Contents tab
- B.
Answer Wizard tab
- C.
Index tab
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
The help menu of Excel includes all of the mentioned tabs: Contents tab, Answer Wizard tab, and Index tab. These tabs provide different ways for users to access and search for information and assistance in using Excel. The Contents tab allows users to browse through different topics and subtopics in a hierarchical manner. The Answer Wizard tab provides a search feature that helps users find answers to specific questions or issues. The Index tab allows users to search for specific keywords or terms to find relevant information. Therefore, the correct answer is "all of the above".Rate this question:
-
- 8.
A __________ is a grid with labeled columns and rows.
- A.
Dialog box
- B.
Worksheet
- C.
Clipboard
- D.
Toolbar
Correct Answer
B. WorksheetExplanation
A worksheet is a grid with labeled columns and rows. It is commonly used in spreadsheet software such as Microsoft Excel to organize and analyze data. The columns are labeled with letters (A, B, C, etc.) and the rows are labeled with numbers (1, 2, 3, etc.). This grid structure allows users to input and manipulate data in a structured manner, perform calculations, and create charts and graphs based on the data.Rate this question:
-
- 9.
The active cell:
- A.
Is defined by a bold border around the cell
- B.
Receives the data user enters
- C.
It is the formula bar
- D.
Receives data user enters & defined by a bold border around the cell
Correct Answer
D. Receives data user enters & defined by a bold border around the cellExplanation
The active cell is the cell in a spreadsheet that is currently selected or highlighted. It is where the user can enter data or perform actions such as formatting or applying formulas. The active cell is visually indicated by a bold border around the cell.Rate this question:
-
- 10.
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
- A.
Logical
- B.
Math & Trigonometry
- C.
Statistical
- D.
Financial
Correct Answer
D. FinancialExplanation
The correct answer is Financial. The Financial function in Excel is used to calculate various financial calculations such as depreciation, rates of return, future values, and loan payment amounts. This function is commonly used in financial analysis and planning to make informed decisions regarding investments, loans, and savings.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 -
Oct 24, 2010Quiz Created by
Mcqquestions
Back to top