Excel-O-Mania 2023

Excel-O-Mania 2023

Professional Development

30 Qs

quiz-placeholder

Similar activities

Quality Quiz

Quality Quiz

Professional Development

25 Qs

Computer Skills Quiz

Computer Skills Quiz

Professional Development

25 Qs

Intermediate Microsoft Excel 2019 M55269 Training

Intermediate Microsoft Excel 2019 M55269 Training

Professional Development

30 Qs

LearnUp@Tally-5

LearnUp@Tally-5

10th Grade - Professional Development

25 Qs

Options Basics

Options Basics

5th Grade - Professional Development

25 Qs

Robot Day 2023 Salesforce Quiz

Robot Day 2023 Salesforce Quiz

Professional Development

30 Qs

Lesson 4 - Fundamentals of Database Systems

Lesson 4 - Fundamentals of Database Systems

University - Professional Development

25 Qs

Management Concepts

Management Concepts

Professional Development

25 Qs

Excel-O-Mania 2023

Excel-O-Mania 2023

Assessment

Quiz

Business

Professional Development

Hard

Created by

Aditya Singh

Used 7+ times

FREE Resource

30 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the following is a valid function in Microsoft Excel?

=SUM(A1:B2)

=FORMAT(A1:B2)

=INSERT(A1:B2)

=SORT(A1:B2)

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

 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

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?