
Excel Basics: Formulas and Formatting
Quiz
•
Information Technology (IT)
•
8th Grade
•
Practice Problem
•
Medium
Ryan Trainer
Used 1+ times
FREE Resource
Enhance your content in a minute
11 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to add the values in cells A1 and B1 in Excel?
`=A1+B1`
`=SUM(A1:B1)`
`=ADD(A1, B1)`
`=A1&B1`
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you subtract the value in cell B2 from the value in cell A2?
`=A2-B2`
`=SUBTRACT(A2, B2)`
`=B2-A2`
`=A2/B2`
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula multiplies the values in cells C1 and D1?
`=C1*D1`
`=MULTIPLY(C1, D1)`
`=C1+D1`
`=C1/D1`
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the correct formula to divide the value in cell E1 by the value in cell F1?
`=E1/F1`
`=DIVIDE(E1, F1)`
`=E1*F1`
`=F1/E1`
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you format a cell to display numbers as currency in Excel?
Use the "Number" format
Use the "Currency" format
Use the "Text" format
Use the "General" format
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you apply a border to a cell in Excel?
Use the "Fill" option
Use the "Font" option
Use the "Borders" option
Use the "Alignment" option
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula would you use to add up all the values in a column from A1 to A10?
`=ADD(A1:A10)`
`=SUM(A1:A10)`
`=TOTAL(A1:A10)`
`=A1+A10`
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
Digital Literacy Quiz
Quiz
•
7th - 12th Grade
10 questions
Keyboard
Quiz
•
8th Grade
9 questions
Binary, Decimal, Hexadecimal Knowledge
Quiz
•
7th Grade - University
10 questions
Input and Output Devices Challenge
Quiz
•
7th Grade - University
16 questions
HTML Level 1
Quiz
•
8th Grade - University
15 questions
Microbit + Servo
Quiz
•
8th Grade
15 questions
8.º - Segurança Ambientes Digitais
Quiz
•
8th Grade
10 questions
Military IT Roles Quiz
Quiz
•
8th 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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th 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
Discover more resources for Information Technology (IT)
10 questions
Understanding Poetry and Literary Devices
Interactive video
•
4th - 8th Grade
14 questions
finding slope from a graph
Quiz
•
8th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
20 questions
Laws of Exponents
Quiz
•
8th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
12 questions
8th U5L9 Linear Models
Quiz
•
8th Grade
15 questions
Making Inferences
Quiz
•
7th - 12th Grade
15 questions
Main Idea and Supporting Details.
Quiz
•
4th - 11th Grade
