Microsoft Excel Computer Applications Review

Comprehensive Question and Answer flashcards covering Microsoft Excel core concepts, interface features, formatting tools, formulas, functions, charts, tables, and shortcut keys.

What is a workbook in Microsoft Excel?

A workbook refers to the entire Excel file, which contains one or more worksheets (or sheets).

Which default shortcuts are located on the Quick Access Toolbar in Microsoft Excel?

Save, Undo, and Redo.

In the Microsoft Excel interface, what main components are labeled in the blank worksheet view below?

The labeled components are the File tab, The ribbon, Tell me box, File name, Columns, Formula bar, Window controls, Rows, Cell, Sheet tab, and Status bar.

How can you search for a command or open help topics directly in Excel using the keyboard?

Click the Tell Me box or press Alt+Q and type a word or phrase related to your task.

What keyboard shortcuts move the insertion point to the first cell or the last cell containing data in a worksheet?

Ctrl+Home moves to the first cell (A1), and Ctrl+End moves to the last cell with data.

In spreadsheet planning, how should data generally be organized between rows and columns?

Columns are typically used for grouping categories of data, while rows are used for singular individual items.

What is the difference between a label and a value in Excel?

A label is text used for descriptions and is not used in calculations, whereas a value is numeric data that can be used in calculations.

What symbol is displayed across a cell when a numeric value is too wide to fit within the column width?

Pound signs (#####).

How can you automatically fit a column width to match its longest entry?

Double-click the column boundary line at the top of the worksheet between the column letters.

What is the function of the F2 key when a cell is selected?

It places the insertion point inside the active cell to allow editing of its existing contents.

What is the procedure to insert a new row above a selected row in Excel?

Right-click the row number and click Insert, or select the row and press Ctrl+Shift+Equal Sign (+).

What is the difference between Clear Formats and Clear Content in the Home tab Editing group?

Clear Formats removes only the visual styling associated with the cells while retaining the data, whereas Clear Content removes the data or formulas inside the cells while retaining the formatting.

What does the RIGHT function do in Microsoft Excel?

It returns the specified number of characters from the end (right side) of a text string.

What is the purpose of the CONCAT function in Excel?

It joins text strings from multiple cells into a single combined cell.

What mathematical statement symbol must begin every formula in Microsoft Excel?

An equal sign (=).

According to Excel's order of operations, in what sequence are mathematical operators evaluated?

Exponentiation (^) is evaluated first, followed by multiplication (*) and division (/), and finally addition (+) and subtraction (-).

What error code is displayed when a formula attempts to divide a value by zero?

DIV/0!

What keyboard shortcut toggles between displaying calculated cell values and displaying the underlying formulas across a worksheet?

Show Formulas on the Formulas tab, or pressing Ctrl+backtick (Ctrl+`).

What is a relative cell reference, and how does it behave when copied?

A relative cell reference automatically adjusts its row and column references relative to the new cell position where the formula is pasted or dragged.

How is an absolute cell reference formatted in Excel, and what key creates it automatically?

It uses dollar signs before the column letter and row number (such as $B$2), created by pressing the F4 key when selecting or typing the cell reference.

What is the difference between the COUNT and COUNTA functions in Excel?

COUNT returns the number of cells in a range that contain numeric values, while COUNTA counts all non-empty cells in a range regardless of whether they contain text, numbers, logical values, or errors.

What arguments are required in the syntax of an IF function?

The IF function takes the form =IF(logical_test, value_if_true, value_if_false).

What are Sparklines in Microsoft Excel?

Sparklines are tiny charts placed inside single cells that visually display data trends alongside worksheet values.

What is a PivotTable in Excel?

A PivotTable is an interactive tool created from a dataset or table used to analyze, summarize, and aggregate complex data.

What is the purpose of adding alternative text (alt text) to shapes, charts, or images in Excel?

Alt text provides concise written descriptions of visual objects so that screen readers can read them aloud to assist users with visual impairments.