Each Excel file is a ______ containing a collection of worksheets.
What is Workbook (p. EX 2)
100
Each column in Excel has a ____ as its header.
What is Letter (A, B, C, etc.)
100
The most common formula in Excel is used to provide a ______ of a range or list of numbers.
What is Total (page EX 25)
100
Press this keyboard combination to go to the top of the Excel worksheet (cell A1)
What is CTRL+HOME
100
The more frequently-used commands in Excel are found on this tab.
What is Home (page EX 10)
200
A ____ in Excel is a graphical representation of the numbers it contains
What is Chart (page EX 49)
200
True or False: An example of the location of a cell in in Excel is "67K"
What is False (K67)
200
The ______ ______ is a symbol always needed at the beginning of every formula in Excel.
What is Equal Sign (=, page EX 25)
200
Just like in Word, pressing _______ will save all changes to your document
What is CTRL+S
200
To add a chart to an Excel worksheet you click on the ____ tab.
What is Insert (page EX 51)
300
To center the title of an Excel document you need to highlight the cells on that row and press the "_____ & Center" icon.
What is Merge (page EX 41)
300
The ______ bar appears above the column headers in Excel and allows you to see the formulas "behind the scenes."
What is Function or Formula (page EX 17)
300
To copy a formula to adjacent cells, simply click the ____ _____ at the bottom right of the cell containing the formula and dragging your mouse through those adjacent cells.
What is Fill Handle (page EX 27)
300
Just like in any application in Windows XP, pressing _______ will minimize all your Excel windows.
What is WINDOWS LOGO + M
300
Similar to Word 2007, this tab contains the spellcheck feature.
What is Review
400
"Cell ______" on the Home tab contains built-in formats that allow you to change the appearance of specific parts of your worksheet.
What is Styles (page EX 35)
400
The ____ _____ Toolbar, also a feature in Word 2007, allows you to customize your window and add features used the most (example, Print Preview, Spell-Checker, etc).
What is Quick Access (page EX 13)
400
Which of these formulas is expressed correctly?
(A) =SUM[A2*7B]
(B) =SUM(A1:B7)
What is (B) (page EX 25)
400
If you need to lock your computer while working in Excel (or any program in Windows XP), the quickest keyboard shortcut is _______
What is WINDOWS LOGO + L
400
This tab has all kinds of mathematical, financial and logical functions used for a variety of projects and reports.
What is Formulas
500
Excel is a ______ program that allows users to organize data, complete calculations, graph data, and more.
What is Spreadsheet (page EX 2)
500
The pre-set amount of workheets in a new Excel document is ___.
What is 3
500
In the expression "=SUM(B4:B8)" the series of cells between B$ through B8 is considered a ______.
What is Range (page EX 24)
500
To expose all formulas contained in an Excel worksheet simply press these keys together.
What is CTRL+ACCENT KEY (key to the left of #1)
500
Similar to Word 2007, you press "Office Button > _______ > Properties" to access and type document properties for your document (example: keywords, subject, etc)