Microsoft Excel Vocabulary Quiz: 6th Grade!

1. A cell is ...

Part of your genetic makeup

A phone

"boxes" within the spreedsheet that organized by colmns and rows can contain words, numbers, or formulas

The correct answer is the description that mentions "boxes" within a spreadsheet that are organized by columns and rows and can contain words, numbers, or formulas. This accurately describes what a cell is in the context of a spreadsheet.

Explanation

The correct answer is the description that mentions "boxes" within a spreadsheet that are organized by columns and rows and can contain words, numbers, or formulas. This accurately describes what a cell is in the context of a spreadsheet.

2. A formula ...

Performs operations on worksheet data

Food for babies

A math operation

The correct answer is "performs operations on worksheet data". This answer is supported by the fact that a formula in the context of a worksheet is used to perform calculations or operations on the data entered into the worksheet. It is a tool that allows users to manipulate and analyze the data in order to obtain desired results or insights. Therefore, this answer accurately describes the purpose and functionality of a formula in the context of a worksheet.

Explanation

The correct answer is "performs operations on worksheet data". This answer is supported by the fact that a formula in the context of a worksheet is used to perform calculations or operations on the data entered into the worksheet. It is a tool that allows users to manipulate and analyze the data in order to obtain desired results or insights. Therefore, this answer accurately describes the purpose and functionality of a formula in the context of a worksheet.

3. Active Cell is:

Something that is alive

The cell you are currently in

A color cell

The active cell refers to the cell that is currently selected or highlighted in a spreadsheet or worksheet. It is the cell where any data input or formatting changes will be applied. This cell is typically indicated by a bold outline or a different color to distinguish it from the other cells.

Explanation

The active cell refers to the cell that is currently selected or highlighted in a spreadsheet or worksheet. It is the cell where any data input or formatting changes will be applied. This cell is typically indicated by a bold outline or a different color to distinguish it from the other cells.

4. A workbook is:

An excel file

A book you carry around

A folder

A workbook refers to an excel file that contains multiple worksheets. In Excel, a workbook is a file that can hold various types of data, such as numbers, text, and formulas. It allows users to organize and analyze data by creating different worksheets within the same file. Each worksheet can have its own set of data and calculations, making it a convenient tool for data management and analysis. Therefore, the correct answer is "an excel file".

Explanation

A workbook refers to an excel file that contains multiple worksheets. In Excel, a workbook is a file that can hold various types of data, such as numbers, text, and formulas. It allows users to organize and analyze data by creating different worksheets within the same file. Each worksheet can have its own set of data and calculations, making it a convenient tool for data management and analysis. Therefore, the correct answer is "an excel file".

5. What is a row?

Go horizontally with numeric headings

Go vertically with letter heading

Something you can use to write on

A row refers to a horizontal arrangement of data in a table or spreadsheet. It is organized with numeric headings, allowing for easy identification and categorization of information. This format is commonly used in databases and spreadsheets to organize and display data in a structured manner.

Explanation

A row refers to a horizontal arrangement of data in a table or spreadsheet. It is organized with numeric headings, allowing for easy identification and categorization of information. This format is commonly used in databases and spreadsheets to organize and display data in a structured manner.

6. Worksheet is:

Piece of paper

Made up of cells similar to the individual sheets of paper in a notebook

A file

A worksheet is made up of cells similar to the individual sheets of paper in a notebook. This means that a worksheet consists of a grid-like structure, with each cell functioning as a separate unit where data can be entered and manipulated. Just like how each sheet of paper in a notebook can be used to write or draw something different, each cell in a worksheet can contain different types of data or perform different calculations. This allows for organizing and analyzing data in a structured and organized manner, similar to how one would use individual sheets of paper in a notebook.

Explanation

A worksheet is made up of cells similar to the individual sheets of paper in a notebook. This means that a worksheet consists of a grid-like structure, with each cell functioning as a separate unit where data can be entered and manipulated. Just like how each sheet of paper in a notebook can be used to write or draw something different, each cell in a worksheet can contain different types of data or perform different calculations. This allows for organizing and analyzing data in a structured and organized manner, similar to how one would use individual sheets of paper in a notebook.

7. Select the correct function to add amounts in an excel worksheet.

Autosum

Cut

Past

Graph

Autosum is the correct function to add amounts in an excel worksheet. This function automatically calculates the sum of a selected range of cells and inserts the total in the cell where the function is applied. It is a quick and efficient way to add up values in a column or row without manually entering the formula.

Explanation

Autosum is the correct function to add amounts in an excel worksheet. This function automatically calculates the sum of a selected range of cells and inserts the total in the cell where the function is applied. It is a quick and efficient way to add up values in a column or row without manually entering the formula.

8. How can you print only the part of the document you need in a workbook?

Copy and paste

Using select area print function

Print

Using the autosum fuction

To print only the part of the document you need in a workbook, you can use the select area print function. This allows you to select a specific range or area of the document that you want to print, rather than printing the entire workbook. By selecting the desired area, you can ensure that only the necessary information is printed, saving paper and ink.

Explanation

To print only the part of the document you need in a workbook, you can use the select area print function. This allows you to select a specific range or area of the document that you want to print, rather than printing the entire workbook. By selecting the desired area, you can ensure that only the necessary information is printed, saving paper and ink.