Excel Functions and Features Quiz

Excel Functions and Features Quiz

University

45 Qs

quiz-placeholder

Similar activities

CMA 310 - Anatomy of Buildings Chapters 1-3

CMA 310 - Anatomy of Buildings Chapters 1-3

University

45 Qs

PRELIM EXAM IN ENGLISH FOR INFORMATION TECHNOLOGY

PRELIM EXAM IN ENGLISH FOR INFORMATION TECHNOLOGY

University

50 Qs

Segurança em Tecnologia da Informação

Segurança em Tecnologia da Informação

University

50 Qs

Informatica

Informatica

University

45 Qs

Quiz despre Cloud Computing

Quiz despre Cloud Computing

University

40 Qs

PLC Quiz

PLC Quiz

University

48 Qs

504L U45 81G D4T4

504L U45 81G D4T4

University

50 Qs

Technology in Teaching and Learning Reviewer Topics 1-3

Technology in Teaching and Learning Reviewer Topics 1-3

University

50 Qs

Excel Functions and Features Quiz

Excel Functions and Features Quiz

Assessment

Quiz

Instructional Technology

University

Medium

Created by

Mohd Atarhim

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

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

45 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which Excel function returns the smallest number in a range from B2 to B20?

=LOW(B2:B20)

=MIN(B2:B20)

=SMALL(B2:B20)

=LOWEST(B2:B20)

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Excel, pressing F4 after selecting a cell reference in a formula will:

Convert it to an absolute reference

Delete the cell content

Refresh the worksheet

Open the Format Cells dialog

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an example of Application Software?

Linux

Microsoft Excel

BIOS

Device Driver

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which Excel chart type displays vertical bars for comparing data across categories?

Line Chart

Clustered Column Chart

Pie Chart

Area Chart

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which tool in Excel automatically completes text entries when it detects a pattern?

Data Validation

Flash Fill

Format Painter

AutoCorrect

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of Axis Titles in a chart?

To identify the data series

To label the horizontal or vertical axes

To format the chart background

To filter chart data

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which Excel feature allows you to split the worksheet window into multiple panes?

Freeze Panes

Page Break Preview

Split Window

Arrange All

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?