DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Where can you find the command for Excel to calculate the MAX value into cell G2?
|
|
by selecting the AutoSum button (∑) at the top left of the ribbon
|
|
|
by selecting the Insert function (ꝭꭓ) at the top right of the ribbon
|
|
|
by right-clicking in cell G2 beneath Max in cell G1
|
|
|
by selecting the arrow under the AutoSum button (∑) at the top left of the ribbon
|
Explanation:
Detailed explanation-1: -If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
Detailed explanation-2: -Answer: Cell A2 contains the value 8 and cell B2 is empty. Cells can be merged and unmerged. Although you can’t split a single cell, you can make it appear like it has been split by combining the cells above it.
There is 1 question to complete.