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
20
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.
25
What type of graph is best to display the parts of a whole?
Pie Chart
5
What is wrong with the following IF statement? =IF(B2<3, "Good work","Amazing Work)
We are missing the " after Amazing work
25
What do B, I and U do in MS Excel?
The can Bold, Italicize or Underline text.
10
Describe how to do 3+5 in Column E, Row 7.
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.
25
True or False: MS Excel is a workbook
TRUE
5
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
20
What is a range of cells?
It is a group of cells in a particular row or column.
15
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.
20
List 3 functions or formulas we have learned in Excel.
MAX, MIN, AVERAGE, IF, COUNT, SUM
10
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.
15
What will MAX(A2:A9) do in Excel?
It will return back MAX(A2:A9) because we forgot an equal sign.