FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
This button looks like the letter “E” and will add a group of numbers.
A
autofill
B
autosum
C
autocomplete
D
autodrag
Explanation: 

Detailed explanation-1: -AutoSum is in two locations: Home > AutoSum, and Formulas > AutoSum. Once you create a formula, you can copy it to other cells instead of typing it over and over.

Detailed explanation-2: -The symbol “Ʃ” indicates the auto sum in MS Excel. Excel automatically enters a formula to sum the numbers while using the Auto sum. The AutoSum button is available in the ‘Home’ tab on the excel ribbon. It is also available in the ‘Formulas’ tab on the excel ribbon.

Detailed explanation-3: -The correct answer is option 1, i.e. The AutoSum button.

Detailed explanation-4: -Excel has a built-in function called Exp() dedicated to calculations involving Euler’s number. Simply put the EXP(x) function returns the value of e raised to the power of ‘x’. Here, ‘x’ can be a simple number like 5 or 9 or even a complex formula like y+5.

There is 1 question to complete.
Previous
Next