Podcast
Questions and Answers
What is the purpose of the equal sign (=) in an Excel formula?
What is the purpose of the equal sign (=) in an Excel formula?
- To indicate the start of a formula (correct)
- To indicate the end of a function
- To indicate the start of a text string
- To indicate the start of a numeric value
Which of the following is NOT a valid mathematical operator in an Excel formula?
Which of the following is NOT a valid mathematical operator in an Excel formula?
- / (correct)
- +
- -
- *
What is the purpose of the Autofill capability in Excel?
What is the purpose of the Autofill capability in Excel?
- To automatically create a new worksheet
- To automatically format a range of cells
- To automatically insert formulas in a range of cells (correct)
- To automatically calculate the sum of a range of cells
What is the purpose of a function in Excel?
What is the purpose of a function in Excel?
What is the purpose of the fill handle in Excel?
What is the purpose of the fill handle in Excel?
What is the purpose of a cell reference in an Excel formula?
What is the purpose of a cell reference in an Excel formula?
What is the primary purpose of Excel?
What is the primary purpose of Excel?
Which of the following is NOT a common use of Excel in business?
Which of the following is NOT a common use of Excel in business?
What is the purpose of the menu commands below the Office button in Excel?
What is the purpose of the menu commands below the Office button in Excel?
Which of the following is NOT a group found on the Home tab of the Excel ribbon?
Which of the following is NOT a group found on the Home tab of the Excel ribbon?
What is the purpose of the tabs on the Excel ribbon?
What is the purpose of the tabs on the Excel ribbon?
Which of the following statements is true?
Which of the following statements is true?