Free Excel Functions Questions and Answers

Question 1

Excel formulae all start with the same symbol.

Accepted Answer

+

Answer

In Microsoft Excel, every formula must begin with an equals sign (=). This symbol signals to Excel that the cell contains a calculation or a function rather than just text or a numerical value. Without the equals sign, Excel would treat the input as plain text.

Question 2

A selection of several cells is referred to as a

Accepted Answer

Range

Answer

In Excel, a 'range' refers to a group of two or more cells that are selected or referenced together. Ranges can be contiguous (adjacent) or non-contiguous and are fundamental for applying functions, formatting, or performing calculations across multiple cells simultaneously. For example, A1:C5 denotes a range of cells.

Question 3

Worksheets are a type of ___.

Accepted Answer

A single page in a workbook

Answer

An Excel file is called a workbook, and within each workbook, there can be multiple individual 'worksheets' (also known as spreadsheets). Each worksheet is a grid of cells where data is entered and manipulated. This structure allows for organizing different sets of data or analyses within a single file.

Question 4

Which of the following formulas will add B2's value to C3's value?

Accepted Answer

=B2+C3

Answer

To perform an addition in Excel, you start with an equals sign (=) followed by the cell references you want to add, separated by a plus sign (+). Therefore, '=B2+C3' correctly instructs Excel to take the value from cell B2 and add it to the value from cell C3.

Question 5

Which of the following formulations for the IF function is correct?

Accepted Answer

=IF(condition, condition if true, condition if false)

Answer

The IF function in Excel evaluates a logical test (condition) and returns one value if the condition is true, and another value if the condition is false. Its correct syntax is =IF(condition, value_if_true, value_if_false). This structure allows for conditional logic within spreadsheets, making it a powerful tool for decision-making.

Excel Practice Test

Excel Practice Test

Free Excel Functions Questions and Answers