Advanced Excel - Midterms

Advanced Excel - Midterms

Professional Development

20 Qs

quiz-placeholder

Similar activities

PRE-TEST CONTENT CREATOR

PRE-TEST CONTENT CREATOR

Professional Development

20 Qs

AI Terms Quiz

AI Terms Quiz

Professional Development

15 Qs

Quiz MIAI Meeting 16 décembre

Quiz MIAI Meeting 16 décembre

Professional Development

17 Qs

IP Addressing

IP Addressing

Professional Development

20 Qs

CompTIA Security+ Flash Cards (GRE-PAT)

CompTIA Security+ Flash Cards (GRE-PAT)

Professional Development

20 Qs

CompTIA Network+ Flash Cards (A-PoE)

CompTIA Network+ Flash Cards (A-PoE)

Professional Development

20 Qs

Exploring Computer Networks & The Internet

Exploring Computer Networks & The Internet

Professional Development

15 Qs

V50e Pre-Refresher Quiz

V50e Pre-Refresher Quiz

Professional Development

20 Qs

Advanced Excel - Midterms

Advanced Excel - Midterms

Assessment

Quiz

Information Technology (IT)

Professional Development

Practice Problem

Easy

Created by

Kriz Mantalaba

Used 2+ times

FREE Resource

AI

Enhance your content in a minute

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

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

It is a system, which organizes data in columns and rows. It is a data visualization and analysis tool.

MS Powerpoint

MS Word

MS Excel

MS Teams

2.

DROPDOWN QUESTION

1 min • 1 pt

A ​ ​ ​ (a)   consists of a grid made from columns and rows.

powerpoint
portable file
word file
spreadsheet

3.

DROPDOWN QUESTION

1 min • 1 pt

MS Excel files have ​ (a)   extension.

.xlsx
.txt
.pptx
.docx

4.

DROPDOWN QUESTION

1 min • 1 pt

MS Excel supports​ ​ (a)   .

real-time collaboration
game development
video editing
3D printing

5.

DRAG AND DROP QUESTION

1 min • 1 pt

A ​ (a)   consists of a grid made from columns and rows.

spreadsheet
powerpoint
portable file
word document

6.

MATCH QUESTION

10 mins • 5 pts

Match the description to the correct Microsoft Excel feature or function.

Line Chart

This chart type displays trend over time.

Sum

Used to automate tasks

Drop-down List

This function is used for data lookup.

VLookup

Allows people to pick an item from a list that you create

Macros

This formula adds all the numeric values in a range of cells.

7.

MATCH QUESTION

10 mins • 5 pts

Match the Microsoft Excel feature or function with its description.

Pivot Table

Lets you copy formatting from one cell to another.

Conditional Formatting

This formula calculates the average.

Format Painter

This table is used for data analysis by summarizing large amounts of data.

Freeze Panes

Changes the cell appearance based on format conditions.

Average

Useful for viewing the headers while scrolling

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

Already have an account?