Microsoft Office 2013: Excel 101 Quiz!

1. The first cell in EXCEL worksheet is labeled as:

AA

A1

Aa

A0

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.

Explanation

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.

2. A __________ is a grid with labeled columns and rows.

Dialog box

Worksheet

Clipboard

Toolbar

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.

Explanation

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.

3. In help menu of Excel, which of the following tabs are found?

Contents tab

Answer Wizard tab

Index tab

All of the above

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".

Explanation

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".

4. What are the tabs that appear at the bottom of each workbook called?

Reference tabs

Position tabs

Location tabs

Sheet tabs

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.

Explanation

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.

5. In Excel, the Fill Color button on the Formatting toolbar is used for what?

To insert a background.

To add borders.

To select a distribution of figures.

To add shading or color to a cell range.

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.

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.

6. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

Logical

Math & Trigonometry

Statistical

Financial

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.

Explanation

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.

7. What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)

An absolute cell address is created.

Cell address will change when it is copied to another cell.

The sheet tab is changed.

The status bar does not display the cell address.

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.

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.

8. In Excel, a Data Series is defined as what?

A type of chart

A cell reference

A collection of related data

A division of results

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.

Explanation

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.

9. The active cell:

Is defined by a bold border around the cell

Receives the data user enters

It is the formula bar

Receives data user enters & defined by a bold border around the cell

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.

Explanation

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.

10. What is represented by the small, black square in the lower-right corner of an active cell or range?

Copy handle

Fill handle

Insert handle

Border

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.

Explanation

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.