Formulas in Excel

Formulas in Excel

6th - 9th Grade

10 Qs

quiz-placeholder

Similar activities

SORTING OF DATA IN MICROSOFT EXCEL

SORTING OF DATA IN MICROSOFT EXCEL

6th - 8th Grade

6 Qs

Excel Formula Practice

Excel Formula Practice

9th - 12th Grade

13 Qs

IF Function - Excel

IF Function - Excel

9th - 11th Grade

10 Qs

Microsoft Excel - PH REMEDIAL & SUSULAN

Microsoft Excel - PH REMEDIAL & SUSULAN

8th Grade

11 Qs

Excel 1

Excel 1

7th - 12th Grade

10 Qs

ICT 7 QUIZ

ICT 7 QUIZ

7th Grade

10 Qs

Lembar Kerja Microosft Excel

Lembar Kerja Microosft Excel

6th Grade

10 Qs

Pengenalan Program Pengolah Angka

Pengenalan Program Pengolah Angka

8th Grade

10 Qs

Formulas in Excel

Formulas in Excel

Assessment

Quiz

Computers

6th - 9th Grade

Hard

Created by

Wayground Content

Used 10+ times

FREE Resource

10 questions

Show all answers

1.

FILL IN THE BLANK QUESTION

30 sec • 1 pt

Excel displays the error values _________ when the formula contains invalid data

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

An error that occurs when a formula is not spelt correctly

#NAME?

#VALUE!

#DIV/0!

#####

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Where is the option Autosum Present

Formulas Tab

Alignment Tab

Numbers Tab

Font Tab

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What feature is particularly useful when you want to add all numbers in a row or column

Autosum

Product

Operators

Hierarchy

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is Constants

Built in formulas

Numbers or texts values

Microsoft Excel

Call reference

6.

FILL IN THE BLANK QUESTION

30 sec • 1 pt

____________ Specify the type of Operation you want to perform

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a formulas in excel sheet

The address of the cells

The defined expression that contains values, constants, Call reference, functions and operators

Numbers or text values that can be entered directly in a formula

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?