MS EXCEL FORMULAS, FUNCTIONS AND ANALYSIS
Authored by Mamta Gambhir
Computers
6th - 8th Grade
Used 271+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Referencing in =$B3+B$4 formula is
Absolute
Relative
Mixed
Proper
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
To arrange data in ascending order of age we will
Filter it
Sort it
Apply Conditional Formatting
Rearrange data manually
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
To display only those records where temperature is below 0 degree you will
Manually extract the data
Sort the data
Filter the data
Use Goto option
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
To colour those cells blue where temperature is above 50 degree you will
Apply filtering
Use fill colour option
Shade Cells
Use Conditional Formatting
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
The various elements of a chart are
data label, chart title, legend
data legend, chart title, label
chart legend. chart label, chart title
none of the above
6.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
To change chart layout, style, type of inserted chart you need to go to
Format Tab
Insert Tab
Design Tab
View Tab
7.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
To display the date and time in a manner such that it gets updated automatically you will
Type Date/Time and update it time to time
Use Date and TIme function
Use Today function
Use Now function
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 Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
