IT 402 CBSE Class 10 Unit 2 Electronic Spreadsheet | 152 plays

IT 402 CBSE Class 10 Unit 2 Electronic Spreadsheet

Assessment

•

Shailendra Mishra

•

Computers

•

8th - 10th Grade

•

152 plays

•

Medium

Student preview

17 questions

Show answers

1.

Multiple Choice

30 sec

5 pts

__________ allows you to gather data from different worksheets into a master worksheet.

Goal Seek

Solver

Data Consolidation

Total Data

2.

Multiple Choice

30 sec

5 pts

Consolidate option is available under __________ menu.

Tool

Insert

Data

View

3.

Multiple Choice

30 sec

5 pts

We can consolidate data by ___________

Row Label

Column Label

Both Row and Column Label

None of them

4.

Multiple Choice

30 sec

5 pts

Which of the following functions are available in consolidate window?

Max

Sum

Count

All of the above

5.

Multiple Choice

30 sec

5 pts

If you select ________ then any values modified in the source range are automatically updated in the target range.

Link to source data

Link to sheet data

Link to original data

Link to source range

Explore all questions with a free account

or continue with

Microsoft

Apple

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Find a similar activity

Create activity tailored to your needs using

15 questions

Spreadsheet Advanced Quiz 3

•

9th Grade

15 questions

spread1

•

10th Grade

15 questions

Open Office Calc

•

10th Grade

20 questions

Gr-X -IA-2-MSA(2021-22)

•

10th Grade

15 questions

Calc Session 1 LibreOffice

•

10th Grade

15 questions

Spreadsheet

•

9th - 10th Grade

12 questions

Spreadsheet

•

9th - 10th Grade

13 questions

Analyze data using scenarios and Goal seek

•

10th Grade