IT's All About Excel Basics Quiz

1. The address of this cell is __________________.

The correct answer is B6 because it is the address of the cell being referred to. In spreadsheet programs, cells are identified by a combination of a letter representing the column and a number representing the row, and in this case, the cell is located in column B and row 6.

Explanation

The correct answer is B6 because it is the address of the cell being referred to. In spreadsheet programs, cells are identified by a combination of a letter representing the column and a number representing the row, and in this case, the cell is located in column B and row 6.

Submit

2. This is the ____ button.

This is the button used for automatically calculating the sum of a range of cells in a spreadsheet. It simplifies the process of adding up numbers by automatically selecting the range and inserting the sum formula.

Explanation

This is the button used for automatically calculating the sum of a range of cells in a spreadsheet. It simplifies the process of adding up numbers by automatically selecting the range and inserting the sum formula.

Submit

3. How do you know a range is active?

It is highlighted on the screen.

It has a marquee around it.

The data changes to Bold to let me know it's active

I'm psychic & I just Know!!

The correct answer is "It is highlighted on the screen." When a range is active, it is visually distinguished from other ranges on the screen by being highlighted. This visual indicator helps the user identify which range they are currently working with or manipulating.

Explanation

The correct answer is "It is highlighted on the screen." When a range is active, it is visually distinguished from other ranges on the screen by being highlighted. This visual indicator helps the user identify which range they are currently working with or manipulating.

4. Microsift Excel is called the __________ application.

Microsoft Excel is referred to as the "spreadsheet" application because it is primarily used for creating, organizing, and analyzing data in a tabular format. It provides a grid-like interface where users can input and manipulate data, perform calculations, create charts and graphs, and automate tasks using formulas and functions. Excel's functionality and features make it a powerful tool for managing and presenting numerical information, making it the go-to application for spreadsheet-related tasks.

Explanation

Microsoft Excel is referred to as the "spreadsheet" application because it is primarily used for creating, organizing, and analyzing data in a tabular format. It provides a grid-like interface where users can input and manipulate data, perform calculations, create charts and graphs, and automate tasks using formulas and functions. Excel's functionality and features make it a powerful tool for managing and presenting numerical information, making it the go-to application for spreadsheet-related tasks.

Submit

5. A_______ is a group of cells that form a rectangle on the screen.

Worksheet

Label

Range

Rank

A range is a group of cells that form a rectangle on the screen. It represents a collection of cells that can be selected, manipulated, and used in formulas or functions. A range can be a single cell or a group of adjacent or non-adjacent cells. It is commonly used in spreadsheet applications like Microsoft Excel to perform calculations, analyze data, and create charts or graphs.

Explanation

A range is a group of cells that form a rectangle on the screen. It represents a collection of cells that can be selected, manipulated, and used in formulas or functions. A range can be a single cell or a group of adjacent or non-adjacent cells. It is commonly used in spreadsheet applications like Microsoft Excel to perform calculations, analyze data, and create charts or graphs.

6. If you type in 4/13 in a cell and then press Enter, MS Excel will automatically change it to _______________.

When you enter the fraction 4/13 in a cell and press Enter in MS Excel, it will automatically change it to the date format "13-Apr". The program recognizes the fraction as a date and converts it accordingly. The format "13-Apr" represents the day (13) and the abbreviated month (Apr).

Explanation

When you enter the fraction 4/13 in a cell and press Enter in MS Excel, it will automatically change it to the date format "13-Apr". The program recognizes the fraction as a date and converts it accordingly. The format "13-Apr" represents the day (13) and the abbreviated month (Apr).

Submit

7. You calculated the sum of numbers in cells B1 to B12. What will the content bar (the formula bar) show you?

The content bar (formula bar) will show the formula "=SUM(B1:B12)". This formula calculates the sum of the numbers in cells B1 to B12.

Explanation

The content bar (formula bar) will show the formula "=SUM(B1:B12)". This formula calculates the sum of the numbers in cells B1 to B12.

Submit

8. Numbers are aligned at the ________ edge of the cell.

Left

Right

Numbers are aligned at the right edge of the cell.

Explanation

Numbers are aligned at the right edge of the cell.

9. You can arrange data in a column with the help of _____________ button.

The correct answer is "Sort and filter" or "Sort & filter". This button allows you to arrange data in a column in a specific order, either alphabetically or numerically, and also provides the option to filter data based on certain criteria. By using this button, you can easily organize and analyze your data in a more structured and meaningful way.

Explanation

The correct answer is "Sort and filter" or "Sort & filter". This button allows you to arrange data in a column in a specific order, either alphabetically or numerically, and also provides the option to filter data based on certain criteria. By using this button, you can easily organize and analyze your data in a more structured and meaningful way.

Submit

10. The three basic parts of a spreadsheet are columns, ____________ and __________.

In a spreadsheet, data is organized in a grid-like structure. The columns run vertically from top to bottom, representing different categories or types of information. The rows run horizontally from left to right, representing individual records or entries. Cells are the individual boxes within the grid where data can be entered or calculated. Therefore, the correct answer is rows, cells.

Explanation

In a spreadsheet, data is organized in a grid-like structure. The columns run vertically from top to bottom, representing different categories or types of information. The rows run horizontally from left to right, representing individual records or entries. Cells are the individual boxes within the grid where data can be entered or calculated. Therefore, the correct answer is rows, cells.

Submit