
Excel Formulas & Functions
Quiz
•
Computers
•
12th Grade
•
Practice Problem
•
Easy
Mradul Chitranshi
Used 2+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function is used to sum a range of cells in Excel?
SUM
RANGE
TOTAL
ADD
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you reference a cell in Excel formula?
By using the cell's border
By using the cell's font style
By using the cell's color
By using the cell's address, named ranges, or structured references.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the VLOOKUP function do in Excel?
VLOOKUP function calculates the sum of a range of cells in Excel
VLOOKUP function searches for a value in the first column of a table and returns a value in the same row from another column.
VLOOKUP function changes the font style of a cell in Excel
VLOOKUP function inserts a new row at the bottom of a table in Excel
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Explain the difference between absolute and relative cell references in Excel formulas.
Absolute cell references adjust based on the relative position of the formula, while relative cell references do not change
Absolute cell references and relative cell references are the same in Excel formulas
Absolute cell references change when copied, while relative cell references do not adjust
Absolute cell references do not change when copied, while relative cell references adjust based on the relative position of the formula.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you nest functions in Excel?
Create a new Excel file for each nested function
Combine functions in a single cell without any separation
Enter one function as an argument within another function
Use a separate worksheet for each function
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the IF function used for in Excel?
It is used to create charts in Excel
It is used to format cells in Excel
It is used to import data into Excel
It is used to perform logical tests and return different values based on the result.
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is CONCATENATE function in Excel?
Access all questions and much more by creating a free account
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
10 questions
Aspek Legal TIK
Quiz
•
12th Grade
15 questions
Herramientas de Google
Quiz
•
12th Grade - University
14 questions
TRENDS IN ICT
Quiz
•
12th Grade
14 questions
Computing figures
Quiz
•
4th - 12th Grade
10 questions
Working around Adobe Photoshop
Quiz
•
12th Grade
15 questions
Digital Etiquette
Quiz
•
4th Grade - University
15 questions
CIW
Quiz
•
9th - 12th Grade
10 questions
Word basics
Quiz
•
8th - 12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
