[go: up one dir, main page]
Scribd
Upload
19 views2 pages

ICT Unit 8.5 Keywords

Conditional formatting, named cell ranges, and data modeling are techniques for organizing and presenting information in a spreadsheet. Functions like IF, LOOKUP, VLOOKUP, and validation checks help ensure data integrity by testing values or conditions. Sorting, filtering, and macros allow automation of common tasks.

Uploaded by

Megan Phuar May Jun
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
19 views2 pages

ICT Unit 8.5 Keywords

Conditional formatting, named cell ranges, and data modeling are techniques for organizing and presenting information in a spreadsheet. Functions like IF, LOOKUP, VLOOKUP, and validation checks help ensure data integrity by testing values or conditions. Sorting, filtering, and macros allow automation of common tasks.

Uploaded by

Megan Phuar May Jun
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

absolute cell conditional named cell range: data modelling: using

reference: a cell deformatting: giving one cell or a set mathematical


reference that applying formatting of cells a name; the functions and
remains constant even such as colour to a cell cells can be referred calculations on data to
if it is copied to other based on certain to using the name predict or model what
cells criteria assigned may happen in the
event of certain
changes
IF statement: a lookup statement : nested IF statement: presence check: a
statement which Used to search an IF statement which validation check which
evaluates a condition through a table of is embedded in is used to ensure that
and places one value data for a value and another IF statement there is a value
in the cell if the then return results if entered. A length
condition is true and that value is found check can be used to
another value in the do this; for example, a
cell if the condition is check to ensure that
false the value entered has
at least one character

length check: a range check: a type check: a sort: to change the


validation check which validation check which validation check which order of data; for
is used to ensure that is used to ensure that is used to ensure that example, data can be
the value entered has the value entered lies the value entered is of sorted in alphabetical
a particular number of within a given range; a certain data type; order or numerically
characters; for for example, 1-100 for example, a check
example, a check to to ensure data is
ensure that a name numeric
has at least five
characters
filter: A spreadsheet macro: a small data validation: the input message: a user
feature which allows program which is used process of checking defined message
the user to apply to automate a task data entered to which will appear
certain criteria and ensure that it is when the user is
exclude or show acceptable entering data into a
certain data cell

error alert: a user 100 named cell: a name selling price: the price cost price: the price at
defined message that given to an individual at which a product is which a product is
will appear when the cell in a spreadsheet sold to customers bought by the store
user enters data that owner
breaks the validation
rule
built-in functions: arguments: values Vertical Lookup VLOOKUP: makes use
functions that exist that are passed to the (VLOOKUP) table: a of a lookup table of
within the software function in the table in a spreadsheet data to match the
for use by the user brackets that follow which is be used to contents of a cell with
the function name; lookup a value and a value in the lookup
these values are used return data to a cell in table
within the function the spreadsheet

lookup value: the table array: the set of column index num:
value used to search data that will be the column number of
through the lookup searched using the the data that will be
table lookup value returned if there is a
match for the lookup
value in the table
array

You might also like