excel

In Excel, you can change the color of data and objects. When you opt to change a color, Excel presents you with a color gallery that has three categories: Theme Colors, Standard Colors, and More Colors. This section will provide you with an overview of color options. In the next two sections, you will learn how to change the

When creating an Excel worksheet, you can emphasize the content in cells by bolding, italicizing, and/or underlining. The underline option on the Excel Ribbon offers two options: Underline and Double Underline. The Format Cells dialog box offers two additional options: Single Accounting and Double Accounting. The following image illustrates the difference between an Underline and a

In Excel, you can change the size of a font. For example, you can increase the size to make a portion of your worksheet stand out or you can decrease the size so that more data fits on a printed page. Fonts are measured in points. A point is 1/72 of an inch, which means

A font is a collection of characters that all have the same basic design. Fonts are used to print text to various output devices and to display text on screen. When you begin a new Excel workbook, you are using the default theme’s body font. You can change the font by clicking the down-arrow next

In this lesson, I am going to show you how to format. I will define what a font is and show you how to change the font, the font size, and the font color. I will also show you how to bold, underline, italicize, add shading, add borders, superscript, subscript, and strikethrough. You should know

The MIN function finds the lowest number. It can include up to 255 argumentsArguments are the values you provide a function with so that it can perform a calculation. Functions start with a name and are followed by parentheses. Arguments are enclosed within the parentheses and are separated by commas.. Each argument can be a number, a name,

The MAX function finds the highest number. It can include up to 255 argumentsArguments are the values you provide a function with so that it can perform a calculation.. Each argument can be a number, a name, an array, a formula, a logical value, a function, a referenceA reference is a cell address, a range, a

The AVERAGE function calculates the average. It can include up to 255 arguments. An argument can be a number, a name, an array, a formula, a logical value, a function, a reference, or a text representation of a number. Syntax:                 AVERAGE(argument1, argument2, …) When you use the AVERAGE function, Excel calculates the SUM and then

The COUNT function counts the number of numbers. It can include up to 255 arguments. Each argument can be an empty argument, a number, a name, an array, a formula, a logical value, a function, a reference, or a text representation of a number. Syntax: COUNT(argument1, argument2, …) The first argument is required; all other

The SUM function adds. It can include up to 255 . An argument can be a number, a name, an array, a formula, a logical value, a function, or Syntax: SUM(argument1, argument2, …) When you use the SUM function, Excel adds the results of each of the arguments together and returns the result. When using