Consider supporting us on Patreon. Help us keep revisedeck free.
Question 13
Question 13 of 14

Question image for Q13
Topics Tested

Designing and creating an appropriate data entry form, including appropriate: font styles and sizes, spacing between fields, object width and height to display data, use of white space, radio buttons, drop-down menus, highlighting key fields, form controls, linked subforms

Using functions that: perform calculations, for example: SUM, AVERAGE, MIN, MAX, MAXA, INT, ROUND, SUBTOTAL; count the number of cells that meet a criterion, for example: COUNT, COUNTIF, COUNTIFS, COUNTA, COUNTBLANK; look up data, for example: LOOKUP, VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH; make decisions based on certain criteria, for example: IF, IFS, nested IF, AND, OR; insert, extract and calculate with date and time, for example: DATE, TIME, WEEKDAY, DAY, MONTH, YEAR