Quiz Questions On Microsoft Excel And Access!

1.

What is the maximum number of rows in Microsoft Excel 2003?

A.

65535
B.

65555
C.

65536
D.

65545
E.

65575

Correct Answer
C. 65536

Explanation
The maximum number of rows in Microsoft Excel 2003 is 65536. This means that Excel 2003 can have up to 65536 rows of data in a single worksheet.

Rate this question:

2.

What is the first spreadsheet application created by Microsoft before Excel?

Correct Answer
Multiplan
Multi-plan
Microsoft Multiplan

Explanation
Multiplan is the correct answer because it was the first spreadsheet application created by Microsoft before Excel. It was released in 1982 and was initially developed for CP/M operating system. Multiplan was later replaced by Excel, which was introduced in 1985 and became the dominant spreadsheet application.

Rate this question:

4

3.

In Microsoft Access, each table has a unique key called what?

Correct Answer
primary key

Explanation
In Microsoft Access, each table has a unique key called a primary key. The primary key is used to uniquely identify each record in the table. It ensures that there are no duplicate records and allows for efficient searching and sorting of data. The primary key can be a single field or a combination of fields, and it is essential for maintaining data integrity and establishing relationships between tables.

Rate this question:

4

4.

What is the data type if you want it to increment automatically?

Correct Answer
auto-number
autonumber

Explanation
The correct answer is "auto-number" or "autonumber". This data type is used when you want a field to automatically increment its value. It is commonly used in databases to assign a unique identifier to each record without manual input. By using this data type, the system will automatically generate and assign a new number to each new record, ensuring that each record has a unique identifier.

Rate this question:

4

5.

Database application of Microsoft Office?

Correct Answer
Access
Microsoft Access
MS Access

Explanation
Access, Microsoft Access, and MS Access are all correct answers for the question "Database application of Microsoft Office?" This is because Access is a database management system (DBMS) that is part of the Microsoft Office suite. It allows users to create and manage databases, build forms and reports, and perform data analysis and queries. Microsoft Access and MS Access are alternative names for the same software, so all three options are valid answers to the question.

Rate this question:

1

4 0

6.

Latest version of Microsoft Access for Windows?

Correct Answer
2007

Explanation
The latest version of Microsoft Access for Windows is 2007.

Rate this question:

4

7.

Maximum numbers of column in Microsoft Excel 2003?

Correct Answer
256

Explanation
Microsoft Excel 2003 has a maximum limit of 256 columns. This means that you can have a total of 256 columns in a single worksheet. This limitation is specific to Excel 2003 and later versions have increased the number of columns available.

Rate this question:

4

8.

CSV stands for? (Without dash)

Correct Answer
Comma Separated Value

Explanation
CSV stands for Comma Separated Value. It is a file format used to store and exchange data in a tabular form, where each value is separated by a comma. CSV files are commonly used for importing and exporting data between different applications, such as spreadsheets and databases, due to their simplicity and compatibility with various software.

Rate this question:

4

9.

Default file extension of Microsoft Excel 2003 Workbook?

Correct Answer
xls
.xls

Explanation
The default file extension for Microsoft Excel 2003 Workbook is xls. This file extension is used to indicate that the file is a workbook created using Excel 2003. The .xls extension is widely recognized and compatible with various versions of Excel, making it the default choice for saving Excel 2003 workbooks.

Rate this question:

4

10.

Default file extension of Microsoft Excel 2007 Workbook?

Correct Answer
xlsx
.xlsx

Explanation
The default file extension for Microsoft Excel 2007 Workbook is xlsx. This extension is used to identify files that are created and saved in the Microsoft Excel 2007 format. The ".xlsx" extension indicates that the file is a workbook created using Excel 2007 or a later version. The second option, ".xlsx", is redundant and unnecessary as it is already covered by the first option. Therefore, the correct answer is xlsx.

Rate this question:

4

11.

Default file extension of Microsoft Access 2003?

Correct Answer
mdb
.mdb

Explanation
The default file extension for Microsoft Access 2003 is "mdb". This file extension is used to identify and open Access database files in the 2003 version of the software. The ".mdb" extension is commonly associated with Access databases and allows users to easily recognize and access their database files.

Rate this question:

4

12.

Term used to link tables in Microsoft Access database?

Correct Answer
relationship

Explanation
In Microsoft Access database, the term "relationship" is used to link tables. This means that the tables are connected to each other based on a common field or key. By establishing relationships between tables, it becomes easier to retrieve and analyze data from multiple tables simultaneously. This allows for efficient data management and avoids data duplication.

Rate this question:

4

13.

Maximum capacity of Microsoft Access 2003? (How many GB?)

Correct Answer
2

14.

Alternative to Microsoft Office products that was created by Oracle (Sun Microsystems)?

Correct Answer
OpenOffice.org
Open Office
Star Office
StarOffice
Open Office.org

Explanation
The alternative to Microsoft Office products that was created by Oracle (Sun Microsystems) is OpenOffice.org, also known as Open Office. Another alternative is Star Office, which was also developed by Sun Microsystems. These software suites provide similar functionality to Microsoft Office, including word processing, spreadsheet, presentation, and database applications. OpenOffice.org and Star Office offer a free and open-source alternative to Microsoft Office, allowing users to create and edit documents without the need for purchasing a license.

Rate this question:

4

15.

Used to create graphical representation of data in Microsoft Excel?

Correct Answer
Chart
Chart Wizard

Explanation
The correct answer is "Chart, Chart Wizard". In Microsoft Excel, a chart is used to create a graphical representation of data. It helps to visualize and analyze data trends and patterns. The Chart Wizard is a tool in Excel that guides users through the process of creating a chart. It provides various options and customization settings to create visually appealing and informative charts.

Rate this question:

4

16.

Can Excel export files directly to PDF?

A.

Yes
B.

No

Correct Answer
B. No

Explanation
Excel does not have a built-in feature to directly export files to PDF. However, there are alternative methods to convert Excel files to PDF format, such as using third-party add-ins or using the "Save As" option and selecting PDF as the file format. Therefore, the correct answer is "No".

Rate this question:

17.

Used to copy the formatting of text or cell in Microsoft Excel?

Correct Answer
Format Painter

Explanation
The Format Painter tool in Microsoft Excel is used to copy the formatting of text or cells. It allows users to quickly apply the same formatting, such as font style, size, color, and cell borders, to other cells or ranges within the worksheet. This tool saves time and effort by eliminating the need to manually format each cell individually. By selecting a cell with the desired formatting and using the Format Painter tool, users can easily apply that formatting to other cells with a single click.

Rate this question:

4

18.

In Microsoft Excel, the Increase Decimal and Decrease Decimal button is located in what toolbar?

Correct Answer
Formatting Toolbar
Formatting

Explanation
The Increase Decimal and Decrease Decimal buttons in Microsoft Excel are used to adjust the number of decimal places displayed in a cell. These buttons are located in the Formatting Toolbar, which is a toolbar that contains various formatting options for cells, such as font style, size, alignment, and borders. Therefore, the correct answer is Formatting Toolbar.

Rate this question:

4

19.

What is the default page orientation in Microsoft Excel?

Correct Answer
portait

Explanation
The default page orientation in Microsoft Excel is portrait. This means that the page is set up vertically, with the longer side of the paper running from top to bottom. This is the standard orientation for most documents and is commonly used for printing and viewing spreadsheets in Excel.

Rate this question:

4

20.

What is the default number of Worksheet in a new Microsoft Excel Workbook?

Correct Answer
3

Explanation
The default number of worksheets in a new Microsoft Excel Workbook is 3. This means that when you open a new workbook in Excel, it will automatically have three blank worksheets for you to work with. These worksheets can be used to organize and analyze data in separate tabs within the workbook.

Rate this question:

4

21.

Used to get the sum of multiple cells' value using one button in Microsoft Excel?

Correct Answer
AutoSum

Explanation
AutoSum is a feature in Microsoft Excel that allows users to quickly calculate the sum of multiple cells' values by using a single button. It automatically selects a range of cells based on the adjacent data and inserts the SUM function to calculate the total. This saves time and effort for users who need to perform frequent summations in their spreadsheets.

Rate this question:

4

22.

In Microsoft Excel, what is the default category in Format Cell?

Correct Answer
General

Explanation
The default category in Format Cell in Microsoft Excel is General. This category is used for general formatting and does not apply any specific formatting to the cell. It is the most basic format category and is typically used for displaying numbers and text in their default format without any additional formatting options applied.

Rate this question:

4

23.

What is the name of the first cell from the upper left in Microsoft Excel?

Correct Answer
A1

Explanation
A1 is the correct answer because in Microsoft Excel, cells are identified by a combination of a letter and a number. The letter represents the column, and the number represents the row. A1 refers to the first cell in the first column and first row, which is the cell located in the upper left corner of the spreadsheet.

Rate this question:

4

24.

In Microsoft Excel, Sort Ascending and Sort Descending is located in what toolbar:

Correct Answer
Standard Toolbar
Standard

Explanation
Sort Ascending and Sort Descending options in Microsoft Excel are located in the Standard Toolbar. The Standard Toolbar is a common toolbar in Excel that contains various commands and functions for managing and formatting data. It provides quick access to commonly used tools, including sorting options. Therefore, the correct answer is Standard Toolbar.

Rate this question:

4

25.

Function used to get the maximum number in the selection of cells in Microsoft Excel?

Correct Answer
Max

Explanation
The function "Max" is used to find the maximum number in a selection of cells in Microsoft Excel. It takes multiple arguments and returns the largest value among them. By using this function, users can easily identify the highest value within a range of cells, which can be useful for various calculations and data analysis tasks.

Rate this question:

4

26.

Web alternative to Microsoft Word or Excel created by Google?

Correct Answer
Google Docs
Docs

Explanation
Google Docs is a web-based alternative to Microsoft Word or Excel created by Google. It allows users to create, edit, and collaborate on documents, spreadsheets, and presentations online. With Google Docs, multiple users can work on the same document simultaneously, making it a convenient tool for teamwork and remote collaboration. It also offers cloud storage, automatic saving, and easy sharing options. Overall, Google Docs provides a free and accessible platform for creating and managing various types of documents online.

Rate this question:

4

27.

Used to create link in Microsoft Excel?

Correct Answer
Hyperlink
Hyperlink button

Explanation
In Microsoft Excel, the "Hyperlink" and "Hyperlink button" options are used to create links. A hyperlink is a clickable element that allows users to navigate to a different location within the workbook, to a different file, or to a website. The "Hyperlink" option allows users to directly insert a hyperlink into a cell or a shape, while the "Hyperlink button" is a toolbar button that provides a quick way to create and manage hyperlinks. Both options serve the same purpose of creating links in Excel.

Rate this question:

4

28.

Used to put notes in Microsoft Excel?

Correct Answer
Comment
Comments

Explanation
In Microsoft Excel, the "Comment" and "Comments" options are used to put notes or annotations on specific cells or ranges. These notes can provide additional information or explanations about the data in the cell, making it easier for others to understand and interpret the spreadsheet. By using comments, users can add context or reminders without affecting the actual data or calculations in the worksheet. The "Comment" option is used to insert a single comment on a selected cell, while the "Comments" option allows for multiple comments to be inserted on different cells.

Rate this question:

4

29.

Used to link another table to the current one with primary key?

Correct Answer
Foreign Key

Explanation
A foreign key is used to link another table to the current one with a primary key. It is a field or a combination of fields in a table that refers to the primary key of another table. This establishes a relationship between the two tables, allowing data to be shared and referenced between them. The foreign key ensures data integrity by enforcing referential integrity constraints, meaning that the values in the foreign key column must match the values in the primary key column of the referenced table.

Rate this question:

1

4 0

30.

Place where you can see the data of your cell?

Correct Answer
Formula Bar

Explanation
The formula bar is the place where you can see the data of your cell. It is located at the top of the Excel window, just below the ribbon. The formula bar displays the contents of the selected cell, including any formulas or data entered into it. It allows you to view and edit the contents of the cell, making it a useful tool for working with data in Excel.

Rate this question:

4

31.

Used to filter data and get specific fields in Microsoft Access?

Correct Answer
Queries

Explanation
Queries in Microsoft Access are used to filter and retrieve specific data from a database. They allow users to define criteria and conditions to extract the desired information from one or more tables. By specifying fields, sorting orders, and filtering conditions, queries can efficiently retrieve the required data, eliminating the need to manually search through large amounts of data. Therefore, queries are an essential tool in Microsoft Access for data analysis and reporting purposes.

Rate this question:

4

32.

Default text length in Microsoft Access 2003?

Correct Answer
50

Explanation
The default text length in Microsoft Access 2003 is 50 characters. This means that when creating a text field in a database table, the maximum number of characters allowed in that field is set to 50 by default. However, this default length can be changed or customized based on the specific needs of the database design.

Rate this question:

4

33.

In Microsoft Access, the Relationship is located in what Menu?

Correct Answer
Tools

Explanation
In Microsoft Access, the Relationship feature can be found in the "Tools" menu. This menu provides various tools and options for managing and organizing the database, including the ability to define relationships between tables. By selecting the "Tools" menu, users can access the Relationship feature and establish connections between tables, which helps in maintaining data integrity and improving data analysis capabilities.

Rate this question:

4

34.

Used to put text or content in all top and bottom part of pages in Microsoft Word or Excel?

Correct Answer
Header and Footer

Explanation
Header and Footer is a feature in Microsoft Word or Excel that allows users to insert text or content at the top and bottom of each page. This feature is commonly used to display information such as page numbers, document title, author name, date, and other relevant details that need to be consistent throughout the document. By using the Header and Footer feature, users can easily add and customize these elements, ensuring a professional and organized appearance for their documents.

Rate this question:

4

35.

Used to check for spelling and other errors?

Correct Answer
Spell Checker

Explanation
A spell checker is a tool or software used to identify and correct spelling errors in written text. It helps to ensure that words are spelled correctly and can also detect other errors such as incorrect grammar, punctuation, and capitalization. This tool is commonly used in word processing software, email clients, and web browsers to improve the accuracy and readability of written content. By highlighting and suggesting corrections for misspelled words, a spell checker helps users produce error-free and professional-looking documents.

Rate this question:

4

36.

Default data type for Foreign Key?

Correct Answer
Number

Explanation
The default data type for a foreign key is typically a number. This is because foreign keys are used to establish a relationship between two tables in a database, where the primary key of one table is referenced in another table. The primary key is usually a numeric value, and therefore the foreign key data type is also set as a number to match the primary key data type. This allows for efficient indexing and querying of the related data.

Rate this question:

4

37.

Microsoft Excel was created initially for what Operating System?

Correct Answer
Mac
Macintosh

Explanation
Microsoft Excel was initially created for the Macintosh operating system. The software was developed by Microsoft specifically for Mac users, providing them with a powerful tool for creating spreadsheets and performing data analysis. The early versions of Excel were exclusively available for Macintosh computers before Microsoft eventually released versions for other operating systems such as Windows.

Rate this question:

4

38.

To replace multiple instances of a text or data, you can use what feature of Microsoft Excel?

Correct Answer
Find and Replace
Replace

Explanation
To replace multiple instances of a text or data in Microsoft Excel, you can use the "Find and Replace" feature. This feature allows you to search for a specific text or data and replace it with another value throughout the entire worksheet or selected range. By using this feature, you can quickly and efficiently make changes to multiple cells or formulas without manually editing each one individually. The "Replace" option is a part of the "Find and Replace" feature, which specifically replaces the searched text or data with a new value.

Rate this question:

4

39.

What is the color of Microsoft Excel?

Correct Answer
Green

Explanation
Microsoft Excel is commonly associated with the color green because the default color scheme used in Excel has a green color theme. This includes the green color used for the Excel logo and various elements within the software interface. Additionally, the green color is often used to represent financial data and calculations, which are commonly performed in Excel. Therefore, the color green is closely associated with Microsoft Excel.

Rate this question:

4

40.

Can you save an Excel Worksheet to a webpage?

A.

Yes
B.

No

Correct Answer
A. Yes

Explanation
Yes, you can save an Excel Worksheet to a webpage. Excel provides the option to save a worksheet as a webpage, which converts the worksheet into an HTML file that can be viewed and accessed through a web browser. This allows users to share and publish their Excel data on the web, making it accessible to a wider audience. By saving as a webpage, the Excel worksheet retains its formatting, formulas, and other features, ensuring that the data is accurately represented on the webpage.

Rate this question:

41.

Used to fill the text / cell with background color?

Correct Answer
Fill Color

Explanation
The term "Fill Color" refers to the action of filling a text or cell with a background color. It is a feature commonly found in various software applications, such as word processors or spreadsheet programs, that allows users to enhance the visual appearance of their documents or data by adding color to specific areas. By selecting the "Fill Color" option, users can choose from a range of colors to apply as the background color for the selected text or cell.

Rate this question:

4