FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

WORKBOOK THEMES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A ____ is a prewritten formula that is built into Excel.
A
Worksheet
B
Function
C
Data
D
Value
Explanation: 

Detailed explanation-1: -A function is a prewritten formula that is built into Excel.

Detailed explanation-2: -A Formula is an equation designed by a user in Excel, while a Function is a predefined calculation in the spreadsheet application.

Detailed explanation-3: -The AutoSum button can be used only to create formulas with SUM. Flash fill provides suggestions for cell entries based on previously entered data. The weighted average inventory method results in inventory cost that fall between those arrived at through the use of LIFO and FIFO.

Detailed explanation-4: -Function is a predefined formula already available in Excel. Functions perform specific calculations in a particular order based on the specified values, called arguments, or parameters.

Detailed explanation-5: -Expert-Verified Answer One of the Excel built-in functions is the function SUM which, as its name suggests, computes sums of values in a range of cells.

There is 1 question to complete.
Previous
Next