MICROSOFT EXCEL

Which of the following methods can not be used to enter data in a cell?

• (A) Pressing an arrow key
• (B) Pressing the tab key
• (C) Pressing the Esc key
• (D) Clicking the enter button to the formula bar

Which of the following will not set text in selected cells to italics?

• (A) Pressing Ctrl + I on the keyboard
• (B) Using the Tools – Wizard – Web Form menu item
• (C) Using the Format Cells Font menu item
• (D) None of the above

Which of the following methods cannot be used to edit the content of cell?

• (A) Pressing the Alt key
• (B) Clicking the formula bar
• (C) Pressing F2
• (D) Double clicking the cell

You can activate a cell by:

• (A) Pressing the Tab key
• (B) Clicking the cell
• (C) Pressing an arrow key
• (D) All of above

Which of the following setup options can not be set in the page setup dialog box?

• (A) Printer selection
• (B) Vertical or horizontal placement
• (C) Orientation
• (D) Row and column titles

What term refers to a specific set of values saved with the workbook?

• (A) Range
• (B) Scenario
• (C) Trend line
• (D) What-if analysis

Got functions? No? You need the insert function dialog box. How do you get it?

• (A) Right click a cell and then click insert
• (B) Click the insert menu and then click function
• (C) Type = in a cell
• (D) All of the above

Which of the following describes how to select all the cells in a single column?

• (A) Right click on column and select Pick from list
• (B) Use data – text to columns menu item
• (C) Left click on the gray column title button
• (D) Pressing Ctrl + A on the keyboard

When you use the fill effects in the format data series dialog box, you can not:

• (A) rotate text on the chart/
• (B) select a fore ground color
• (C) select a pattern
• (D) select a background color

Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

• (A) Rows and columns
• (B) Headings
• (C) Speed
• (D) None of these