
MS Excel Vocab 2
Authored by Kristy Griffiths
Business
10th Grade
Used 21+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of Form Controls in Excel?
To perform complex calculations
To format a worksheet to look like a form and limit user input
To create charts and graphs
To sort and filter data
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which tool allows you to copy the formatting of one cell and apply it to others?
Format Painter
Conditional Formatting
Data Validation
Cell Styles
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the Formula Calculation option in Excel allow you to do?
Automatically create charts
Define whether Excel calculates formulas automatically or manually
Format cells with colors
Protect worksheets from editing
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the function of Freeze Rows and Columns in Excel?
To lock cells for editing
To keep rows and/or columns visible while scrolling
To sort data in ascending order
To apply conditional formatting
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the GETPIVOTDATA function do?
Creates a new PivotTable
Extracts data from specified fields in a PivotTable
Sorts data in a worksheet
Filters data in a table
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which tool helps you determine how input values must change to achieve a specific goal?
Solver
Goal Seek
Data Table
Scenario Manager
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the HLOOKUP function do in Excel?
Searches for a value in the first column of a table
Searches for a value in the top row of a table and returns a value in the same column
Searches for a value in the last row of a table
Searches for a value in the last column of a table
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
15 questions
TEMA 1 MERCADOS Y ORGANIZACIONES
Quiz
•
1st Grade - University
10 questions
S2 Subject Choice Quiz
Quiz
•
8th - 10th Grade
10 questions
Rights and Responsibilities of Consumers
Quiz
•
10th Grade
10 questions
Funciones Administrativas
Quiz
•
10th Grade
20 questions
QUIZ 1 : TOPIC 8 [PROCESS COSTING]
Quiz
•
1st Grade - University
10 questions
Elements of a Contract -Business Law
Quiz
•
KG - 12th Grade
16 questions
Presentasi Bisnis
Quiz
•
10th Grade
10 questions
Obligaciones con el Ministerio de Trabajo
Quiz
•
1st Grade - University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
10 questions
Probability Practice
Quiz
•
4th Grade
15 questions
Probability on Number LIne
Quiz
•
4th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
6 questions
Appropriate Chromebook Usage
Lesson
•
7th Grade
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade