Excel-O-Mania 2023

Excel-O-Mania 2023

Professional Development

30 Qs

quiz-placeholder

Similar activities

PERSONAL EFFECTS 0601

PERSONAL EFFECTS 0601

Professional Development

28 Qs

BME 1 - Identify the Current Trends in Tourism & Hospitality

BME 1 - Identify the Current Trends in Tourism & Hospitality

Professional Development

25 Qs

Environment Level 3 Unit 2

Environment Level 3 Unit 2

University - Professional Development

25 Qs

STIN (EM24) - Sistemas de Información (T1)

STIN (EM24) - Sistemas de Información (T1)

University - Professional Development

25 Qs

Tata Nexon Next Generation 2023

Tata Nexon Next Generation 2023

Professional Development

25 Qs

Introduction to Bookkeeping: Self-Check

Introduction to Bookkeeping: Self-Check

Professional Development

25 Qs

BHV BOC

BHV BOC

Professional Development

25 Qs

Structure of the construction industry

Structure of the construction industry

Professional Development

29 Qs

Excel-O-Mania 2023

Excel-O-Mania 2023

Assessment

Quiz

Business

Professional Development

Practice Problem

Hard

Created by

Aditya Singh

Used 7+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?