Sues 5 Define the fallowing terms-
al Workbook
ob Workshet
co/Data Validation
(di
Cell Referenc
(el IF Function
Answers
Answer:
workbook
a single file containing several different types of related information as separate worksheets.
data validation
data validation is the process of ensuring data has undergone data cleaning to ensure they have data quality that is if they are both correct and useful.
cell reference
a cell reference refers to a cell or range of cells on a worksheet and can be used in a formula so that Microsoft office Excel can find the values or data that you want that formula to calculate.
Answer:
a single file containing several different types of related information as separate worksheets is known as workbook
The term Worksheet used in Excel documents is a collection of cells organized in rows and columns. It is the working surface you interact with to enter data. Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.
In computer science, data validation is the process of ensuring data has undergone data cleansing to ensure they have data quality, that is, that they are both correct and useful.
A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. In one or several formulas, you can use a cell reference to refer to: ... Data on other worksheets in the same workbook.
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.