In E7, type respectively the following: equal symbol, number 3, the plus sign, number 5, and then press the ENTER key. The result will show in the cell as 8.
True or False: A1+A2/4 is the same as (A1+A2)/4. (If false, what is the difference)
The first will do A2/4 and then add A1. The second will do A1+A2 and then divide that sum by 4
What do B, I and U do in MS Excel?
The can Bold, Italicize or Underline text.
What does C1 mean in Excel?
Cell C1 or Column C, Row 1
In MS Excel, what is the difference between 7+3 and =7+3?
7+3 will return back (7+3) and =7+3 will return back 10
What type of graph is best to display the parts of a whole?
Pie Chart
List 3 functions or formulas we have learned in Excel.
MAX, MIN, AVERAGE, IF, COUNT, SUM
What will MAX(A2:A9) do in Excel?
It will return back MAX(A2:A9) because we forgot an equal sign.
What is the difference between =average(A1,E1) and =average (A1:E1)?
The first will give only the average of those two cells whereas the second will give the average of the range of cells.
Which of the following represents a cell in MS Excel? 1C5, 15C, A15, CC, AA
A15 is a cell. A cell has the column before the row.
What is the difference between "Portrait Orientation" and "Landscape Orientation"?
Landscape images are captured in a horizontal layout while portrait images are captured in a vertical layout.
What is a range of cells?
It is a group of cells in a particular row or column.
True or False: MS Excel is a workbook
TRUE
What is wrong with the following IF statement? =IF(B2<3, "Good work","Amazing Work)
We are missing the " after Amazing work
Your experience on this site will be improved by allowing cookies.