Excel Formulas and Functions Basics Practice Flashcard
Flashcard
•
Education
•
9th - 12th Grade
•
Practice Problem
•
Hard
Wayground Content
FREE Resource
Student preview

21 questions
Show all answers
1.
FLASHCARD QUESTION
Front
What does the dollar sign ($) in an Excel cell reference indicate?
Back
The cell reference is absolute.
2.
FLASHCARD QUESTION
Front
What is the difference between a cell reference and an absolute cell reference?
Back
A cell reference changes when copied, while an absolute cell reference remains constant.
3.
FLASHCARD QUESTION
Front
Which of the following is an example of a calculation operator? Text, +, Image, Font
Back
+.
4.
FLASHCARD QUESTION
Front
What does a cell reference allow you to do in Excel?
Back
Identify a cell's location in the worksheet.
5.
FLASHCARD QUESTION
Front
Which of the following best describes a constant? Options: A changing value, A fixed value entered directly into a formula, A reference to another cell, A function
Back
A fixed value entered directly into a formula
6.
FLASHCARD QUESTION
Front
What type of reference is used when referring to a cell in another workbook?
Back
External reference
7.
FLASHCARD QUESTION
Front
What is the primary purpose of a formula in Excel?
Back
To perform calculations
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
20 questions
Banking
Flashcard
•
9th - 12th Grade
13 questions
7517 03 Basic Operations in Programming Languages
Flashcard
•
9th Grade - University
15 questions
Water Cycle
Flashcard
•
8th Grade - University
15 questions
Understanding SMART Goals Components
Flashcard
•
8th Grade - University
20 questions
Readings Philippine History
Flashcard
•
KG - University
18 questions
8A REGLEMENTATION UDPS-83 EXAMEN BLANC FLASH
Flashcard
•
KG
14 questions
CADEIA ALIMENTAR
Flashcard
•
KG
12 questions
Like to vs Would like to - course 6 (2H)
Flashcard
•
9th - 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
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