info@jobexams.pk

Which function is used to calculate the average in Excel?

In Microsoft Excel, the AVERAGE() function is used to calculate the arithmetic mean of a group of numbers. It adds all the numbers together and then divides the total by the count of values.
For example, if you have the numbers... Read More

1 MS OFFICE MCQS

Which function is used to calculate the average in Excel?

  • ADD()
  • SUM()
  • COUNT()
  • AVERAGE()
Correct Answer: D. AVERAGE()

Detailed Explanation

In Microsoft Excel, the AVERAGE() function is used to calculate the arithmetic mean of a group of numbers. It adds all the numbers together and then divides the total by the count of values.


For example, if you have the numbers 10, 20, and 30 in cells A1 to A3, the formula =AVERAGE(A1:A3) will return 20 because (10 + 20 + 30) ÷ 3 = 20.

Related Questions

MS Office MCQs
In Excel to join two cells we use:
0 comments
View
MS Office MCQs
In Microsoft PowerPoint, the ___ view is used to automatically play slides during a presentation.
0 comments
View
MS Office MCQs
Autocorrect is used to replace ___ words in a document?
0 comments
View
MS Office MCQs
What is the function of "Ctrl + Shift + N" in MS Word?
0 comments
View

Discussion

No comments yet. Be the first to share your thoughts!

Leave a Comment

Question Categories
General Knowledge Category MCQ'S
Computer Category MCQ'S
Chemistry Category MCQ'S
Pak Departmental Laws & Rules MCQs
Management Sciences MCQs

More from MS Office MCQs

MS Office MCQs
In Excel to join two cells we use:
0
View
MS Office MCQs
In Microsoft PowerPoint, the ___ view is used to automatically play slides during a presentation.
0
View
MS Office MCQs
Autocorrect is used to replace ___ words in a document?
0
View
MS Office MCQs
What is the function of "Ctrl + Shift + N" in MS Word?
0
View
MS Office MCQs
In MS Word, the function of the "Header & Footer" tool is to ______?
0
View
MS Office MCQs
Which key is used to enter the current date in Excel?
0
View
MS Office MCQs
In MS Excel, the $ symbol in a formula denotes ______?
0
View
MS Office MCQs
Which of the following email fields hides recipients from each other?
0
View
MS Office MCQs
Which function is used in Excel to count numeric values in a range?
0
View
MS Office MCQs
What does the “Pivot Table” tool primarily allow users to do?
0
View
MS Office MCQs
Which shortcut key is used to start a presentation from the beginning in PowerPoint?
0
View
MS Office MCQs
The shortcut key to close the currently opened document in Microsoft Word is ?
0
View
MS Office MCQs
What is the shortcut key in MS Word to apply "Change Case"?
0
View
MS Office MCQs
The default font in Excel is:
0
View
MS Office MCQs
How to start a new line in the same cell?
0
View
MS Office MCQs
Which error is shown for division by zero?
0
View
MS Office MCQs
What is a cell range in Microsoft Excel?
0
View
MS Office MCQs
Which of the following is a valid cell address?
0
View
MS Office MCQs
The extension of a Microsoft Word document?
0
View
MS Office MCQs
Which of the following is not a function in Excel?
0
View
MS Office MCQs
Shortcut to insert current time:
0
View
MS Office MCQs
Which function counts blank cells?
0
View
MS Office MCQs
Which of these is not a valid chart type in Excel?
0
View
MS Office MCQs
The shortcut key to close the workbook is:
0
View
MS Office MCQs
What is the shortcut to insert a new row in Excel?
0
View
MS Office MCQs
Shortcut for inserting the current date:
0
View
MS Office MCQs
Which tab contains the “Freeze Panes” option?
0
View
MS Office MCQs
How to insert a new worksheet?
0
View
MS Office MCQs
Which of the following is used to protect a sheet?
0
View
MS Office MCQs
To insert a chart, which tab is used?
0
View
MS Office MCQs
What does the COUNT() function do?
0
View
MS Office MCQs
Which symbol is used to start a formula in Excel?
0
View
MS Office MCQs
What is the default file extension of an Excel 2019 workbook?
0
View
MS Office MCQs
What type of chart shows trends over time?
0
View
MS Office MCQs
Shortcut for Redo is:
0
View
MS Office MCQs
What does the Format Painter tool do?
0
View
MS Office MCQs
What is the use of the Wrap Text feature?
0
View
MS Office MCQs
The formula =SUM(A1:A5) does what?
0
View
MS Office MCQs
Which function is used to join text from different cells in MS Excel?
0
View
MS Office MCQs
Shortcut for undo is:
0
View
MS Office MCQs
What symbol is used for absolute cell referencing?
0
View
MS Office MCQs
Which function rounds a number to the nearest integer?
0
View
MS Office MCQs
To add comments, which tab is used?
0
View
MS Office MCQs
Which key moves to the beginning of a row?
0
View
MS Office MCQs
What is the shortcut key for Print Preview?
0
View
MS Office MCQs
What does the IF function do?
0
View
MS Office MCQs
Which tab contains the Sort & Filter option?
0
View
MS Office MCQs
The default alignment of text in a cell is:
0
View
MS Office MCQs
The default alignment of numbers in a cell is:
0
View
MS Office MCQs
Shortcut to select the entire worksheet is:
0
View
MS Office MCQs
What does the 'Ctrl + Shift + L' shortcut do in MS Word?
0
View
MS Office MCQs
What happens when you double-click on a word in MS Word?
0
View
MS Office MCQs
How can you open the Navigation Pane in MS Word?
0
View
MS Office MCQs
Which tab would you use to change page margins?
0
View
MS Office MCQs
What does the 'Format Painter' tool do?
0
View
MS Office MCQs
Which tab contains 'Header & Footer' tools?
0
View
MS Office MCQs
What is the purpose of the 'Equation' tool in MS Word?
0
View
MS Office MCQs
What does 'Alt + Shift + D' insert in MS Word?
0
View
MS Office MCQs
What is 'AutoSave' in MS Word?
0
View