spreadsheets Flashcards
1
Q
what is the IF formula?
A
=IF(CR>CR, “…”, “…”)
2
Q
what is the COUNTIF formula?
A
=COUNTIF(CR:CR, “…”)
3
Q
what is a formula in excel?
A
A formula is an equation that makes calculations based on the data in your spreadsheet
4
Q
what are cell references?
A
cell references are the vertical columns that are marked by a letter and horizontal rows that are marked by a number, which are used to navigate a cell in order to use a formula on it