Quiz on Excel

Quiz on Excel

12th Grade

20 Qs

quiz-placeholder

Similar activities

Excel Quiz

Excel Quiz

KG - University

15 Qs

ULANGAN TIK KELAS 8

ULANGAN TIK KELAS 8

12th Grade

20 Qs

Mengenal Jendela dan Ikon Microsoft Excel

Mengenal Jendela dan Ikon Microsoft Excel

7th Grade - University

15 Qs

MS EXCEL BASIC COMPUTATIONS AND FUNCTIONS

MS EXCEL BASIC COMPUTATIONS AND FUNCTIONS

7th Grade - University

20 Qs

Excel Spreadsheet Intro

Excel Spreadsheet Intro

KG - University

20 Qs

Excel - Formulas, Functions & Formatting

Excel - Formulas, Functions & Formatting

10th - 12th Grade

20 Qs

Excel 2013

Excel 2013

11th - 12th Grade

15 Qs

Quiz on Excel

Quiz on Excel

Assessment

Quiz

Computers

12th Grade

Hard

Created by

Arnoldo Cimafranca

Used 7+ times

FREE Resource

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function would you use to find the maximum value in a range of cells?

A) MIN

B) AVG

C) MAX

D) SUM

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which keyboard shortcut can you use to select the entire column in Excel?

A) Ctrl + C

B) Ctrl + A

C) Ctrl + Spacebar

D) Ctrl + Enter

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the SUM function do in Excel?

A) Finds the maximum value in a range

B) Finds the average value in a range

C) Adds up all the numbers in a range

D) Finds the minimum value in a range

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function would you use to count the number of cells containing numerical values in a range?

A) COUNT

B) AVERAGE

C) SUM

D) MAX

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the ENTER key in Excel?

A) To confirm an entry or move to the next cell

B) To delete the contents of a cell

C) To undo the last action

D) To save the workbook

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function would you use to find the minimum value in a range of cells?

A) MIN

B) AVG

C) MAX

D) SUM

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of using a named range in Excel?

A) To assign a specific name to a range of cells for easier reference

B) To automatically update the range when new data is added

C) To prevent other users from editing the range

D) To apply conditional formatting to the range

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?