required:please explain briefly no need long answer please 24) 1 , (00 marks) SE
ID: 3904271 • Letter: R
Question
required:please explain briefly
no need long answer please
Explanation / Answer
b)Answer:
Count Functions
This is perhaps the most commonly-used function in Excel. It lets you count the number of cells currently being used in a spreadsheet as well as the number of blank cells remaining in your spreadsheet's data range. There are five types of Count Functions in Excel:
IF functions:
This Excel function is used for testing whether certain conditions are true or false and helps in arriving at decisions in a spreadsheet. You can create nested IF Functions to make the functions more flexible, perform calculations, enter data or text, or to leave a cell blank when certain IF conditions are met.
DATE Functions
Another useful Excel function is the DATE Function which you can use to add the current time or day of the week to specific cells in your spreadsheet. There are two types of the DATE functions:
Logical Functions
To arrive at a decision when working on data to be added to the different cells in your spreadsheet, you can use the Excel logical functions. You can either use the IF, OR or AND logical functions to evaluate the mathematical expression on a cell.
Math Functions
To perform mathematical operations on your spreadsheet, you can use Excel math functions such as the SUM function, AutoSum, and SumIF. In addition, you can also use the Math Functions to produce a random set of numbers. These functions include:
Text Functions
For managing and manipulating text data in your spreadsheet, you can use Excel text functions. There are various types of text functions as well.
c)Answer:
There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant, no matter where they are copied
Relative references
By default, all cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2. Relative references are especially convenient whenever you need to repeat the same calculation across multiple rows or columns
Absolute references
There may be times when you do not want a cell reference to change when filling cells. Unlike relative references,absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant.
An absolute reference is designated in a formula by the addition of a dollar sign ($). It can precede the column reference, the row reference, or both
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.