Which of the following is a correct order of precedence in formula calculation?
- (A) Multiplication and division exponentiation positive and negative values
- (B) Multiplication and division, positive and negative values, addition and subtraction
- (C) Addition and subtraction, positive and negative values, exponentiation
- (D) All of above
- (B) Multiplication and division, positive and negative values, addition and subtraction
The Paste Special command lets you copy and paste:
- (A) Multiply the selection by a copied value
- (B) Cell comments
- (C) Formatting options
- (D) The resulting values of a formula instead of the actual formula
- (D) The resulting values of a formula instead of the actual formula
The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
- (A) None of these
- (B) Select Format > Money from the menu
- (C) Click the Currency Style button on the formatting toolbar
- (D) You have to retype everything and manually add the dollar signs, commas, and decimals.
- (C) Click the Currency Style button on the formatting toolbar
Which of the following is not a valid data type in excel?
- (A) Number
- (B) Character
- (C) Label
- (D) Date/time
- (B) Character
Excel worksheet cells work very similarly to what common element of the windows graphical user interface:
- (A) Option buttons
- (B) List boxes
- (C) Text boxes
- (D) Combo boxes
- (C) Text boxes
Which of the following options is not located in the Page Setup dialog box?
- (A) Page Break Preview.
- (B) Page Orientation
- (C) Margins
- (D) Headers and Footers
- (A) Page Break Preview.
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
- (A) Pie chart
- (B) Row chart
- (C) Line chart
- (D) Column chart
- (C) Line chart
Without using the mouse or the arrow keys, what is the fastest way of getting to cell Al in a spreadsheet?
- (A) Press Ctrl +Home
- (B) Press Home
- (C) Press Shift + Home
- (D) Press Alt + Home
- (A) Press Ctrl +Home
Which of the following methods cannot be used to edit the contents of a cell?
- (A) Press the Alt key
- (B) Clicking the formula bar
- (C) Pressing the F2 key
- (D) Double clicking the cell
- (A) Press the Alt key
If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:
- (A) Press the Erase key
- (B) Press Esc
- (C) Press the Enter button
- (D) Press the Edit Formula button
- (B) Press Esc