Spreadsheets - MS Excel

Question 1

What is the ‘not equal to’ relational operator in Excel?

Answer 1

<> (!= in Python)

Question 2

What are ALL the built in functions ?

Answer 2

=MIN
=MAX
=AVERAGE
=SUM
=SUMIF
=COUNT
=COUNTA
=COUNTIF
=PMT
=VLOOKUP
= HLOOKUP

Question 3

How would you reference another cell from worksheet “INTEREST” ?

Answer 3

=INTEREST!A4

or in general terms:

worksheet_name!cell_reference

Question 4

How can you differentiate between text and numbers in Excel?

Answer 4

Numbers are stored right justified.

Text is stored left justified.