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