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

Quiz

•

Computers

•

7th Grade

•

Practice Problem

•

Hard

Eileen Tong

Used 1+ times

FREE Resource

59 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

___ is considered to be a single row

record

cell

2.

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

3.

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

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This icon represents

Auto sum

Sort and Filter

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This icon stands for

Filter

Data Validation

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The structure of Database is made up of _____________

Fields

Records

Both Fields and Records

None

7.

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

Create a free account and access millions of resources

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

54 questions

History of Computer and Kinds of Computer

Quiz

•

7th - 9th Grade

62 questions

Quiz sobre Agricultura de Precisão

Quiz

•

6th - 8th Grade

57 questions

Ulangkaji ASK T1 Bab 2.2 Ukuran Data

Quiz

•

1st - 12th Grade

61 questions

Computer Basics Test

Quiz

•

6th - 8th Grade

55 questions

Social Media

Quiz

•

6th - 8th Grade

60 questions

Analisis Data

Quiz

•

5th Grade - University

57 questions

Python начало

Quiz

•

7th Grade

60 questions

Computer and Online Essentials.

Quiz

•

7th Grade

Popular Resources on Wayground

5 questions

This is not a...winter edition (Drawing game)

Quiz

•

1st - 5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

Identify Iconic Christmas Movie Scenes

Interactive video

•

6th - 10th Grade

20 questions

Christmas Trivia

Quiz

•

6th - 8th Grade

18 questions

Kids Christmas Trivia

Quiz

•

KG - 5th Grade

11 questions

How well do you know your Christmas Characters?

Lesson

•

3rd Grade

14 questions

Christmas Trivia

Quiz

•

5th Grade

20 questions

How the Grinch Stole Christmas

Quiz

•

5th Grade

Discover more resources for Computers

18 questions

Company Logos

Quiz

•

6th - 8th Grade

Excel Database and Data Validation

59 questions

___ 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?

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers