Basic Excel Functions
What is excel used for`?
For creating spreadsheets(only this counts as an right answer.!!)
What does the IF function return if the logical test is false?
The value specified for false.
Which tool in Excel allows you to filter data in columns?
Filter.
What feature allows you to change the background color of a cell?
Fill Color
Which chart type is best for showing parts of a whole?
Pie Chart
Which function finds the average of a group of numbers?
AVERAGE
Which formula checks if a value in cell A1 is greater than 50 and returns "Pass" if true and "Fail" if false?
=IF(A1 > 50, "Pass", "Fail")
What tool in Excel automatically adjusts the width of columns to fit the data?
Auto Fit.
What formatting option changes how numbers are displayed, such as adding dollar signs or decimals?
Number Formatting.
What chart type is typically used to compare values across categories?
Bar Chart or Column Chart
Which function counts the number of cells that contain numbers?
Count
True or False: You can only nest two IF functions in Excel.
False. You can nest up to 64 IF functions in a formula.
Which tool lets you remove duplicate values from a list in Excel?
Remove Duplicates
What feature combines multiple cells into one large cell?
Merge & Center
What kind of chart is ideal for showing trends over time?
Line Chart
What is the first step when we want to call a function?
Start with = Sign
What would the formula =IF(A1 > 50, "Pass", IF(A1 < 30, "Fail", "Retake")) return if A1 equals 40?
"Retake"
A small red triangle or purple in the upper right corner of a cell
Comment indicator
What allows you to align text to the center of a cell?
Center Alignment
Which chart combines both lines and bars to represent data?
Combo Chart
What function adds all the numbers in a range of cells?
SUM
What is the purpose of the IF function in Excel?
The IF function checks if a condition is met and returns one value if true and another if false.
What tool allows you to create charts and graphs in Excel?
Chart Wizard or Insert Chart
What is a nested IF function in Excel?
A nested IF function is when one IF function is placed inside another to test multiple conditions.
What file format does Excel use?
Microsoft Excel Open XML Format Spreadsheet file. (xlsx)