Excel - Ch. 11: AVERAGE, MAX, MIN, TEXTJOIN, LEN, COUNT, TRIM
Text-only quiz: Ch. 11: AVERAGE, MAX, MIN, TEXTJOIN, LEN, COUNT, TRIM
Want to study this quiz?
Copy it to your free Gradiuz library and make it your own.
Question 1
What is the initial step when inserting a formula in Microsoft Excel?
- selecting the desired cell for the formula
- Opening a new workbook
- Saving the file
- Formatting the cells
Question 2
Pressing the F2 key allows you to begin editing a cell directly in Excel.
- True
- False
Question 3
To calculate the sum of the values in cells A1 and B1, you can simply enter the formula __________.
Fill in the blank
Question 4
After a formula is finalized, __________ will be displayed in the chosen cell.
Fill in the blank
Question 5
Inserting a formula in Microsoft Excel is a complex process that requires advanced programming knowledge.
- True
- False
Question 6
The formula bar in Excel is located above the spreadsheet and is identified by which label?
- fx
- sum
- avg
- data
Question 7
To calculate the sum of cells from A1 to A10, the correct formula syntax is =SUM(________).
Fill in the blank
Question 8
After typing a formula, pressing the Enter key will finalize the formula.
- True
- False
Question 9
Before inputting a formula, what is the first step an Excel user should take?
- Choose the cell where you would like to input the formula.
- Open the Insert Function dialog box.
- Type =SUM(.
- Hit Enter.
Question 10
How can users explore the available functions within the Insert Function dialog box?
- By searching or selecting a category.
- By clicking the "Help" button.
- By typing the function name directly into the worksheet.
- By navigating to the "Formulas" tab on the Ribbon.
Question 11
To start a function, you must always type the function name followed by an equals sign.
- True
- False
Question 12
What action is performed in the Function Arguments dialog box?
Fill in the blank
Question 13
Which formula correctly performs multiplication between the values in cells A1 and B1?
- =A1*B1
- =A1xB1
- =A1^B1
- =A1&B1
Question 14
The formula =AVERAGE(A1:A10) is used to calculate the average of a range of cells.
- True
- False
Question 15
What is the correct syntax for an IF statement that checks if cell A1 is greater than 10, returning 'Greater' if true and 'Less or Equal' if false?
- =IF(A1>10, "Greater", "Less or Equal")
- =IF(A1>10; "Greater"; "Less or Equal")
- =IF(A1, >10, "Greater", "Less or Equal")
- =IF(A1>10, Greater, Less or Equal)
Question 16
What is the primary reason to use cell references in your formulas?
- to ensure that the results are automatically updated whenever the data changes
- to make formulas shorter and easier to read
- to prevent any data from being modified in the referenced cells
- to highlight important cells on the worksheet
Question 17
To maintain a cell reference when copying a formula to other cells, what symbol should be used before the column letter and row number?
Fill in the blank
Question 18
An absolute reference is used to ensure that a cell reference changes when a formula is copied to other cells.
- False
- True
Question 19
Which of the following is an example of a formula for subtraction?
- =A1-B1
- =A1_B1
- =A1/B1
- =A1+B1
Question 20
Which of the following is an example of an absolute reference?
- $A$1
- A1
- A$1
- $A1
Made with Gradiuz
Turn any PDF into quizzes, flashcards and summaries - free.