Microsoft Offcie Excel -1
1. The name of the active cell appears in the -----------------------.
A. Formula Bar
B. Column
C. Name box
2. To select several cells or ranges that are not touching each other, you
would _____ while selecting
A. Hold down the CTRL key
B. Hold down the SHIFT key
C. Hold down the ALT key
3. What is the area at the intersection of a single row and column in an
Excel spreadsheet referred to as?
A. Window
B. Cell
C. Sheet
D. Matrix
4. When a formula is written in a cell. It appears in the the active cell in
which it is being written and in the __________________ bar as well.
A. Formula
B. Name Box
C. Title bar
5. Except for the ______________ function, a formula with a logical function
shows the word "TRUE" or "FALSE" as a result
A. =NOT()
B. =COUNT()
C. =AND()
D. =OR()
6. To name a cell or range, you use the _______________
A. Define name
B. Paste name
C. Names Box
D. Format cells
7. As you begin to type a function name within a formula into a cell, a list
of functions that begin with the letters you typed appears.
A. True
B. False
8. __________________ is the vertical part of the spreadsheet.
A. Cell
B. Row
C. Columns
9. After writing the formula you have to press _____________________ key
from the keyboard to see the answer.
A. Enter
B. Shift-Enter
C. Ctrl-Enter
D. Any of the above
10. You can select the current Row by pressing
A. Shift + Tab
B. Alt spacebar
C. Shift + spacebar
D. Control + spacebar
11. What is the keyboard shortcut for creating a chart from the
selected cells?
A. F11
B. F3
C. F7
D. F9
12. Formatting data only change the appearance of data, it does not
affect the data itself.
A. True
B. False
13. Which mathematical operation is performed by the ^ key in an
Excel formula?
A. Multiplication
B. Factorial
C. Power
D. Logical
14. Which of the following functions is correctly written?
A. =IF(B2>50000."rich","poor")
B. IF(B2>50000,rich,poor)
C. =IF(B2>50000),"rich","poor"))
D. =IF(B2>50000,"rich","poor")
15. The _________________ displays the name of the sheets in the
workbook.
A. Book Tabs
B. Sheet Tabs
C. Menu Bar
16. How would you print formulas?
A. Click the Microsoft Office Button and then click Print.
B. Click Normal on the View tab at the top of the screen, click the
Microsoft Office Button, and then click Print.
C. Point to Formula Auditing on the Formulas tab, click Show
Formulas, click the Microsoft Office Button, and then click Print.
17. The "Go To" dialogue appears when you press the _____________
key from keyboard.
A. F5
B. F7
C. F6
18. The ___________ allows you to use Excel to change one or more
values in a spreadsheet and then assess the effect those changes have
on the calculated values.
A. What-if analysis
B. Track Changes
19. One person in the office is working on Excel 97, another in Excel
2000 and you are working in Excel 2007. How would you save it in
order for other users can open and edit the file?
A. HTML
B. Template
C. Excel 97-2003 Workbook (*.xls)
D. CSV
20. You can use a spreadsheets package like the Microsoft Excel To
_________________
A. Design speadsheets models.
B. Create charts.
C. Perform mathematical operations
D. All of the above
21. What does the LEN() function do?
A. Counts the number of characters in a cell
B. All of the choices
C. Deletes Trailing spaces
D. Splits the Cell contents
