Which of the following is a valid function in Microsoft Excel?
Excel-O-Mania 2023

Quiz
•
Business
•
Professional Development
•
Hard
Aditya Singh
Used 7+ times
FREE Resource
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
=SUM(A1:B2)
=FORMAT(A1:B2)
=INSERT(A1:B2)
=SORT(A1:B2)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The bar graph presented above displays the total number of patients in five hospitals, namely P, Q, R, S, and T, along with the number of patients suffering from heart ailments in each of these hospitals.
P
Q
R
S
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is the default file extension for an Excel workbook file?
.xls
.xlsx
.xlsm
.xlam
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which function in Excel is used to find the highest value in a range of cells?
MIN
MAX
AVERAGE
SUM
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which chart type in Excel is best suited for showing trends over time?
Bar chart
Line chart
Pie chart
Scatter chart
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What is the keyboard shortcut to autosum a column of numbers in Excel?
Alt + =
Ctrl + =
Shift + =
Tab + =
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which function in Excel is used to count the number of cells in a range that contain numbers?
COUNTA
COUNTIF
SUM
AVERAGE
Create a free account and access millions of resources
Similar Resources on Wayground
30 questions
Intermediate Microsoft Excel 2019 M55269 Training

Quiz
•
Professional Development
26 questions
REVIEW

Quiz
•
Professional Development
30 questions
Day 1 Quiz - Video Editing for Educators using Premiere

Quiz
•
Professional Development
25 questions
BA 18 - SHORT QUIZ

Quiz
•
Professional Development
30 questions
Requisition Mgmnt

Quiz
•
Professional Development
29 questions
Accounts Payable Trivia

Quiz
•
Professional Development
25 questions
Quality Quiz

Quiz
•
Professional Development
25 questions
Computer Skills Quiz

Quiz
•
Professional Development
Popular Resources on Wayground
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade