BIM 2A first 9 week Exam

You can use the Excel equation tools to inset an equation for calculating the area of a circle.

• True

• False

Liam needs to count the cells in the range B1:B20 that contain numbers, dates, or text. Which of the following formulas should he use?

• =COUNT

• =COUNTA(B1:B20)

• =SUM

• =CALCULATE

Currency is an example of a number format.

• True

• False

Sam wants to count the number of cells in the range B1:B20 that contain numbers. Which of the following formulas should he use?

• =COUNT (B1:B20)

• =COUNTA

• =SUM(B:B20)

• =CALCULATE

You can set a scaling option to resize a worksheet to fit within a single page.

• True

• False

You can apply date formats to cells by using the Date category in the Format Cells dialog box.

• True

• False

The printed page is wider than it is taller, when you use portrait orientation.

• True

• False

Jason wants to display the text "Poor" if the value in cell A3 is less than 25. If the value in cell A3 is less than 50, Jason wants to display "Average"; otherwise, he wants to display "Good". Which of the following formulas should he use?

• =IF(A3<25, "Poor", IF (A3<50, "Average", "Good"))

• =IFA3<25

• +IFA

• IFA3>50

To accept a suggested spelling for one instance only, which of the following would you click?

• Change

• Change ALL

• Ignore Once

• Add to dictionary

To insert only the current date in cell B1, use the NOW function in cell B1.

• True

• False