Introduction To Microsoft Excel. practice test with complete verified solutions 2024

Title Bar A bar at the top of the window that shows the name of the document , program name, and the control buttons. Office Button A button to the left side of the window, which opens a menu of basic commands used in many Microsoft office programs, such as new, open,save and print. Brainpower Read More Previous Play Next Rewind 10 seconds Move forward 10 seconds Unmute 0:00 / 0:00 Full screen Quick Access Toolbar A set of commands that are used often, such as save and undo. You can add commands to the Quick Access Toolbar to customize it for your own use. Ribbon A band that contains a set of tabs including home,insert, page, layout, formulas, data, review, and view. Name Box A box that shows the name of the active cell. Tab A part of the ribbon used to organize commands that do similar types of activities. For Example, the insert tab has commands that add objects to the worksheets Help A box at the top right corner of the window that gives help with program. Answers are listed when a questions is entered into the box. Group A collection of commands on a tab that do similar actions, For Example, the Alignment group contains commands that change the placement of text in a cell such as left, center, scroll bar. Scroll Bars Bars used to change the part of the worksheet shown in a window. The worksheet can be moved up or down using the vertical scroll bar, or to the left and right using the horizontal scroll bar. Sheet tab A tab at the bottom corner of the window that changes the active worksheet. Formula Bar A bar that lets you insert or edit the contents of a cell. Command A button menu, or box that tells the program to do a task. A command often has a picture that shows the action. For Example, the cut command look like a pair of scissors. Window Controls Controls at the top right corner of the program window that let you minimize, maximize/ restore or close the program window. Status Bar A strip along the bottom of the screen used to display worksheet information. it can be customize to show data including the sum, average, of count of cells. Format painter A command used to copy formatting from one cell to another. Autosum A function in Microsoft Excel that automatically determines the total of a selected row or column AutoFill A feature in Microsoft Excel that completes a series by filling a cell with information the series may be text, numbers, or a formula. Formula A set of symbols, numbers and words that are used to tell the computer what mathematical calculation to perform. Range Any group of two or more cells Legend A box that identifies the patterns or colors that are assigned to the data series or categories in a chart. Merged Cell A single cell that is created by combing two or more selected cells. The cell reference for a merged cell is the upper-left cell in the original selected range. Paste Area The target destination for data that's been cut or copied by using the Office Clipboard. Read-Only A setting that allows a file to be read or copied but not changed or saved. Wrap In text, to break a line of text automatically on reaching a margin or object and continue the text on a new line.