Deck 1: Getting Started With Excel

Question 1

What does a filename indicate?

Answer 1

File is referred as a named collection of data stored on disk document. Every file has a name and some properties. After creation of the file, it can be edited, modified and saved as per requirement. Files can be organized by storing them in folders
• Every file is identified by its name.
• Every file has dot extension. The extension indicates the type of the file.
While naming a file there are some conventions to be followed.
• File name allows you to use 0 to 255 characters; don't use special characters for file names.
• Use some common and cache names so that it can be easily remember the things in a file through filename.
• Don't change the file extension.
• Preferably, file name should be meaningful. File name should be relative to file contents.
• A filename can be renamed if necessary.

Question 2

What does a pencil symbol at the beginning of a record represent? What does a star symbol represent?

Answer 2

A pencil symbol in the beginning of the record represent that the particular record is updated or edited with data. It always appears in the beginning of the row. When you complete entering data in one record and if you press the tab key to go to next record, once when you start entering data pencil symbol moves to the current record.
• By default, pencil symbol appears in record selector portion of the table.
• That symbol is highlighted and the cell where you edit is highlighted in orange colour.
• Once when you move from the current record pencil symbol disappears from that record.
• It is also called as editing icon.
• When the pencil symbol appears the data have not saved in database table. Once when the symbol moves from that record the record is saved automatically into database table.
A star symbol always appears in record selector portion of the table which indicates next new blank row available to enter the data.
• This symbol is also highlighted when the data is entered.
• It depicts the new record, where you can enter the information.
• When you click the new button in records group on the home tab, this symbol is highlighted in the next available row.
• This symbol disappears from the previous record, once when you move to the next blank row.

Question 3

Is a file deleted from a compressed folder when you extract it?

Answer 3

It is better to compress a large file while sending because the compressed file occupies less space than uncompressed file.
• When the contents of the compressed file are extracted, a copy is displayed as uncompressed file in the specified location.
• There is no deletion of any data in the compression techniques.
• It is not possible to modify the compressed file. If the file is to be modified, the file is extracted and then the extracted file is modified. The compressed file remains the same.
• In Compression technique, there is no loss of data.
Data is not lost either when compressing the files or extracting the files.

Question 4

Explain how the saving process in Access is different from saving in other Office programs.

Question 5

What Office program would be best to use to write a letter?

Question 6

True or False: You can copy records from any Access database table and paste them in another table.

Question 7

How do you start an Office program?

Question 8

is a question you ask about the data stored in a database.

Question 9

What is the purpose of Live Preview?

Question 10

The quickest way to create a form is to use the
.

Question 11

What is Backstage view?

Question 12

To see the total number of pages in a report and navigate through the report pages, you need to display the report in ____________.

Question 13

Explain the difference between Save and Save As.

Question 14

In the Navigation Pane, each database object has a unique
to its left that identifies the object's type.

Question 15

True or False. In Protected View, you can see file contents, but you cannot edit, save, or print them until you enable editing.

Question 16

____________a database rearranges the data and objects in a database to decrease its fi le size.

Question 17

What happens if you open a fi le, make edits, and then attempt to close the file or exit the program without saving the current version of the fi le?

Question 18

a database is the process of making a copy of the database file to protect the database against loss or damage.

Question 19

What are the two ways to get Help in Office?

Question 20

What do you call a named collection of data stored on a disk?

Question 21

is a single characteristic of a person, place, object, event, or idea.

Question 22

The letter C is typically used for the __________ drive of a computer.

Question 23

You connect the records in two separate tables through a(n)
that appears in both tables.

Question 24

The term ___________ refers to any window that displays the contents of a folder.

Question 25

The
, whose values uniquely identify each record in a table, is called a(n)
, when it is placed in a second table to form a relationship between the two tables.

Question 26

Describe the difference between the left and right panes of the Windows Explorer window.

Question 27

The
is the area of the Access window that lists all the objects in a database, and it is the main control center for opening and working with database objects.

Question 28

What does the file path tell you?

Question 29

Which field does Access create, by default, as the primary key field for a new table in Datasheet view?

Question 30

True or False. The advantage of moving a fi le or folder by dragging with the right mouse button is that you can efficiently complete your work with one action.

Question 31

Which group on the FIELDS tab contains the options you use to add new fields to a table?