Microsoft Excel Vocabulary And Functions! Trivia Quiz

The term "cell address" refers to the specific location of a cell in a spreadsheet. It is a combination of the column letter and row number that uniquely identifies a cell. This address is used to reference and access the data or formula contained within that cell.

There are times when you need to compare values that are far away from each other. That's why it's an advantage to be able to split the screen in two vertically and/or horizontally and place the values close to each other on the screen. The split boxes help you do that easily.

The vertical divisions of a spreadsheet are called columns. Columns are used to organize and categorize data in a spreadsheet. Each column is identified by a letter at the top of the column, such as A, B, C, etc. Columns are used to input and manipulate data vertically in a spreadsheet, making it easier to analyze and calculate information.

The correct answer is "Sheet tab" because a sheet tab is a visual representation of a worksheet in a spreadsheet software. It allows users to easily navigate between different worksheets within a workbook. By clicking on a sheet tab, users can quickly access and view the content of a specific worksheet.

The correct answer is =If(). The IF function allows you to view different results based on a condition that is entered. It evaluates whether a condition is true or false and returns a specific value or performs a specific action accordingly. This function is commonly used in Excel to perform logical tests and make decisions based on the results.

The term "file" is used to refer to a saved workbook or worksheet in a computer system. It is a common way to store and organize data in a digital format. The other options, such as document, grid, and graph, do not specifically indicate the saved format of a workbook or worksheet. Therefore, "file" is the most appropriate and correct answer in this context.

This key does allow you to select multiple ranges of cells so that youu can apply some options to them or use them for a chart.

An absolute reference in a cell formula is a reference that does not change when the formula is copied to other cells. It always refers to the same cell or range of cells, regardless of where it is copied. This is useful when you want to keep a specific cell or range constant in a formula, such as when calculating a percentage based on a fixed value.

Solver is there to help you optimize your model to achieve it's greatest possible value.

This function is used when you want to make sure that many conditions are fulfilled before showing a #TRUE# result.