Question 1 1 pts A can contain multiple worksheet, workbooks worksheet, files 2 O workbook, worksheets O file, workbooks Question 2 1 pts An example of a valid range of cells is O A1 to A3 A1:A3 O A1&A3 O A1-A3 Question 3 1 pts Evaluate the following expression in a blank cell in Excel (without double quotes): =(1+2*(3*4)-SQRT(100)/10+99)^2 The answer returned by Excel is 15129 01046529 O 1089 O None of the above Question 4 1 pts Formulas and functions begin with a(n) sign in Excel O @ O& = O# Question 5 1 pts The RAND function has arguments. OO 03 O 1 O2 Question 6 1 pts The function can be used to calculate the sum of numbers in a given range of cells. O SUM O AGGREGATE O ADD O PLUS Question 7 1 pts The function can be used in Excel to count the total number of cells with numeric values in a given range. O COUNTNUMERIC COUNT O COUNTBLANK COUNTA Question 8 1 pts The following function can be used to calculate the maximum value in a range of cells. MAXIMUM O MAXI O MAX O LARGE Question 9 1 pts The following range will select all cells in the first 10 columns of row 1. A1:31 O A1:A10 O A1:J10 O 1A:1) Question 10 1 pts Which of the following expressions/formulas can be used to calculate the sum of all numbers in the top 10 rows of column A of a worksheet in Excel? O ESUM(A1-A10) O ESUM(A1:A10) O SUM(A1-A10) O=ADD(A1:A10)