1:How can you force Excel not to show the error of a formula? 2: Absolute cell r

ID: 3793987 • Letter: 1

Question

1:How can you force Excel not to show the error of a formula?

2: Absolute cell referencing uses the # symbol. (True/False)

4:=$B$2 - 2 is an example of mixed cell referencing. (True/False)

5:When constructing a formula, Excel's default reference type is relative cell referencing. (True/False)

6) =$A$5+$B$6 is an example of absolute cell referencing. (True/False)

7: =B4-5 is an example of absolute cell referencing. (True/False)

8: A named range is a cell or a group of cells that has(have) been given a name, which you can use when writing a formula or function. (True/False)

9: A named range CANNOT contain any spaces. (True/False)

10:) If you incorrectly name a range, you can rename it by selecting the data and naming the range again. (True/False)

11 If you type =C, a list of functions and named ranges beginning with the letter "C" appears. (True/False)

12: Excel's RANDBETWEEN function returns a random number from 0 to less than 1. (True/False)

13: The INT function will ignore or truncate all the decimal places. (True/False)

14:) Excel's AVERAGE function returns the mean of a set of numbers. (True/False)

15: Excel's MAXIMUM function returns the largest number from a set of numbers. (True/False)

1) on the excel menu click prefrence,under formula and list,click error checking and then clear the enable background error chechking box.

2)FALSE($ is used for cell refrencing)

3)TRUE

5)TRUE

6)TRUE (

7)TRUE

9)TRUE

10)TRUE

11)TRUE

12)FALSE(itreturns any random integers between the range we provide)

13)TRUE

14)TRUE

15)false

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.