Search Header Logo

Introduction to MS Excel - Quiz

Authored by IZA ABAD

Other

University

Used 16+ times

Introduction to MS Excel - Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What is the primary function of Microsoft Excel?

Word processing

Spreadsheet calculations

Graphic design

Presentation design

2.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which feature in Excel is used to automatically sum a range of numbers?

AutoSum

AutoCalculate

AutoTotal

AutoAdd

3.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What does the function VLOOKUP do in Excel?

Vertical lookup for text

Vertical lookup for values

Verify lookup data

Validate lookup results

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What is the keyboard shortcut for copying cell contents in Excel?

Ctrl+C

Ctrl+X

Ctrl+V

Ctrl+Z

5.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

  1. Which function is used to count the number of cells that contain numbers in a range?

SUM

  1. COUNT

  1. AVERAGE

  1. MAX

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Excel, what does the formula =$A$1 represent?

A relative cell reference

A circular reference

A mixed cell reference

An absolute cell reference

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which chart type in Excel is best suited for showing the relationship between two variables?

Line chart

Pie chart

Scatter plot

Bar chart

Access all questions and much more by creating a free account

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

Already have an account?