Smart University - Microsoft Excel 2007 Part 1 And 2

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Cbz999
C
Cbz999
Community Contributor
Quizzes Created: 3 | Total Attempts: 283
| Attempts: 173 | Questions: 15
Please wait...
Question 1 / 15
0 %
0/100
Score 0/100
1. In Microsoft Excel, you use the ___________________ to issue commands (actions you want to take in the spreadsheet).

Explanation

In Microsoft Excel, the ribbon is used to issue commands or actions in the spreadsheet. The ribbon is a graphical control element that contains various tabs, each with specific commands and options related to different tasks. By clicking on the tabs and selecting the desired options from the dropdown menus, users can perform actions such as formatting cells, adding formulas, inserting charts, and more. The ribbon provides an intuitive and organized interface for users to navigate and access the different features and functionalities of Excel.

Submit
Please wait...
About This Quiz
Smart University - Microsoft Excel 2007 Part 1 And 2 - Quiz

This is a quiz to test skills learned in the Smart University Learning Microsoft Excel 2007 Parts 1 and 2.

Enjoy.

Tell us your name to personalize your report, certificate & get on the leaderboard!
2. A _____________ is the intersection point of a column and a row.

Explanation

A cell is the intersection point of a column and a row. In a table or spreadsheet, columns are arranged vertically while rows are arranged horizontally. Each cell represents a unique position where a column and a row meet. It is where data can be entered, edited, or displayed. Cells are the basic building blocks of a table or spreadsheet, allowing for the organization and manipulation of data in a structured manner.

Submit
3. __________________ run vertically in a spreadsheet.

Explanation

In a spreadsheet, columns run vertically. They are the vertical sections labeled with letters at the top of the spreadsheet. Each column represents a different category or type of data. Multiple columns can be used to organize and display information in a structured manner.

Submit
4. _________________ run horizontally in a spreadsheet.

Explanation

Rows run horizontally in a spreadsheet. A row is a series of cells that are arranged horizontally from left to right. It represents a set of data or information that is organized in a horizontal line. In a spreadsheet, multiple rows are used to display and organize data in a tabular format. Each row is identified by a number, starting from 1, and can contain various types of information such as text, numbers, or formulas. Therefore, the correct answer is "row, rows".

Submit
5. Columns are identified by a _______________ .

Explanation

Columns in a table are typically identified by a letter, such as A, B, C, etc. Each column represents a specific attribute or field in the table, and the letter serves as a unique identifier for that column. This allows users to reference and manipulate data within a specific column using its corresponding letter.

Submit
6. Rows are identified by a _______________________ .

Explanation

Rows in a dataset or table are typically identified by a unique identifier, which is often a number. This allows for easy referencing and manipulation of individual rows within the dataset. By using a number as the identifier, it becomes straightforward to perform operations such as sorting, filtering, and updating specific rows based on their unique number.

Submit
7. There are three different types of data you can put in an Excel spreadsheet.  The one that is used for headings is called a ________________ .

Explanation

In an Excel spreadsheet, a label is used for headings. It is a type of data that is used to identify and categorize information in the spreadsheet. Labels are typically used to provide a clear and descriptive title or name for a particular column or row in the spreadsheet. They help organize and structure the data, making it easier to understand and navigate.

Submit
8. The "Go To" dialogue appears when you press the _____________ key on your keyboard.

Explanation

The "Go To" dialogue appears when you press the F5 key on your keyboard.

Submit
9. You can align cells so that entries are  ______________ , left-aligned or right-aligned.

Explanation

The correct answer is centered, in the center, center-aligned. This is because aligning cells in the center means that the entries will be positioned equidistant from both the left and right edges of the cell. This creates a visually balanced appearance and is commonly used for aesthetic purposes or to emphasize the importance of the content within the cell.

Submit
10. Microsoft Excel is an electronic _______________________________ program.

Explanation

Microsoft Excel is an electronic program that is specifically designed for creating and managing spreadsheets. A spreadsheet is a digital document that consists of rows and columns, allowing users to organize, calculate, and analyze data efficiently. With its wide range of features and functions, Microsoft Excel has become the industry standard for spreadsheet software, providing users with powerful tools for data manipulation, visualization, and reporting.

Submit
11. In Excel, you can organize data to perform mathematical calculations.  Data is organized in rows and ___________________ .

Explanation

In Excel, data is organized in rows and columns. Rows represent the horizontal arrangement of data, while columns represent the vertical arrangement. This organization allows users to input and manipulate data in a structured manner, making it easier to perform mathematical calculations and analyze the data effectively.

Submit
12. An Excel spreadsheet is also called a _________________________ .

Explanation

An Excel spreadsheet is also called a workbook because it is a file that contains multiple worksheets. Each worksheet within the workbook is a separate tab that allows users to organize and analyze data. The workbook acts as a container for all the worksheets, providing a way to manage and navigate through different sets of data within a single file. Therefore, both terms - workbook and worksheet - are used interchangeably to refer to an Excel spreadsheet.

Submit
13. As with Microsoft Word 2007, Excel uses the Microsoft _______________ in the upper left hand corner of the screen to control most functions (pictured here).

Explanation

In Microsoft Excel 2007, similar to Microsoft Word, the primary tool used to control most functions is the button located in the upper left-hand corner of the screen. This button, also known as the Office button, allows users to access various commands and options such as opening, saving, and printing files, as well as accessing the Excel options menu. By clicking on this button, users can easily navigate and perform essential tasks within the Excel application.

Submit
14. Next to the Microsoft button is the Quick Access ______________________ .

Explanation

The sentence suggests that there is a Microsoft button and next to it is the Quick Access toolbar. The Quick Access toolbar is a feature in Microsoft applications that allows users to easily access commonly used commands and functions. Therefore, the correct answer is "toolbar".

Submit
15. The _________________   ______________ displays the name of the worksheet.

Explanation

The title bar is the part of the worksheet that displays the name of the worksheet.

Submit
View My Results

Quiz Review Timeline (Updated): Mar 17, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 17, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 14, 2010
    Quiz Created by
    Cbz999
Cancel
  • All
    All (15)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
In Microsoft Excel, you use the ___________________ to issue commands...
A _____________ is the intersection point of a column and a row.
__________________ run vertically in a spreadsheet.
_________________ run horizontally in a spreadsheet.
Columns are identified by a _______________ .
Rows are identified by a _______________________ .
There are three different types of data you can put in an Excel...
The "Go To" dialogue appears when you press the _____________ key on...
You can align cells so that entries are  ______________ ,...
Microsoft Excel is an electronic _______________________________...
In Excel, you can organize data to perform mathematical...
An Excel spreadsheet is also called a _________________________ .
As with Microsoft Word 2007, Excel uses the Microsoft _______________...
Next to the Microsoft button is the Quick Access...
The _________________   ______________ displays the name of...
Alert!

Advertisement