In MS-Excel value used in a formula that does not change is called a

The next line in MS-Excel below the toolbar area is called?

Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used with only two columns in the array.
 

What function will produce results that indicate whether a student has passed or failed a course by enter the text "Pass" or "Fail"?

You can select the current row in MS-Excel Worksheet by pressing?

When you insert an Excel file into a Word document, the data are

Shows the values on the chart. Excels creates a range of values based on the data

Which function is used to return the number of cells in a range that meet a condition set forth in the formula?

What type of chart is useful for showing trends or changes over time

Which would you choose to create a bar diagram?

You can merge the main document with data source in Excel. In mail merge operation, Word is usually

What is the keyboard shortcut for creating a chart from the selected cell range?

Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

We can check the conditions against __________ when applying conditional formatting

What do you call the chart that slows the proportions of how one or more data elements relate to another data element.

Which function returns the current date?

This is an optional for the chart’s categories

You can select the current Column in MS-Excel Worksheet by pressing?

What type of chart will you use to compare performance of sales of two products?

This is created from the row or columns headings in the data. A category describes what is shown in the chart

All worksheet formula

What type of chart is good for single series of data?

A function inside other function is called

A features that displays only the data in column (s) according to specified criteria

which element of a worksheet can be protected from accidental modification

You want to track the progress of the stock market on a daily basis. Which type of chart you use?

Comments put in cells are called?

Getting data from a cell located in a different worksheet is called?

Advanced Functions are used in higher-level operations such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections.
 

The NOW function calculates the difference in days between two dates.