Question

what are ways to enter a formula in excel? check all that apply.
click on the function library group and select a function from the drop-down menu.
click on the function library group and insert function.
click on the file tab in the ribbon.
click on the insert tab in the ribbon and then equation.
type = into any cell.
click on the formula bar above the cells.

Explanation:

• "Click on the Function Library group and select a function from the drop - down menu": The Function Library in Excel's ribbon (under the Formulas tab) has various functions that can be used to enter formulas. Selecting a function from its drop - down menu is a valid way to start a formula.
• "Click on the Function Library group and Insert Function": The Insert Function option in the Function Library allows you to search for and insert a specific function, which is a way to enter a formula.
• "Type = into any cell": In Excel, starting a cell entry with an equal sign indicates that you are entering a formula.
• "Click on the formula bar above the cells": The formula bar is where you can enter or edit formulas. Clicking on it allows you to input a formula.

The "Click on the File tab in the ribbon" is for file - related operations like opening, saving, etc., not for entering formulas. The "Click on the Insert tab in the ribbon and then Equation" is for inserting mathematical equations (like in Word) and not for Excel formulas.

Answer:

A. Click on the Function Library group and select a function from the drop - down menu.
B. Click on the Function Library group and Insert Function.
E. Type = into any cell.
F. Click on the formula bar above the cells.