CIS 105 - 3.15

CIS 105 - 3.15

9th - 12th Grade

5 Qs

quiz-placeholder

Similar activities

Database Quiz - St. Boniface

Database Quiz - St. Boniface

10th Grade

10 Qs

1.4 การประกอบหุ่นยนต์ POP32i ROVER

1.4 การประกอบหุ่นยนต์ POP32i ROVER

12th Grade

10 Qs

Pretest Microsoft Excell

Pretest Microsoft Excell

10th Grade

10 Qs

Google Sheets Basics

Google Sheets Basics

12th Grade

10 Qs

Getting to Know Excel!

Getting to Know Excel!

11th Grade

10 Qs

Excel Quis Before Examination

Excel Quis Before Examination

11th Grade

10 Qs

Cambridge National IT LO3 - Understanding Data!

Cambridge National IT LO3 - Understanding Data!

10th Grade

10 Qs

Lesson 01 Unit 1 Excel 2019/365 MOAC

Lesson 01 Unit 1 Excel 2019/365 MOAC

9th - 12th Grade

10 Qs

CIS 105 - 3.15

CIS 105 - 3.15

Assessment

Quiz

Computers

9th - 12th Grade

Practice Problem

Hard

Created by

NQSG International Education

FREE Resource

AI

Enhance your content in a minute

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

5 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

The rate for Year 2 is very high. What is the correct formula?

D4 = LEFT(PI()/ROW(D5),4)%

D6 =RIGHT(PI()/ROW(D5),3)%

D6 = RIGHT(PI()/ROW(D4),3)%

D5 = LEFT(PI()/ROW(D5),3)%

2.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

The age of person for Year 24 and Year 25 is the same, correct the formula.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

The rate for Year 10 is 061, what is the correct formula?

D14 =RIGHT(PI()/ROW(D13),3)%


D15 = LEFT(PI(),ROW(D13),2)%

D16 = RIGHT(PI()/ROW(D13),2)%

D14 = LEFT(PI(),ROW(D12),2)

4.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

In outputs table, the number of annual payments should be 20, correct the formula.

5.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

The total amount invested in Outputs table seems low, what is the correct formula?