CTE BIM II 1st 9wks DCA Review
You can edit cell contents in the formula bar or in the cell itself. - ANS-True
Currency is an example of a number format. - ANS-True
Nathan wants a formula to return "YES" if the value in cell A1 is less than the value in
cell B1, and to return "No" otherwise. Which of the following functions should he use? -
ANS-IF Function
When you enter a numerical value in a worksheet cell, it is automatically left-aligned. -
ANS-False
You can start Excel using the Start button on the Windows taskbar or a shortcut on your
desktop. - ANS-True
What is TRUE of the Excel spell checker? - ANS-You can change all instances of a
flagged word to a selected suggestion
You can use the Excel equation tools to inset an equation for calculating the area of a
circle. - ANS-True
To show formulas instead of values, click on the Formulas tab in the ribbon, then in the
Formula Auditing group, click on the Show Formulas option. - ANS-True
When you copy and paste a formula with absolute cell references, Excel substitutes
new references to reflect the new formula location. - ANS-False
To remove conditional formatting from a selected range, you can select the rule in the
Conditional Formatting Rules Manger dialog box, then click the Delete Rule button. -
ANS-True
Sam wants to count the number of cells in the range B1:B20 that contain numbers.
What formulas should he use? - ANS-=COUNT (B1:B20)
To print a worksheet, you begin by going to Backstage view. - ANS-True
You can use the DELETE key to clear cell contents. - ANS-True
You can edit cell contents in the formula bar or in the cell itself. - ANS-True
Currency is an example of a number format. - ANS-True
Nathan wants a formula to return "YES" if the value in cell A1 is less than the value in
cell B1, and to return "No" otherwise. Which of the following functions should he use? -
ANS-IF Function
When you enter a numerical value in a worksheet cell, it is automatically left-aligned. -
ANS-False
You can start Excel using the Start button on the Windows taskbar or a shortcut on your
desktop. - ANS-True
What is TRUE of the Excel spell checker? - ANS-You can change all instances of a
flagged word to a selected suggestion
You can use the Excel equation tools to inset an equation for calculating the area of a
circle. - ANS-True
To show formulas instead of values, click on the Formulas tab in the ribbon, then in the
Formula Auditing group, click on the Show Formulas option. - ANS-True
When you copy and paste a formula with absolute cell references, Excel substitutes
new references to reflect the new formula location. - ANS-False
To remove conditional formatting from a selected range, you can select the rule in the
Conditional Formatting Rules Manger dialog box, then click the Delete Rule button. -
ANS-True
Sam wants to count the number of cells in the range B1:B20 that contain numbers.
What formulas should he use? - ANS-=COUNT (B1:B20)
To print a worksheet, you begin by going to Backstage view. - ANS-True
You can use the DELETE key to clear cell contents. - ANS-True
