Excel Functions and Formulas

Which of the following are considered basic Excel terms?

• Column, Row, Cell, and Range

• Worksheet, Workbook, Chart, and Table

• Function, Argument, Syntax, and Output

• Header, Footer, Margin, and Orientation

A vertical stack of cells in Excel is known as a:

• Row

• Cell

• Column

• Range

How is an individual cell in Excel typically named?

• By combining its column letter and row number

• By its unique numerical ID

• By its content type (e.g., Text, Number)

• By its position relative to the active cell

What is the correct general format for an Excel formula?

• Formula_Name(Arguments)=

• Formula_Name=(Arguments)

• =Formula_Name(Arguments)

• (Arguments)Formula_Name=

What is the primary function of the SUMIF formula in Excel?

• To add up all numerical values in a specified range.

• To count the number of cells that meet a specific condition.

• To add up values selectively based on a given condition.

• To calculate the average of values that satisfy multiple criteria.

What is the primary purpose of the IF formula in Excel?

• To sum values based on a condition.

• To return one value if a condition is true, and another if it's false.

• To count the number of cells that meet a criterion.

• To look up values in a table.

How many inputs does a simple IF formula take inside its parentheses?

• One

• Two

• Three

• Four

What is the main function of the VLOOKUP formula in Excel?

• To perform mathematical calculations on a range of cells.

• To sort data in ascending or descending order.

• To find and match values between two separate lists or tables.

• To create charts and graphs from data.

How many inputs does the VLOOKUP formula typically take inside its parentheses?

• Two

• Three

• Four

• Five

What is the purpose of the CONCATENATE formula in Excel, and how can you add a space between joined texts?

• To sum numbers; by using a plus sign.

• To combine text from multiple cells; by inserting " " (space in quotes) as an argument.

• To find specific text within a cell; by using a wildcard character.

• To convert text to numbers; by changing the cell format.