What is an advanage of a database?

Can search through and find information quickly

Which of the following statements best defines the word 'database'?

A database is a collection of data or information which is structured and organized

A database is a collection of statistics stored only for computers.

A database does not collect data or information.

Which of the following is the correct definition of a Record?

All information about a single entity.

It has only one type of information

Constraints on primary key are

Cannot be left null and cannot have duplicate value

Can be left null and cannot have duplicate value

Cannot be left null and can have duplicate value

Can be left null and can have duplicate value.

A structured collection of information

A device to load information onto the computer

A piece of software to do calculations

If I set this condition what would happen?

It would only keep rows with empty cells in

It would keep some rows with empty cells

Which of the following represent the three sections of Data Validation found within the Data Validation dialogue box?

Settings, Input Message, Error Alert

Dates & Times, Numbers and Text

Data, Data Criteria, Data Validation

Study the screenshot above. What is the message (circled in yellow) called?

It is called an Error Alert Message.

Where can I find the option to create a customized error message?

Under the Data tab on the Ribbon, in the Data Tools group.

Under the Insert tab on the Ribbon, in the Text group.

Under the Review tab on the Ribbon, in the Changes group.

All of the options listed above are correct.

To remove all data validation rules that have been applied to a worksheet, you must:

Select the whole sheet and in the Data Validation dialogue box, select Clear All .

Select the whole sheet and press the Delete button on your keyboard.

Select the whole sheet, click the dropdown arrow next to the Data Validation button and select Clear Validation Circles .

Select the whole sheet, right-click the sheet and select Clear Contents.

Study the screenshot above. Is it possible to change the wording of the error message?

Yes, by typing the title and error message into the Error Alert section of the Data Validation dialogue box.

Yes, by right-clicking the error message and selecting Edit from the menu list. Then type the relevant title and message into the box.

No, this is a built-in function in Excel and cannot easily be edited.

Yes, by creating an Error Message Text Box in the Text group under the Insert tab on the Ribbon.

Priscilla wants to ensure that in a Date column on her worksheet, dates that fall BEFORE 1 January 2015 cannot be entered. How can she achieve this?

She should select Date as a Data Validation Criteria. Select Greater than or equal to in the Data box and insert 1 January 2015 as the Start Date

She should select Date as a Data Validation Criteria. It will automatically adjust the dates allowed to be after 1 January 2015.

She should type 1 January 2015 into the first cell of the Date column and then select Date as a Data Validation Criteria.

She should select Date as a Data Validation Criteria. Select Less than or equal to in the Data box and insert 1 January 2015 as the Start Date.

Kirsty, an Office Manager, created a feedback form in Excel that everyone in the office will complete a copy of. She wants to prevent staff from writing more than 500 words in the comments box. How can she achieve this?

She can set Text Length to be Less than 500 characters.

She can insert an Input Message stating that no more than 500 characters are allowed.

She can size the comment box so that users cannot enter more than 500 characters.

She can insert an Error Message stating that no more than 500 characters are allowed.

To extend Data Validation, for example a Data Validation List, to cells that it is not applied to yet, I can:

Both option I and II are correct

I. Recreate the Data Validation list by selecting the existing cells as well as the additional cells and reapplying the Data Validation Criteria to it.

II. I can copy and paste a cell to which the Data Validation Criteria is applied, to additional cells.

Neither of the options listed are correct.

What is data validation in Excel?

Data validation in Excel is a feature that allows you to control the type and format of data entered into a cell or range of cells.

Data validation in Excel is a feature that allows you to create charts and graphs based on your data.

Data validation in Excel is a feature that allows you to sort and filter data in a worksheet.

Data validation in Excel is a feature that allows you to merge cells and format text in a worksheet.

Name two subtopics related to Excel data validation.

cell formatting and conditional formatting

What is an input message in Excel data validation?

A message that appears when a user selects a cell with data validation applied.

A message that appears when a user enters invalid data in a cell.

A message that appears when a user deletes data from a cell.

A message that appears when a user copies data from a cell.

What is an error alert in Excel data validation?

An error alert in Excel data validation is a message that appears when a user enters invalid data into a cell that has data validation applied.

An error alert in Excel data validation is a feature that automatically corrects any invalid data entered into a cell.

An error alert in Excel data validation is a warning that appears when a user enters valid data into a cell that has data validation applied.

An error alert in Excel data validation is a message that appears when a user enters valid data into a cell that has no data validation applied.

Excel Database and Data Validation

Authored by Eileen Tong

Computers

7th Grade

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

59 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

___ is considered to be a single row

record

cell

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

_____ is used to specify the type of data that can be entered in a celll

input message

data validation

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This alerts users by displaying an error message if invalid data is typed in a cell

Error Alert

Filter

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This icon represents

Auto sum

Sort and Filter

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This icon stands for

Filter

Data Validation

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The structure of Database is made up of _____________

Fields

Records

Both Fields and Records

None

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

_____________ allows you to set certain rules to restrict the type of data or values to be entered in a cell.

Criteria

Data Validation

Field Name

All the above

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

57 questions

CIW Prep Complete

Quiz

•

7th - 8th Grade

64 questions

La carcasa y la fuente de alimentación

Quiz

•

6th - 12th Grade

60 questions

LV3_K8BaiOn01_2023-2024

Quiz

•

6th - 8th Grade

60 questions

Job Vocabulary Version 1

Quiz

•

7th Grade

55 questions

Quiz-LAtihan Soal-Soal-UTS-Perancangan dan Pemrograman Web

Quiz

•

KG - University

63 questions

Đề cương Tin Học

Quiz

•

7th Grade

59 questions

ICT-software and HTML

Quiz

•

6th - 8th Grade

60 questions

TIN6_ÔN TẬP HKI_2425

Quiz

•

6th Grade - University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

10 questions

Exploring Digital Citizenship Essentials

Interactive video

•

6th - 10th Grade

Excel Database and Data Validation

___ is considered to be a single row

_____ is used to specify the type of data that can be entered in a celll

This alerts users by displaying an error message if invalid data is typed in a cell

This icon represents

This icon stands for

The structure of Database is made up of _____________

_____________ allows you to set certain rules to restrict the type of data or values to be entered in a cell.

What is an advanage of a database?

Which of the following statements best defines the word 'database'?

All the information about a person or a thing is called?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers