FTC Data Week 16

FTC Data Week 16

University

14 Qs

quiz-placeholder

Similar activities

MS Access Database

MS Access Database

KG - University

10 Qs

EFC Practice Quiz

EFC Practice Quiz

University

15 Qs

Quiz Microsoft Excel

Quiz Microsoft Excel

9th Grade - University

15 Qs

KUIS 4 TILDA

KUIS 4 TILDA

University

10 Qs

DBMS

DBMS

University

10 Qs

Microsoft Excel

Microsoft Excel

University

15 Qs

ფინანსური ფუნქციები

ფინანსური ფუნქციები

University

11 Qs

FTC Data Week 16

FTC Data Week 16

Assessment

Quiz

Computers

University

Medium

Created by

David Remon

Used 2+ times

FREE Resource

14 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a method of data validation?

Presence check

Length check

Check digit

Sorting

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What function can be used in Excel to check if a field contains a required character?

=LEN()

=SEARCH()

=IF()

=MOD()

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of a check digit in data validation?

To limit the number of characters in a field

To ensure the format of an entry is correct

To verify the accuracy of an entry using an algorithm

To prevent duplicate data entry

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the main purpose of reviewing external systems for consistency?

To remove duplicate records

To compare entered data against external databases

To improve spreadsheet formatting

To ensure data is stored securely

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the Present Value (PV) function calculate?

The value of an investment at a future date

The interest rate applied to an investment

The depreciation of an asset

The value of an amount in today’s terms

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the difference between Present Value (PV) and Future Value (FV)?

PV calculates how much a future amount is worth today, while FV calculates how much an amount today will be worth in the future

PV is always greater than FV

FV is used for loans, while PV is used for investments

There is no difference; they are the same

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which Excel function calculates the future value of an investment with a variable interest rate?

PV()

FV()

FVSCHEDULE()

RATE()

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?