MS Excel Components, Commands, and Functions for Accounting

Vocabulary flashcards covering core concepts, interface components, functions, and commands of MS Excel based on the lecture notes.

Microsoft Excel

An office program developed by Microsoft Corporation used to create spreadsheets, designed to help users quickly find commands needed to complete tasks.

Workbook

The file created by Microsoft Excel to store user data.

Worksheet Dimensions

In Excel 2010, a grid consisting of 1,048,576 rows (numbered 1 through 1,048,576) and 16,384 columns (labeled A through XFD).

Cell

The box formed by the intersection of a row and a column, identified by its address consisting of a column letter and row number.

Ribbon

The area located below the Title bar that displays a set of task-specific tabs containing commands across the top.

File Tab

Displays the Backstage view containing commands related to managing files and customizing the program, replacing the Microsoft Office button and File menu.

Home Tab

The active tab by default in Excel, containing basic Clipboard, formatting, style, row/column insertion/deletion, and worksheet editing commands.

Insert Tab

Contains commands related to all elements and items that can be inserted into a worksheet.

Page Layout Tab

Contains commands affecting the overall appearance of a worksheet, including settings for printing.

Formula Tab

Contains commands used to insert formulas, name cells or ranges, audit formulas, or control calculation performance in Excel.

Data Tab

Contains data-related commands in Excel, including tools for sorting, filtering, text-to-columns, and data validation.

Review Tab

Contains commands used to check spelling, translate words, add comments, or protect worksheets.

View Tab

Contains commands that control various aspects of how a worksheet is displayed and viewed on screen.

Relative Reference

A cell reference that automatically adjusts its row or column reference based on the formula's new location when copied.

Absolute Reference

A cell reference that remains fixed and unchanged when copied to another cell, indicated using a dollar sign or by pressing F4.

CONCATENATE Function

A text function that joins several text strings into one single text string; syntax is CONCATENATE(text1, text2, …).

LEFT Function

A text function that returns the specified number of characters from the left side of a text string; syntax is LEFT(text, num_chars).

RIGHT Function

A text function that returns the specified number of characters from the right side of a text string; syntax is RIGHT(text, num_chars).

IF Function

A logical function that checks whether a condition is met, returning one value if TRUE and another value if FALSE; syntax is IF(logical_test, value_if_true, value_if_false).

IFERROR Function

A logical function that returns a specified value if an expression evaluates to an error, and returns the result of the expression otherwise; syntax is IFERROR(value, value_if_error).

VLOOKUP Function

A lookup function that searches for a value in the leftmost column of a table and returns a value in the same row from a specified column; syntax is VLOOKUP(lookup_value, table_array, col_index_num, range_lookup).

SUMIF Function

A math function that adds the cells specified by a given condition or criteria; syntax is SUMIF(range, criteria, sum_range).

COUNTIF Function

A math function that counts the number of cells within a range that meet a given condition; syntax is COUNTIF(range, criteria).

Quick Access Toolbar

A customizable toolbar located at the left end of the Title bar that defaults to displaying the Save, Undo, and Redo buttons.

Conditional Formatting

An Excel feature used to identify patterns and trends by automatically applying cell formatting (such as fills, font colors, icons, or data bars) based on rules.

Pivot Table

A powerful and flexible method available in Excel used for data analysis, summarization, and synthesis.

Text to Columns

An Excel command used to separate or split the contents of cells into individual separate columns based on delimiters or width.

Data Validation

An Excel feature used to control and limit the specific data or values that can be entered into a cell by users.