Lesson 08 - Rounding and Nesting Functions
Lesson 08 - Rounding and Nesting Functions
(See related pages)

 1 What is not included in a CSV file? A) Data B) Values C) Formatting D) Properties 2 What are the arguments for the ROUND function? A) Number and Num_digits B) Value and Num_digits C) Number, Num_digits, and Decimals D) Number, Decimals, and Dec_places 3 Which function converts a value to a specified digit to the left or right of the decimal point? A) IF B) INT C) ROUND D) SUM 4 Which button would provide a way to highlight lowest sales figures on a worksheet? A) Format B) Conditional Formatting C) Top/Bottom D) Cell Styles 5 To convert days to years, what number is the divisor if you account for leap years? A) 360 B) 30 C) 365.25 D) 366 6 What is an integer? A) A cell reference B) A number with decimals C) A number with fractions D) A whole number 7 Which function category includes INT and ROUND? A) Logical B) Math and Trig C) Statistical D) Currency 8 If a cell contains =ROUND(3.4567,2), what value would be used in a formula that refers to that cell? A) 3.45 B) 3.46 C) 3.457 D) 3.4567 9 If you key 1.2385 and format the cell for two decimal places, what will be displayed in the formula bar? A) 1.2 B) 1.23 C) 1.24 D) 1.2385 10 Why might you hide worksheets in a workbook? A) The file is smaller. B) The file is larger. C) Some data is private. D) Some data is formatted.