Electronic Spreadsheet

Electronic Spreadsheet

10th Grade

40 Qs

quiz-placeholder

Similar activities

Data Representation Unit

Data Representation Unit

9th - 11th Grade

43 Qs

REMEDIAL AAS INFORMATIKA

REMEDIAL AAS INFORMATIKA

10th Grade

40 Qs

Soal informatika TIK dan BK

Soal informatika TIK dan BK

10th Grade

35 Qs

Quiz Profesi dan Kewirausahaan

Quiz Profesi dan Kewirausahaan

10th Grade

40 Qs

Year 8 Assessment Autumn 1

Year 8 Assessment Autumn 1

10th Grade

35 Qs

WJEC ICT Unit 3 Mock Revision

WJEC ICT Unit 3 Mock Revision

10th - 11th Grade

40 Qs

Computer History & Hardware

Computer History & Hardware

9th - 12th Grade

40 Qs

PTS SEMESTER GENAP

PTS SEMESTER GENAP

10th Grade

40 Qs

Electronic Spreadsheet

Electronic Spreadsheet

Assessment

Quiz

Computers

10th Grade

Practice Problem

Hard

Created by

Nirender Prakash Singh

Used 126+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

40 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

______________ allows you to combine data from multiple worksheets into a single master worksheet.

Data Consolidation

Multiple Data

Scenarios

Goal Seek

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

________ series of worksheets or workbooks summarizes it into a single worksheet.

Multiple Data

Data Consolidation

Scenarios

Goal Seek

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function cannot be performed through Subtotal in a Spreadsheet?

Sum

Product

Average

Percentage

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Scenarios are a tool to test questions.

Auto

Goal Seek

What-If

Drop Down

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When making a watermark or putting an image in the backdrop of a document, _______ comes in useful.

Transparency

Fill

Filters

Crop

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

It refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want a formula to calculate.

Row

Column

Auto Sum

Cell Reference

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

______, totals/adds data arranged in an array—that is, a group of cells with labels for columns and/or rows Which step one must follow before using the Subtotal option?

Consolidate

Rename Data

Filter Data

Subtotal

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?