Question

plz answer
1.Which of these features in Excel allows us to separate data based on a given condition?
Sorting
Filtering
Cell Referencing
Charts
2.In a spreadsheet, the columns are depicted by :-
Numbers
Alphabets
Combination of Numbers and Alphabets
Functions
3.Which of these is the correct function syntax to calculate the average of 5 numbers in A1 to A5?
=AVG(A1:A5)
AVERAGE(A1;A5)
=AVG(A1;A5)
=AVERAGE(A1:A5)
4.Which of the following remains unchanged is Mail Merge?
Merged Field
Data Source
Main Document
Merged Document
5.By default, the numbers entered in a spreadsheet are aligned to the ___________ of the cell.
Left
Right
Center
Top Left
6.Which of these is NOT a type of Referencing in a Spreadsheet?
Relative
Absolute
Conditional
Mixed
7.Under which tab will you find the option to create a chart in Excel?
View
Insert
Format
Styles
8.How many Animations can be applied on a single slide?
No limit is there
4
1
2
9.In MS-Word, how many types of page orientations are possible?
1
2
3
4
10.Which chart is best suited to compare the run rates of two teams during a cricket match after specific number of overs?
Area Chart
Pie Chart
Scatter Chart
Line Chart
11.Which feature in Excel can be used to apply red color to students getting below 40 and green color to students above 40 ?
Sorting
Conditional Formatting
Filtering
Referencing
12.What is the shortcut key to open a fresh Presentation?
CTRL+N
CTRL+O
CTRL+E
CTRL+P
13.In a Presentation Software, which view is used to reorder the slides in a presentation?
Notes Page View
Slide Sorter View
Outline View
Reading View
14.Which of the following is an online Spreadsheet Software?
Google Sheets
Google Slides
Google Forms
Google Docs
15.In MS-Word, a constant text that appears at the top of each page is called a _________
Comment
Headline
Date and Time
Header

Plz anser fast in 10 min plz its urgent​

Answer 1

Answer:

2 . In a spreadsheet, the columns are depicted by :-

Numbers

Alphabets

Combination of Numbers and Alphabets

Functions

Answer 2

Answer:

1- Filtering

2- Alphabets

3- =Average(A1:A5) NOT SURE ABOUT THIS ONE other possibility is =AVG

5- Left

7- Insert

9- 2

12- CTRL + N

13- Slide sorter view

14- Google sheets

15- Headline

I answered as many as possible