Formulas in Excel
Quiz
•
Computers
•
6th - 9th Grade
•
Practice Problem
•
Hard

Manya N
Used 302+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
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
2.
FILL IN THE BLANK QUESTION
30 sec • 1 pt
Excel displays the error values _________ when the formula contains invalid data
3.
FILL IN THE BLANK QUESTION
30 sec • 1 pt
The __________ function Is used to multiply the content Of the cells
4.
FILL IN THE BLANK QUESTION
30 sec • 1 pt
____________ Specify the type of Operation you want to perform
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
An error that occurs when a formula is not spelt correctly
#NAME?
#VALUE!
#DIV/0!
#####
6.
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
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The call references contain values to be used for calculation passed to the function are called
Arguments
Operators
Product
Autosum
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
15 questions
Hardware y Software 7°
Quiz
•
7th Grade
13 questions
WJEC GCSE ICT Unit 1 E-Mail
Quiz
•
9th - 10th Grade
10 questions
Kuis Pengayaan (Aplikasi Sehari-hari?
Quiz
•
9th Grade
10 questions
Scratch
Quiz
•
KG - Professional Dev...
12 questions
Adventure game project
Quiz
•
7th - 8th Grade
15 questions
Cyber Security KS4
Quiz
•
8th - 12th Grade
15 questions
LA1.C1: Introduction to Small Basic
Quiz
•
9th Grade
10 questions
Pretest Pengolahan Data Dasar
Quiz
•
7th Grade
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
