EXCEL - A
What is the name of an Excel "Document"
What is Workbook?
When a formula is an active cell, the underlying formula is visible in the
What is the formula bar?
All formulas should start with?
What is = (equal)?
A function that returns the Largest value in a range of cellls.
What is MAX?
Two or more cells in a worksheet.
What is a range?
What is the name of a "Page" in Excel
What is a Worksheet?
The box that identifies the patterns or colors assigned to the data series.
What is a legend ?
A function used to find the smallest value in a range of cells.
What is MIN?
An inactive tab color displays this way in the worksheet
What is a solid tab color?
Column headings in Excel are identified by
What are Letters (of the alphabet)?
What combination keys do you hit on the keyboard that shows the formula
What is Control (CTRL) Tilde?
If I wanted to add shading to a cell or range or headings to my table, what would I choose?
What is Cell Styles?
Method used to hide worksheets?
What is right-click a worksheet tab and then click Hide?
A formula reference that moves from one cell to another when copying or filling, what is that called?
What is relative cell reference?
Row headings in Excel are identified by.
What are numbers?
What Alignment do numbers appear in a cell?
What is Right?
What symbol is used between two cell references to indicate a range of cells?
What is Colon :
What is applied to a cell when the value of the cell meets a specific condition?
What is conditional Formatting?
If you see a reference such as $A$4, what is that called?
What is absolute cell reference (for A4)?
The serial number 1 when entered in a date will return the date of.
What is January 1, 1900?
If I made a cell Red, Bold and Center, and I then highlight another cell and presses F4, what would happen to the other Cell?
What is Center?
When working with long worksheets what must you use to be able to see the headings or columns as you scroll right or down?
What is Freeze Panes?
The IF function can have a maximum of how many argument(s)
What is 3?
The ______________ button is the arrow to the right of a header row label in a table
What is filter ?
When adding information through the ribbon of the header/footer toolbar. The computer will add information such as page number, date and time, file name, etc. what is this called?
What are field codes?