Explanation

A field is also known as a column

that stores the same type of data and hence can be called a category of data.

Explanation

A Workbook is a group of Worksheets.

A workbook is a file that contains one or more worksheets to help you organize data.

A workbook initially contains three worksheets, which are saved in a single file. 

1. Sheet1

2. Sheet2

3. Sheet3

Explanation

 An Excel macro is an action or a set of actions that can be recorded, named, saved and executed as many times as required and whenever desired.

By using macros, we are able to automate repetitive tasks associated with data manipulation and data reporting that must be accomplished repeatedly.

Explanation

Alternatively referred to as a column separator or row separator, Grid lines or gridlines are the light gray lines that divide each of the cells, rows, and columns in a spreadsheet.

Explanation

In Excel, a Data Series is defined as a collection of related data.

 Microsoft Excel features calculation or computation capabilities, graphing tools, pivot tables etc.

Explanation

A spreadsheet is a file that exists of cells in rows and columns and can help arrange, calculate and sort data.

Data in a spreadsheet can be numeric values, as well as text, formulas, references and functions.

Explanation

The formula tab allows you to select from over 300 Excel functions.

Explanation

Chart Wizard in Excel is used to apply different charts, which can be Column, Bar, Pie, Area, Line, etc.

Chart Wizard, which is now named as Chart in the new version of MS Office, is available in the insert menu tab.

****

RY17-012-23

Explanation

An apostrophe before a cell value forces Excel to interpret the value as text.

This is mostly useful for values that look like a number or date.

Explanation

The COUNT function in Excel is used to count only numeric values in a specified range.

It ignores text and blank cells.

Unlike COUNTA which counts all non-empty cells.