Working in Open Office Calc

Working in Open Office Calc

6th Grade

10 Qs

quiz-placeholder

Similar activities

2.GRADE STORY 5

2.GRADE STORY 5

2nd Grade - University

15 Qs

Tiger Trivia 31-40

Tiger Trivia 31-40

6th - 8th Grade

10 Qs

History of computer

History of computer

6th - 8th Grade

10 Qs

IB CS Quiz-01

IB CS Quiz-01

1st - 6th Grade

14 Qs

Computer ch-4!

Computer ch-4!

6th Grade

11 Qs

Y10M2A2 - Selection

Y10M2A2 - Selection

6th - 10th Grade

15 Qs

Scratch Interface

Scratch Interface

6th - 8th Grade

12 Qs

Computer Basic

Computer Basic

3rd - 6th Grade

10 Qs

Working in Open Office Calc

Working in Open Office Calc

Assessment

Quiz

Computers

6th Grade

Hard

Created by

Aradhay Gautam 7

Used 48+ times

FREE Resource

AI

Enhance your content

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

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which these is not the part of Open Office Calc?

Rows and Column

Text Color

New Slide

New Sheet

Auto Sum

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How many rows does Open Office contains?

1024456

1045678

1048675

1048576

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Answer these Questions

i) How many columns does the Open Office Contains?

ii) What the name of the last column address?

i) 1024 ii) AMJ

i) 1045 ii) ZZZ

i) 2348 ii) XRT

i) 5436 ii) JBN

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

=$B$4 * $C$4

It is an example of :

Mixed Referencing

Absolute Referencing

Relative Referencing

Formula Referencing

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

Mary and Lily wrote some numbers. They wanted to add the numbers but they wanted that the numbers horizontally. But they wanted that the numbers in Lily's rows have to be added only with the number in A2 (23). So what will be the shortest trick?

There's no short trick.

She can select and press Ctrl+X and paste it in evry cell in SUM row

She will first use the formula A$2 + B2, press Enter then she can copy the result and select other areas where she want the and then Ctrl+V

She will first use the formula=A$2 + B2, press Enter then she can copy the result and select other areas where she want the and then Ctrl+V

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

While doing calculation, I used $A2 / B2.

I copy pasted it to copy this formula but:

The row did not change

The column did not change

Both column and row did not change

Both column and row changed

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Maya put the formula ' C3+D3' and then pressed Enter key. She saw that the formula did not occur. What did she miss out?

She needed to press Enter key 2 times.

She needed to press Caps Lock key

She needed to apply '=' sign at the beginning of the formula

She needed to first Copy and Paste the data in a new sheet and then press Enter.

Create a free account and access millions of resources

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

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

Already have an account?