Mastering Microsoft Excel

Mastering Microsoft Excel

10th Grade

10 Qs

quiz-placeholder

Similar activities

Input, output and storage de

Input, output and storage de

8th Grade - Professional Development

14 Qs

MODULE 9 PRE-TEST

MODULE 9 PRE-TEST

10th Grade

10 Qs

Network

Network

10th - 11th Grade

10 Qs

ZOOM QUIZ

ZOOM QUIZ

1st - 12th Grade

10 Qs

hardware and software(g3)

hardware and software(g3)

2nd - 10th Grade

10 Qs

Latihan Soal PTS Kelas 6 Semester 1

Latihan Soal PTS Kelas 6 Semester 1

10th Grade

10 Qs

KD 3.1_Aplikasi Pengolah Angka / Spreadsheet

KD 3.1_Aplikasi Pengolah Angka / Spreadsheet

10th Grade

15 Qs

Bài 10-Thực hành khai thác tài nguyên trên Internet

Bài 10-Thực hành khai thác tài nguyên trên Internet

10th - 12th Grade

10 Qs

Mastering Microsoft Excel

Mastering Microsoft Excel

Assessment

Quiz

Computers

10th Grade

Practice Problem

Medium

Created by

Axl Bintang Pardamean Simanjuntak

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...

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the shortcut key for entering data in a cell?

Ctrl

Tab

Enter

Shift

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you quickly fill a series of numbers in Excel?

Use the fill handle to drag and fill a series of numbers.

Select the entire column and press delete.

Copy and paste the numbers from another document.

Use the formula bar to enter numbers manually.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the VLOOKUP function do in Excel?

The VLOOKUP function searches for a value and returns a value in the same row from a specified column.

The VLOOKUP function sorts data in ascending order.

The VLOOKUP function creates a pivot table from selected data.

The VLOOKUP function formats cells based on their values.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which formula would you use to calculate the average of a range of cells?

MAX(range)

AVERAGE(range)

COUNT(range)

SUM(range)

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you enter the same data in multiple cells at once?

Select a single cell, type the data, and press Enter.

Highlight the entire column, type the data, and press Shift + Enter.

Right-click on the cells, choose 'Paste', and enter the data.

Select multiple cells, type the data, and press Ctrl + Enter.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you create a formula that adds values from different cells?

=ADD(A1, B1, C1)

=TOTAL(A1, B1, C1)

=SUM(A1, B1, C1)

=SUM(A1 + B1 + C1)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What function would you use to count the number of cells that contain numbers?

AVERAGE

SUM

MAXIMUM

COUNT

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?