Edit Game
Microsoft Excel
 Delete

Use commas to add multiple tags

 Private  Unlisted  Public




Delimiter between question and answer:

Tips:

  • No column headers.
  • Each line maps to a question.
  • If the delimiter is used in a question, the question should be surrounded by double quotes: "My, question","My, answer"
  • The first answer in the multiple choice question must be the correct answer.






 Save   14  Close
What will MAX(A2:A9) do in Excel?
It will return back MAX(A2:A9) because we forgot an equal sign.
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.
List 3 functions or formulas we have learned in Excel.
MAX, MIN, AVERAGE, IF, COUNT, SUM
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: 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
True or False: MS Excel is a workbook
TRUE
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.
What do B, I and U do in MS Excel?
The can Bold, Italicize or Underline text.
What is wrong with the following IF statement? =IF(B2<3, "Good work","Amazing Work)
We are missing the " after Amazing work
What type of graph is best to display the parts of a whole?
Pie Chart
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.
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 does C1 mean in Excel?
Cell C1 or Column C, Row 1