click below
click below
Normal Size Small Size show me how
Test 3 BCA 120
| Question | Answer |
|---|---|
| Is a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the web and access real time data from web sites. | Microsoft Excel 2007 |
| 4 Major parts of Excel are? | Workbooks, worksheets, charts, tables & web support |
| When the Excel program is started it creates a new? | Blank Workbook |
| Inside an excel workbook are? | Worksheets |
| When Excel opens a new workbook, how many worksheets does it have? | 3 |
| Each worksheet has a name that appears on the? | Sheet Tab |
| Help Button is located on? | The right side of the ribbon |
| The worksheet is organized into a rectangular grid containing? | Vertical Columns & Horizontal Rows |
| A column letter or heading identifies what? | Each column |
| A row number or heading is located? And identifies? | On the left side of the grid and identifies each row |
| The intersection of each column and row is called a? | Cell |
| The basic unit of a worksheet into which you enter data is a? | Cell |
| Each worksheet has__# of columns and ____# of rows | 16,384 & 1,048,576 |
| Each cell has a unique address called a____ which is the coordinates of the intersection of a? | Cell reference, column and row |
| A cell into which you can enter data is called an? | Active Cell |
| There are 3 ways 2 identify an active cell: | Heavy boarder surrounds the cell, the active cell reference shows in the name box, it is highlighted so it is easy to see which cell is active. |
| Horizontal and vertical lines on the worksheet are called? | Gridlines |
| Whenever the mouse is located in a cell, the shape appears as a? | Block Plus Sign |
| The mouse pointer turns into a block arrow sign whenever? | You move it to the outside of the worksheet or when you drag cell contents bt rows or columns. |
| It provides easy central access to the task you perform while creating a spreadsheet. (the control center) | Ribbon |
| The ribbon consists of? | Tabs, groups, and commands |
| The ____ tab is the primary tab, and it contains? | Home, groups with the more frequently used commands |
| Ribbon displays 7 top-level tabs which are? | Home, insert, page layout, formulas, data, review and view |
| The ribbon commands include? | Buttons, boxes and galleries |
| It is a set of choices, often graphical, arranged in a grid or in a list. | Gallery |
| It is a feature that allows you to point to a gallery choice and see if it affects the worksheet without actually selecting the choice. | Live Preview |
| The formula bar is located? | Below the ribbon |
| When you type words or numbers, excel displays the entry in the? | Formula Bar |
| It displays the active reference cells | Name Box |
| The name box is located? | Left side of the formula bar |
| It provides easy access to frequently used commands | Quick Access Toolbar |
| The Quick Access Toolbar contains 3 buttons which are? | Save, redo and undo |
| The Quick Access Toolbar is located above the ribbon, but can also be located? | Below the ribbon |
| The office button is located? | At the upper left corner of the window |
| The central location for managing and sharing workbooks is? | The Office Button |
| An alternate way of selecting a cell is to use the? | Arrow keys |
| A column letter above the grid is called the and identifies each column? | Column Heading |
| A row number on the left side of the grid that identifies each row. | Row Heading |
| Text is always entered into a cell to what position? | Left alignment |
| Is the small black square located in the lower-right corner of the heavy boarder around the active cell | Fill Handle |
| You do this to emphasize certain entries and make the worksheet easier to read and understand | Formatting |
| It defines the color of the characters. | Font Color |
| Involves creating a single cell by combining two or more selected cells. | Merging |
| It shows the actual formulas you have entered, rather than the resulting values | Formula Version |
| This inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths. | Comma Style |
| If you double click the sheet tabs you can do this? | Rename the worksheet |