COMPUTER SOFTWARE
APPLICATION SOFTWARE
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
depicts data in graphical form
|
|
|
changes certain values to reveal the effects of the changes
|
|
|
is a predefined formula that performs common calculations
|
|
|
contains the formatting necessary for a specific worksheet type
|
Detailed explanation-1: -The correct answer is functions. A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.
Detailed explanation-2: -SUM functions. Probably the most frequently used function in Excel (or any other spreadsheet program), =SUM does just that: It sums a column, row, or range of numbers-but it doesn’t just sum.
Detailed explanation-3: -A spreadsheet is a computer program that can capture, display and manipulate data arranged in rows and columns. Spreadsheets are one of the most popular tools available with personal computers. A spreadsheet is generally designed to hold numerical data and short text strings.
Detailed explanation-4: -Excel has prewritten formulas called functions to help simplify making complicated calculations. A function takes a value or values, performs an operation, and returns a result to a cell. The values that you use with a function are called arguments.
Detailed explanation-5: -Overview of formulas in Excel. Article. XLOOKUP. Article. VLOOKUP. Article. SUM function. Article. COUNTIF function. Article. IF function. Article. IFS. Article. SUMIF. Article. More items