1. Except for the …… function a formula with a logical function shows the word “TRUE” or “FALSE” as a result
IF
AND
OR
NOT

2. Macros are “run” or executed from the ….. menu.
Insert
Format
Tools
Data

3. You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.
Insert
Format
Tools
Data

4. Each excel file is called a workbook because
It can contain text and data
It can be modified
It can contain many sheets including worksheets and chart sheets
You have to work hard to create it

5. Which types of charts can excel produce?
Line graphs and pie charts only
Only line graphs
Bar charts line graphs and pie charts
Bar charts and line graphs only

6. How are data organized in a spreadsheet?
Lines and spaces
Layers and planes
Rows and columns
Height and width

7. What does the VLOOKUP function do?
Looks up text that contain ‘v’
Checks whether text is the same in one cell as in the next
Finds related records
All of above

8. Gridlines
May be turned off for display but turned on for printing
May be turned on or off for printing
The be turned off for display and printing
a b and c

9. You can print only an embedded chart by
Moving the chart to a chart sheet before you print.
Formatting the chart before you print
Selecting the chart before you print
a and c

10. Which of the following is a correct order of precedence in a formula calculation?
Multiplication and division exponential positive and negative value
Multiplication and division positive and negative values addition and subtraction
Addition and subtraction positive and negative values exponentiation
None of above

11. A function inside another function is called a ….. function.
Nested
Round
Sum
Text

12. How should you print a selected area of a worksheet if you’ll want to print a different area next time?
On the file menu point to print area and then click set print area.
On the file menu click print and then click selection under print what
On the view menu click custom views then click add
All of above

13. Your German supplier still invoices for parts in Deutsche marks. How can you have Excel convert those sums to Euros?
On the Insert menu click Symbol and from the currency symbols subset select the Euro sign.
On the tools menu click Add-Ins and select the Euro Currency Tools check box
Apply a selected background color
All of above

14. 164. Which function calculates your monthly mortage payment?
PMT payments
NPER number of periods
PV present value
All of above

15. If you are working in English (US) Chinese or Japanese Excel 2002 can speak data as you enter it to help you verify accuracy. How do you activate this feature?
Point to speech on the tools menu and then click show text to speech toolbar.
Click validation on the data menu
Point to speech on the tools menu and then click speech recognition
All of above

16. Which of the following methods can not be used to enter data in a cell?
Pressing an arrow key
Pressing the tab key
Pressing the Esc key
Clicking the enter button to the formula bar

17. Which of the following will not set text in selected cells to italics?
Pressing Ctrl + I on the keyboard
Using the Tools – Wizard – Web Form menu item
Using the Format – Cells – Font menu item
None of the above

18. Which of the following methods cannot be used to edit the content of cell?
Pressing the Alt key
Clicking the formula bar
Pressing F2
Double clicking the cell

19. Which of the following is not an option in the spelling dialog box?
Edit
Ignore
Ignore all
Change

20. You can quickly change the appearance of your work by choosing Auto Format from the …. Menu
Edit
View
Format
Tools

21. To protect a worksheet you can choose Protection and the Protect Sheet from the ….. menu
Edit
Format
Tools
Data

22. You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
Edit
Insert
Format
Tools

23. Which of the following is not a worksheet design criterion?
Efficiency
Auditability
Description
Clarity

24. To copy cell contents using drag and drop press the
End key
Shift key
Esc key
None of above

25. If you press …. the cell accepts your typing as its contents.
Enter
Ctrl + Enter
TAB
Insert

26. The autofill feature
Extends a sequential series of data
Automatically adds a range of cell values
Applies a boarder around selected cells
None of above

27. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
F3
F5
F7
F11

28. you can use the formula palette to
format cells containing numbers
create and edit formulas containing functions
entered assumptions data
copy a range of cells

29. What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed
Format Report
Pivot Table
Refresh Data
Show Detail

30. What is an expression that tells how the numbers in a determined set of cells are to be calculated?
Formula
Field
Data
Query Correct Answer

31. Qtr 1 Qtr 2 Qtr 3” is an example of a
Formula
Function
Series
Syntax

32. You can edit existing Excel data by pressing the
F1 key
F2key
F3key
F4 key

33. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….
G1-G10
B1.G10
B1;G10
B1:G10

34. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
Go to File-Save As – Save As Type – Excel worksheet
Right click on the spreadsheet tab and select DELETE
Right click on the spreadsheet and select Insert – Entire Column
None of above

35. What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?
Goal Seek
Scenario Summary report
Forecasting
Trend line

36. what term describes a background that appears as a grainy non smooth surface
gradient
pattern
solid
texture

37. Excel is a
Graphic program
None of these
Word processor
A spreadsheet

38. To create an interactive Pivot Table for the web you use a Microsoft Office Web component called
HTML
Pivot Table Field List
Pivot Table List
Pivot Table Report

39. Which of the following is not a valid Zoom percentage in Excel?
10
100
300
500

40. The spelling tool is placed on ______ toolbar
Standard
Formatting
Drawing
Reviewing

41. If you need a text to show vertically in a cell. How will you achieve this?
Choose Vertical on Text alignment in Format Cells dialog box
Choose 90 Degrees in Orientation of Format Cells dialog box
Choose Distributed from the Vertical drop down list of Format Cells dialog box
Choose Center Across Selection from Horizontal combo box in Format Cells dialog box

42. Can you set 0.5 inch left indentation for a cell in Excel?
Excel does not have indentation feature
You can specify indentation only if you turn the rulers on
Indentation can be set from Format Cells dialog box
The indentation can be specified only when printing

43. You can automatically adjust the size of text in a cell if they do not fit in width by
Double clicking on the right border of column header
From Format choose Columns and then Autofit Selection
From Format Cells dialog box mark Shrink to fit check box
All of above

44. Formatting a cell in Currency you can specify
Decimal Places
Currency Symbol
Both of above
None of above

45. Formatting a cell in Number format you can’t set
Decimal Places
Use 1000 separator
Negative numbers
Currency Symbol

46. What is entered by the function =today
The date value for the day according to system clock
The time value according to system clock
Today’s date as Text format
All of above

47. Which function will you use to enter current time in a woksheet cell?
today
now
time
currentTime

48. Special category of Number tab in Format Cells dialog box can be used to apply formats like
Zip Code
Phone Number
Both of above
None of above

49. Merge cells option can be applied from
Format Cells dialog box Alignment Tab
Formatting toolbar
Both of above
None of above

50. Pre-made sheet formats like Simple Classic Accounting Colorful et can be applied from
from Fromat >> Cells
from Format >> Autoformat
from Table >> Autoformat
All of above