Computer Applications- Microsoft Excel: Microsoft Excel 2007 Basics
Approved & Edited byProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
In Microsoft Excel 2007, Where can you find the open, save, and print commands?
A.
Home Ribbon
B.
Office Button
C.
Workbook Layout Button
D.
Page Layout Button
Correct Answer B. Office Button
Explanation In Microsoft Excel 2007, the open, save, and print commands can be found in the Office Button. The Office Button is located in the top left corner of the Excel window and is represented by the Microsoft Office logo. When clicked, it opens a menu with various options, including the ability to open, save, and print Excel files.
Rate this question:
2.
What does the Formula Bar do?
A.
Gives the commands of subtraction or addition to a column
B.
Allows the user to type in questions and get answers from the help file
C.
Displays the contents of the currently selected cell
D.
None of the above
Correct Answer C. Displays the contents of the currently selected cell
Explanation The Formula Bar is a feature in spreadsheet software that displays the contents of the currently selected cell. It allows users to view and edit the data or formulas in a cell. This feature is particularly useful when working with large datasets or complex calculations, as it provides a clear and organized view of the cell's content.
Rate this question:
3.
What do we call the boxes on a spreadsheet?
A.
Formula bars
B.
Grids
C.
Home Boxes
D.
Cells
Correct Answer D. Cells
Explanation Cells are the correct term for the boxes on a spreadsheet. In a spreadsheet, data is organized into a grid of rows and columns. Each individual box within this grid is called a cell. Cells can contain various types of data, such as numbers, text, or formulas, and they are used to store and manipulate data in a spreadsheet.
Rate this question:
4.
A _______ is a line of boxes going from left to right.
A.
Row
B.
Column
C.
Formula String
D.
SpreadSheet
Correct Answer A. Row
Explanation A row is a horizontal line of boxes in a table or spreadsheet that goes from left to right. It is used to organize and display data in a structured manner. Each box in a row typically represents a cell and contains information or data. By arranging data in rows, it becomes easier to compare and analyze information across different categories or variables.
Rate this question:
5.
A ______ is a line of boxes going up and down.
A.
Row
B.
Column
C.
Formula String
D.
SpreadSheet
Correct Answer B. Column
Explanation A column is a line of boxes going up and down in a spreadsheet. It is a vertical arrangement of cells that are used to organize and categorize data. Each column typically has a header or label at the top to indicate the type of data contained within. Columns are commonly used to represent different variables or attributes in a dataset, allowing for easy sorting, filtering, and analysis of information.
Rate this question:
6.
What is the proper method for entering data into a cell?
A.
Type the information you want in the formula bar and hit the Tab button
B.
Select the cell by clicking on it, hit shift, and type the information you want in the cell
C.
Select a cell by clicking on it, type the information you want in it, and press enter
D.
Click on a cell, hit the Insert button, hit the enter button, and type the information you want in the cell.
Correct Answer C. Select a cell by clicking on it, type the information you want in it, and press enter
Explanation To enter data into a cell, the proper method is to select the cell by clicking on it, type the information you want in it, and then press enter. This is the standard process for inputting data in a cell in most spreadsheet applications.
Rate this question:
7.
How would you format a column of cells so that it is in currency form?
A.
Select the data or cell range that you want formatted, click Format on the shortcut menu, select Format Cells, and select currency from the category box.
B.
Select the data or cell range that you want formatted, click Format Painter, select Format Cells, and then add money signs in the boxes.
C.
Select the data or cell range that you want formatted, click View on the shortcut menu, select Page layout, and select currency from the category box.
D.
None of the above
Correct Answer A. Select the data or cell range that you want formatted, click Format on the shortcut menu, select Format Cells, and select currency from the category box.
Explanation To format a column of cells in currency form, you need to select the data or cell range that you want formatted. Then, right-click on the selection and click on "Format" in the shortcut menu. From there, select "Format Cells" and choose the "currency" option from the category box. This will apply the currency format to the selected cells or range, displaying the values with the appropriate currency symbol and decimal places.
Rate this question:
8.
What is a formula?
A.
A complex calculation that Microsoft will do when formating your spreadsheet
B.
It is a type of design formatting used in Math and Science
C.
A way to speed up the inputing of data in a Word Document
D.
A combination of numbers, operators, and cell references
Correct Answer D. A combination of numbers, operators, and cell references
Explanation A formula is a combination of numbers, operators, and cell references. In spreadsheets, formulas are used to perform calculations and manipulate data. By using operators such as addition, subtraction, multiplication, and division, along with cell references that point to specific cells containing data, formulas can perform complex calculations and generate results automatically. This allows for efficient data analysis and manipulation in spreadsheets.
Rate this question:
9.
Which of the following formulas could you use to add several cells together?
A.
=A1*B1*C1
B.
A1+B1+C1=D1
C.
=A1+B1+C1
D.
A1*B1*C1
Correct Answer C. =A1+B1+C1
Explanation The correct answer is "=A1+B1+C1". This formula allows you to add the values in cells A1, B1, and C1 together. By using the plus sign (+) between the cell references, you can perform the addition operation in Excel.
Rate this question:
10.
All of the following are proper descriptions of arithmatic operators except:
A.
"+" adds values
B.
"-" subtracts values
C.
"*" multiplies values
D.
"/" Squares values
Correct Answer D. "/" Squares values
Explanation The correct answer is "/" Squares values. This is because the "/" operator is used for division, not for squaring values. The squaring of values is typically done using the exponentiation operator, which is not mentioned in the given options.
Rate this question:
11.
Which of the following formulas could you use to add a range of cells together?
A.
SUM()
B.
=(SUM)
C.
=+SUM()
D.
=SUM()
Correct Answer D. =SUM()
Explanation The correct answer is =SUM(). This formula is used to add a range of cells together in Excel. By entering =SUM() followed by the range of cells you want to add, you can quickly calculate the total sum of those cells.
Rate this question:
12.
Which of the following formulas could you use to average a range of cells?
A.
=AVERAGE()
B.
=(AVERAGE)
C.
/(AVERAGE)
D.
=AVERAGE(SUM/SUM)
Correct Answer A. =AVERAGE()
Explanation The correct answer is =AVERAGE(). This formula calculates the average value of a range of cells. By using the AVERAGE function, you can easily find the mean value of a set of numbers.
Rate this question:
13.
Which of the following formulas could you use to find the Maximum value in the cell range?
A.
=(MAX)
B.
*MAX()
C.
=MAX()
D.
=MAX/MAX
Correct Answer C. =MAX()
Explanation The correct answer is "=MAX()". This formula is used to find the maximum value in a cell range. By using this formula, Excel will calculate and return the highest value within the specified range of cells.
Rate this question:
14.
Which of the following formulas could you use to find the Minimum value in the cell range?
A.
=(MIN)
B.
/(MIN)
C.
MIN()
D.
=MIN()
Correct Answer D. =MIN()
Explanation The correct answer is =MIN(). This formula is used to find the minimum value in a cell range. By using the MIN function and providing the cell range as an argument, it will return the smallest value within that range.
Rate this question:
15.
How do you sort data?
A.
Select data, click on page layout, select cells, choose method of sorting
B.
Select data, click on data tab, select sort, and choose method of sorting
C.
Select data, click on view tab, select data tab, choose sort method
D.
Click on data tab, select sort and choose method of sorting
Correct Answer B. Select data, click on data tab, select sort, and choose method of sorting
Explanation The correct answer is "Select data, click on data tab, select sort, and choose method of sorting". This answer explains the correct sequence of steps to sort data. It states that the data should be selected first, then the data tab should be clicked on, followed by selecting the sort option. Finally, the method of sorting should be chosen.