Excel - Ch. 10: Excel Formulas - Gradiuz
Gradiuz
Get Started
Quiz 💻 Computer Science

Excel - Ch. 10: Excel Formulas

Text-only quiz: Ch. 10: Excel Formulas

excel_formulas_en excel_formulas_en
Translate

Want to study this quiz?

Copy it to your free Gradiuz library and make it your own.

Make your own from a PDF
Question 1

What is the definition of an Excel formula?

  • expressions that are used to calculate the value of a cell in a spreadsheet
  • a predefined calculation that performs a specific task
  • a visual representation of data trends
  • a tool for formatting cell appearance
Question 2

Which of the following functions is listed as having been modified in Excel?

  • CONCAT
  • VLOOKUP
  • COUNT
  • IF
Question 3

What fundamental arithmetic operation is the SUM function responsible for carrying out?

  • sum
  • multiplication
  • division
  • subtraction
Question 4

According to the provided information, which formula correctly sums the values in cells A2 and C6 individually?

  • =SUM(A2, C6)
  • =SUM(A2:C6)
  • =A2+C6
  • =SUM(A2 and C6)
Question 5

To properly calculate the sum, an Excel formula must have at least one number that is linked to a cell or a range of cells.

  • True
  • False
Question 6

It is possible to execute several tasks, such as addition and division, by using a single Excel formula.

  • True
  • False
Question 7

Which function is used to perform a sum with conditions?

  • SUMIF
  • SUM
  • AVERAGEIF
  • COUNTIF
Question 8

In the SUMIF function, what is required in the first parameter?

  • the range of cells that are to be validated against the criteria
  • the criterion itself
  • the cells to sum
  • the final calculated sum
Question 9

The AutoSum button is located on which tab in Excel?

  • Home tab
  • Insert tab
  • Data tab
  • Formulas tab
Question 10

When the AutoSum button is used, Excel automatically inserts the SUM formula and adds the corresponding values.

  • True
  • False
Question 11

What does the AVERAGE function in Excel determine?

  • the arithmetic mean, of a set of values
  • the highest value in a range
  • the total sum of values
  • the count of numbers in a range
Question 12

The process of dividing the total by the frequency is known as the __________.

Fill in the blank

Question 13

Which Excel function is used to compute the average of cells depending on a specified condition?

  • AVERAGEIF
  • AVERAGE
  • SUMIF
  • COUNTIF
Question 14

In the AVERAGEIF formula =AVERAGEIF(A2:C6, D3, E2:E6), the argument D3 represents the __________.

Fill in the blank

Question 15

The MAX and MIN Excel formulas are used to find the maximum and lowest values, respectively, within a collection of numbers.

  • True
  • False
Question 16

Which formula correctly determines the least value from cell A2 to cell C6?

  • =MIN(A2:C6)
  • =MINIMUM(A2:C6)
  • =LOWEST(A2:C6)
  • =MIN(A2-C6)
Question 17

The COUNT function in Excel is used to get information about the number of cells within a certain range that include what type of data?

  • numeric data
  • text data
  • error values
  • all non-blank data
Question 18

The COUNT function works with cells that include numbers, while the COUNTA function counts all cells that are not blank, regardless of whether they contain numbers, dates, text, times, or errors.

  • True
  • False
Question 19

In the IF function syntax IF(logical_test, [value_if_true], [value_if_false]), the first argument is known as the __________.

Fill in the blank

Question 20

According to the provided information, which function is used to get the number of cells in a column that have numerical values?

  • COUNT
  • COUNTA
  • COUNTIF
  • SUM

Made with Gradiuz

Turn any PDF into quizzes, flashcards and summaries - free.

Try it yourself