Question

B. Answer the following questions.
1. Compare formulas and functions.
2. How do you use a simple filter on data?
3. Which tab and group contain the commands for changing around the font attributes?
4. How do you save a spreadsheet in one of its various possible formats?​

Answer 1

Answer:

here are your answers

Explanation:

ans1) So in summary, a formula is any calculation in Excel, but a function is a pre-defined calculation. =MAX(A1:B20) is a formula containing a function. Mastering the use of functions in formulas is a key skill in learning financial modelling. Happy formula-writing!

ans2) To filter data

1: Begin with a worksheet that identifies each column using a header row. ...

2:Select the Data tab, then locate the Sort & Filter group.

3:Click the Filter command. ...

4:Drop-down arrows will appear in the header of each column.

5:Click the drop-down arrow for the column you want to filter. ...

6:The Filter menu appears.

Answer3) HOME TAB

Home tab: The Home tab is the default tab in Microsoft Word. It has five groups of related commands; Clipboard, Font, Paragraph, Styles, and Editing. It helps you change document settings like font size, adding bullets, adjusting styles, and many other common features.

Answer4) Save a workbook in another file format

1: Open the workbook you want to save.

2:Click File > Save As.

3:Under Places, pick the place where you want to save the workbook. ...

4:In the Save As dialog box, navigate to the location you want.

5:In the Save as type list, click the file format you want.

I AM DONE WITH YOUR ALL THE ANSWERS.. I HOPE THESE ANSWERS HELPED TOU.. I AM DOING IT SINCE 5 TO 10 MINUTES.. SO PLEASE MARK ME AS BRAINLIEST AS I HAVE DONE A VERY HARDWORKING JOB