Working in Open Office Calc

Working in Open Office Calc

6th Grade

10 Qs

quiz-placeholder

Similar activities

Basics of Computers

Basics of Computers

3rd - 10th Grade

10 Qs

ROUND 3 TECCASINO

ROUND 3 TECCASINO

KG - Professional Development

15 Qs

Digcit 5-6

Digcit 5-6

5th - 6th Grade

10 Qs

Quiz 8 (01.09.2021)

Quiz 8 (01.09.2021)

1st - 12th Grade

10 Qs

Play with Scratch - 1

Play with Scratch - 1

5th - 6th Grade

15 Qs

Test Yourself - Problem Solving

Test Yourself - Problem Solving

6th Grade

15 Qs

ICT Hunt

ICT Hunt

6th Grade

10 Qs

Formatting Toolbar

Formatting Toolbar

6th - 8th 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?