Introduction to Excel
A spreadsheet program used to record and analyze numerical and statistical data and provides multiple features to perform various operations like calculations, pivot tables, graph tools, macro programming, etc. It is compatible with multiple OS like Windows, macOS, Android and iOS?
Microsoft Excel
What is the short cut key to edit a cell?
F2
What is the operator or formula that we should use when looking for the average numerical value in a cell?
Average
What does VLOOKUP stand for?
Vertical lookup
The point where a column and a row meet
cell
What is the shout cut key to go to the Data tab?
Alt+A
In general what symbol do we start with before typing an operator or formula?
= or the equal sign
What is the function of the number 50 in the formula below
=VLOOKUP(C2,Lookup!B:AY,50,FALSE)
Column Number
A collection of columns and rows that form a table or range where alphabetical letters are usually assigned to columns, and numbers are usually assigned to rows.
Spreadsheet
What is the short cut key to add a cell, column or row?
Ctrl++
What is the function of the range A2 to A8 on the formula below.
=SUMIF(A2:A8,“*Approved*", C2:C8)
Range or location for the condition.
In what direction in the lookup range should the look up value be in?
LEFT
A file that contains one or more worksheets to help you organize data
Workbook
What is the short cut key to freeze the top row on a sheet?
Alt+W+F+R
What outcome will this formula give.
" =AVERAGEIF(A2:A8,“<>Approved“, C2:C8)"
Averages a range that does not contain the condition "Approved" indicated by the symbol <> or not equal to , “<>Approved“.
What is the outcome if the return value is set to true?
Return value is an approximate.
What is a group of cells within a row or column?
Range or Table
What is the short cut key to expand a drop down?
Alt+Down Arrow
COUNTA stands for?
Count All
What formula or operator can be used to eliminate errors on your return value if lookup can not be located?
IFERROR