# Understanding Excel Formulas and Functions

### Understanding Excel Formulas and Functions

**Session 1.1 Quick Check1.**

**How are chart sheets different from worksheets?**

A chart sheet only contains a chart that is linked to a given set of data within a workbook. It contains other graphical elements such as clip art, though it does not contain a grid for entering data values. A worksheet, on the other hand, contains a grid of rows and columns into the user can enter dates, numbers, formulas, and texts. It can contain graphical elements like clip art, maps, and charts.

**What is the cell reference for the cell located in the third column and fourth row of a worksheet?**

C4

Each cell is is identified by a cell reference,which indicates the column and row in which the cell is located.

**What is the range reference for the block of cells D3 through E10?**

D3:E10

**What is the ranger reference for cells A1 through C5 and cells A8 through C12?.**

A1:C5, A8:C12

**How is text aligned within a worksheet cell by default?**

By default,text is left-aligned within worksheet cells,and numbers,dates,and times are right-aligned.

**How would the number 00514 appear in a cell?**

514

**Cell B2 contains the entry of May 3, 2021. Why doesn’t Excel consider this a text entry?**

Excel stores dates and times as numbers and not as text. In this case, it stores the date as a number equal to the number of days between May 3, 2021 and January 0, 1900.

**How do you autofit a column to match its longest cell entry?**

To autofit a column to match its longest cell entry, double-click the right boarder of the column heading. Next, click the AutoFit Column Width to resize the columns so that all content is fully displayed.

**What is the formula to add values in cells A1, B1, and C1? What function will achieve the same result?**

Formula to add values in cells A1, B1, and C1 is **=A1+B1+C1**

Function that will achieve the same result is **= SUM (A1:C1)**

**What is the formula to count the number of numeric values in the range A1: A30?**

- =COUNT(A1:A30)

**Cell E11 contains the formula =SUM(E1:E10). How is the formula adjusted when a new row is inserted above row 5**?

H4

**In the following function, which arguments are required and which arguments are optional:**

**AVERAGE (number1 , [number2] , [number3] , …)**

Number 1 is a required argument; number2, number3… are optional arguments

**What is the formula to sum all the numeric values in column C.**

=Sum (C:C)

**Describe the four ways of viewing worksheet contents in Excel.**

**Normal view**: This shows the columns and rows of the worksheet.

**Page Layout view**: Shows the worksheet as it appears on a printed page.

**Page Break Preview**: Shows the location of different page breaks within the worksheet.

**Formula view**: Displays the formulas contained in the worksheet instead of the values they return.

**How are page breaks indicated in Page Break Preview?**

Page breaks are indicated using blue dotted lines.

**Greetings! Our experts have completed this assignment in the past. They will provide you with a fresh solution to this question within your preferred deadline. Be assured of high quality, plagiarism free (with free Turnitin report), and well formatted paper worthy of the highest distinction.**