Microsoft Excel Quiz: Can You Answer?

The "save as" command is used when you want to save your excel assignment under a different name. This command allows you to create a copy of the file with a new name, while keeping the original file intact. It is useful when you want to make a duplicate of the assignment or save it with a different name for organizational purposes.

You can add additional worksheets to Excel by clicking on the "+" button located at the bottom of the worksheet tabs. This allows you to create new worksheets within the same Excel file, which can be useful for organizing and managing different sets of data or performing different calculations.

The symbol "/" is commonly used to represent division in mathematical operations. It is widely recognized and accepted as the division symbol in various mathematical notations and programming languages. Therefore, the statement that the symbol for division is "/" is true.

To create a chart or graph, you need to use the "insert" tab. This tab contains various options and tools for inserting different elements into your document, including charts and graphs. By selecting the "insert" tab, you can access the necessary features and functions to create and customize your desired chart or graph. The "home" tab is generally used for basic formatting and editing tasks, while the "view" tab is used for changing the display settings. The "formula" tab is used for working with mathematical and logical formulas.

The formula bar is the correct answer because it is the specific name given to the bar where you input formulas in software applications such as Microsoft Excel. It allows users to enter and edit formulas, which are used to perform calculations and manipulate data within the program. The other options (address bar, ribbon bar, symbol bar) are not associated with inputting formulas and do not serve the same purpose as the formula bar.

To merge two or more cells together, the correct option is "merge & center". This option combines the selected cells into a single cell and centers the content within the merged cell. This is useful when you want to create a header or title that spans across multiple columns or rows in a spreadsheet or table.

You can copy and paste a chart into a document. This is a common feature in many document editing software, where you can select a chart, copy it, and then paste it into a document. This allows you to easily insert charts from other sources into your document without having to recreate them manually.

A row is a horizontal arrangement of objects or elements. It is a line or series of things placed side by side in a straight line from left to right. In contrast, a vertical arrangement would be a column, where objects or elements are placed one above the other. Therefore, the correct answer is horizontal.

The given statement states that Central High School uses MS Excel 10. This implies that the statement is true.

A column is a vertical structure or element that is used to support or bear weight in a building or structure. It is typically tall and slender in shape, standing upright to provide stability and structural integrity. Columns are commonly found in architecture and are used to distribute the weight of the structure evenly, allowing for the construction of larger and more complex buildings.

When putting a formula in, the symbol that must be put in first is the equals sign (=). The equals sign is used to indicate that the following characters are part of a formula and not a regular text entry. It is essential to include the equals sign at the beginning of a formula to ensure that the spreadsheet software recognizes it as a formula and performs the necessary calculations accordingly.

A cell reference refers to the address of a specific cell in a spreadsheet. It is used in formulas to perform calculations or retrieve data from that particular cell. The formula can include the cell reference to indicate which cell's value should be used in the calculation. Therefore, the correct answer is "cell reference".

A column chart is a type of graphical representation that uses vertical bars to display data. These bars go up and down along the y-axis, representing different categories or variables on the x-axis. Each bar's height corresponds to the value it represents, allowing for easy comparison between different data points. Therefore, the correct answer is "goes up and down."

The statement is true because the shortcut to print a document is indeed "cntr p".

The statement implies that in order for a formula to be effective, it must be written in each cell. However, this is not true. Formulas in spreadsheets can be written in a single cell and then copied or dragged to other cells to apply the formula to multiple cells. This saves time and effort in entering the same formula repeatedly. Therefore, the correct answer is false.

The statement is incorrect. The correct keyboard shortcuts for copy and paste are Ctrl+C and Ctrl+V, not Ctrl+C and Ctrl+X. Ctrl+X is the shortcut for cut, not copy. Therefore, the given answer is false.

The correct answer is "=sum(a1 + b1)*15". In Excel, the SUM function is used to add the values in cells A1 and B1, and then the result is multiplied by 15 using the asterisk symbol (*).

A pie chart is used to show information in relationship to each other. It represents the proportion of different categories or components within a whole. Each slice of the pie represents a specific category, and the size of each slice corresponds to the proportion or percentage it represents in relation to the whole. This allows for easy visualization and comparison of the different categories and their relative importance or contribution.

A cell is identified by two characters, often referred to as alphanumeric because it can contain both letters and numbers. This means that the characters used to identify a cell can be a combination of both alphabets and numerals, allowing for a wider range of possibilities in cell identification.

To sort in descending order means to arrange the items in reverse alphabetical order, starting from the highest value or letter and ending with the lowest. In this case, "z - a" represents sorting in descending order as it starts with the letter "z" and ends with the letter "a".

When making a graph, you do not have to highlight everything. Highlighting everything would make the graph cluttered and difficult to read. Instead, it is important to selectively highlight the relevant data or key points to effectively communicate the information in the graph.

Excel can be used for multiple purposes, including monitoring grades, creating a phone book, calculating the cost of a vacation, and creating labels. Therefore, the answer "some of the above" is correct as it encompasses the various uses of Excel mentioned in the options.

When you open up Microsoft Excel, you open it up to a worksheet. A worksheet is a single page or tab within a spreadsheet where you can enter and manipulate data. It is the primary working area in Excel where you can perform calculations, organize data, and create charts or graphs. A spreadsheet, on the other hand, refers to the entire file or document that contains multiple worksheets. A sheet is a general term that can refer to either a worksheet or a chart sheet within an Excel file.

When printing paper in landscape orientation, the paper is positioned horizontally, with the longer side of the paper running from left to right. This allows for a wider printout, making it suitable for documents that have a wider layout, such as spreadsheets or wide tables. In contrast, portrait orientation is when the paper is positioned vertically, with the longer side running from top to bottom.

The word command that must be placed after the symbol when subtracting two items from each other is "SUB". This is because "SUB" is the abbreviation for "subtract", which indicates the operation of subtraction. The other options, "SUM", "MIN", and "ADD", are not appropriate word commands for subtraction.

When copying information from one cell to another, if the cell information remains unchanged, it is referred to as "copy cells". This means that the exact content of the cell is replicated in another cell without any alterations.

Worksheets can be named in order to provide a clear and specific label for each sheet. This helps users easily identify and navigate between different sheets within a workbook. By naming worksheets, users can also organize and categorize their data more effectively. Additionally, naming worksheets can make it easier to reference specific sheets in formulas or macros. Therefore, the correct answer is "named".

Excel is not a program, it is a spreadsheet software developed by Microsoft. It is used for creating, organizing, and analyzing data in a tabular format. Therefore, the correct answer is False.

When heading information is placed in cell 1 of each column, it is called a header row. The header row typically contains labels or titles that describe the data in each column. It is used to identify and categorize the data in the columns below, making it easier to understand and organize the information in the table or spreadsheet.

Excel is a spreadsheet software that is primarily used for creating and managing numerical data, performing calculations, and creating charts and graphs. While Excel does have some basic database functionalities, such as sorting and filtering data, it is not designed to be a full-fledged database management system. It lacks advanced features like data validation, data relationships, and security measures that are essential for a robust database. Therefore, the statement that Excel can be used to create a database is false.