Subtract the numbers from A1 to A5

Free Excel Functions Questions and Answers — Questions and Answers

Question 1: Excel formulae all start with the same symbol.

+ (Correct answer)
%
#

Correct 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

Group
Reference
Range (Correct answer)
Package

Correct answer: Range

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 ___.

Piece of graph paper
Excel file
A single page in a workbook (Correct answer)
All of the above

Correct answer: A single page in a workbook

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?

=B2+C3 (Correct answer)
=6+4
=C3+B3
=B+C

Correct answer: =B2+C3

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?

=IF(condition, condition if false, condition if true)
=IF(condition:condition if true:condition if false)
=IF(condition, condition if true, condition if false) (Correct answer)
None of these

Correct answer: =IF(condition, condition if true, condition if false)

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.

Question 6: This is an equation.

=SUM(A1:A5) (Correct answer)
Subtract the numbers from A1 to A5
Add A1 - A5
A1 = A5

Correct answer: =SUM(A1:A5)

In Excel, an equation or formula always starts with an equals sign (=). '=SUM(A1:A5)' is a valid Excel formula that uses the SUM function to add up all the numerical values within the range of cells from A1 to A5. This is a common and correct way to perform calculations in a spreadsheet.

Question 7: Which view of a worksheet displays the worksheet's header and footer sections?

Normal view
Page break preview
Page layout view (Correct answer)
Header/Footer

Correct answer: Page layout view

Page Layout view in Excel is specifically designed to show how a worksheet will look when printed, including margins, headers, and footers. This view allows users to easily add, edit, and preview these elements directly on the page. It provides a 'what you see is what you get' perspective for print preparation.

Question 8: The purpose of the word "=SUM" at the start of an Excel spreadsheet formula is

To add all the data together using addition only. (Correct answer)
To tell the person viewing that this is a function and it should be added together.
To calculate all the data correctly without any mistakes.
To inform the computer that an arithmetic function will occur.

Correct answer: To add all the data together using addition only.

The 'SUM' function in Excel is specifically designed to calculate the total of a range of numbers. When used in a formula like '=SUM(A1:A5)', it instructs Excel to add up all the numerical values within the specified range. This is a fundamental function for aggregation and basic arithmetic in spreadsheets.

Question 9: Which of the following calculations uses an Excel spreadsheet the most frequently?

Data
Numbers
Finances
All of the above (Correct answer)

Correct answer: All of the above

Excel spreadsheets are versatile tools used across various domains. They are extensively used for managing and analyzing data, performing complex numerical calculations, and particularly for financial modeling, budgeting, and accounting. Therefore, all these applications represent frequent and core uses of Excel.

Question 10: Cell addresses are used in formulas as:

Formularizing
Cell referencing (Correct answer)
Prefixing
Cell mathematics

Correct answer: Cell referencing

When you use a cell address (like A1, B5, or C10) within an Excel formula, you are performing 'cell referencing.' This means the formula will use the value currently stored in that specific cell to perform its calculation. Cell referencing is crucial for creating dynamic and interconnected spreadsheets, allowing formulas to update automatically when referenced cell values change.

Question 11: Which function is capable of displaying various values according to various conditions?

TEST
AVERAGE
IF (Correct answer)
CONDITION

Correct answer: IF

The IF function is Excel's primary tool for conditional logic. It allows you to specify a condition and then return one value if that condition is true, and a different value if the condition is false. This enables the spreadsheet to display different outputs based on varying criteria, making it highly flexible for decision-making.

Question 12: What are the parenthesis for in an Excel formula like =(A1+A2)*B1?

They indicate the order in which operations should be performed. (Correct answer)
They make the formula easier to read.
They tell Excel to ignore the values in cells A1 and A2.
They are not necessary and can be omitted.

Correct answer: They indicate the order in which operations should be performed.

In Excel formulas, just like in standard mathematics, parentheses are used to define the order of operations. Operations within parentheses are calculated first. In the example '=(A1+A2)*B1', the sum of A1 and A2 is calculated before the result is multiplied by B1, ensuring the correct mathematical sequence and precedence.

Question 13: What VLOOKUP function is using the right arguments out of the following list?

=VLOOKUP(G5, Products!$A$2:$C$20, 3, FALSE) (Correct answer)
=VLOOKUP(G5, 3, FALSE)
=VLOOKUP(Products!$A$2:$C$20, G5, 3, FALSE)
=VLOOKUP(G5=3, TRUE, FALSE)

Correct answer: =VLOOKUP(G5, Products!$A$2:$C$20, 3, FALSE)

The VLOOKUP function has a specific syntax: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). Option A correctly provides all four arguments: G5 as the lookup value, Products!$A$2:$C$20 as the table array (with absolute references for stability), 3 as the column index from which to return a value, and FALSE for an exact match. This structure is essential for accurate data retrieval.

Question 14: What is the purpose of data validation? Please check all that apply.

Prevent inconsistent data from being entered (Correct answer)
Add a drop-down list to a cell (Correct answer)
Control what values a user can enter into a cell (Correct answer)
Apply colors and formatting depending on cell values

Correct answer: Prevent inconsistent data from being entered

Data validation in Excel is a powerful feature used to control and restrict the type of data or values that users can enter into a cell. It helps maintain data integrity by preventing inconsistent entries, can be used to create drop-down lists for predefined choices, and generally ensures that data adheres to specified rules, thereby improving accuracy and consistency. Applying colors and formatting based on cell values is Conditional Formatting, not Data Validation.

Question 15: What is the Excel formula for summing a column of numbers?

=TOTAL(A1:A10)
=SUM(A1:A10) (Correct answer)
=COLUMN(A1:A10)
=ADD(A1:A10)

Correct answer: =SUM(A1:A10)

The `SUM` function is the standard Excel formula used to add up a range of numbers. By specifying a range like `A1:A10`, the function calculates the total of all values within those cells. Options like `TOTAL` or `ADD` are not valid Excel functions for this purpose.

Question 16: What kind of cell reference does Excel use by default?

Relative (Correct answer)
Absolute
Mixed
Constant

Correct answer: Relative

Excel uses relative cell references by default, meaning that when a formula is copied or filled to other cells, the cell references within the formula automatically adjust based on their new position. This dynamic adjustment is fundamental to Excel's efficiency, allowing formulas to be easily applied across rows or columns without manual modification.

Free Excel Functions Questions and Answers

Excel formulae all start with the same symbol.