Excel Formulas and Functions Quiz
10 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Addition of two strings is called ________________.

concatenation

You can format data using the ______________ option.

formatting

_________ error is displayed if you use an invalid operator.

syntax

__________ formula is used to calculate the values from cell A3:D3.

<p>SUM</p> Signup and view all the answers

A formula is made of _________ and _____________.

<p>functions, operators</p> Signup and view all the answers

__________ function calculates the average of the cell values.

<p>average</p> Signup and view all the answers

You have to press _______ key to edit the cell contents after selecting the cell.

<p>F12</p> Signup and view all the answers

_____________ are pre-defined formulae that perform specific calculations.

<p>functions</p> Signup and view all the answers

Write the formula of the following functions.

  1. Adding values from cell D1 to D5 = _____________________

<p>=SUM(D1:D5)</p> Signup and view all the answers

Write the formulas of the following functions. Counts the cell values A5 to A10 =______________________

<p>=COUNT(A5:A10)</p> Signup and view all the answers

More Like This

Mastering Formulas and Functions in Excel
5 questions
Excel Formulas and Functions Quiz
15 questions

Excel Formulas and Functions Quiz

OptimisticMossAgate7576 avatar
OptimisticMossAgate7576
Excel Formulas and Functions
10 questions
MS Excel: Formulas and Functions
5 questions
Use Quizgecko on...
Browser
Browser