MS Excel 2003 Proficiency Quiz: Trivia!

The correct answer is B1:G10. This is the correct cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10. The ":" symbol is used to indicate a range, and the starting cell is specified before the ":" symbol, while the ending cell is specified after the ":" symbol.

To delete a spreadsheet from a workbook, you can right-click on the spreadsheet tab and select "delete". This option allows you to easily remove a specific spreadsheet from the workbook without affecting the others. Left-clicking on the tab and pressing delete may not have the same effect, as it could simply select the tab without providing an option to delete it. Pressing control and clicking the spreadsheet tab is not a valid method to delete a spreadsheet. Therefore, the correct answer is to right-click on the spreadsheet tab and select "delete".

The settings to wrap text in a cell and to merge cells are found in the format cells dialog on the Alignment tab.

The active cell on an Excel spreadsheet is indicated by a dark wide border. This border helps to identify which cell is currently selected and allows the user to perform actions such as entering data or applying formatting specifically to that cell. The dark wide border stands out from the other cells, making it easy to locate and work with the active cell.

The easiest method to select a column is by clicking the column heading. This is because the column heading represents the entire column and clicking on it automatically selects the entire column. It is a straightforward and efficient way to select a column in a spreadsheet or any other tabular data format.

The default orientation for a printed page is portrait. This means that the page is taller than it is wide, similar to a typical piece of paper.

The correct answer is "data/sort" because the command to arrange rows in alphabetical order based on column A is typically found in the "data" menu. Using the "sort" command under the "data" menu allows you to sort the rows in a dataset based on a specific column, in this case, column A.

When you select a cell with a date and drag the fill handle down and across several cells, the date is increased by 1 day into each cell. This is because Excel recognizes the pattern of dates and automatically increments the date by 1 day in each subsequent cell.

Right-clicking on a cell and selecting the "unhide" option allows you to display data that was previously hidden. This action brings back any hidden columns, rows, or worksheets that were hidden using the "hide" function.

A pivot table is a useful tool for quickly rearranging data to meet your needs. It allows you to summarize and analyze large amounts of data by organizing it into a more manageable and meaningful format. With a pivot table, you can easily change the layout and structure of the data, making it easier to identify patterns, trends, and relationships. This flexibility and ability to customize the data view make pivot tables a valuable tool for data analysis and decision-making.

The purpose of a macro is to perform multiple functions quickly and easily. Macros are sets of instructions that can be recorded and executed to automate repetitive tasks in software applications. They allow users to save time and effort by automating complex or repetitive actions, making it easier to perform multiple functions with just a few clicks.

Filtering is a process that allows the user to selectively display or hide certain data based on specific criteria. It helps in narrowing down the data set to only show the relevant information. On the other hand, sorting arranges the data in a specific order, such as ascending or descending, based on one or more criteria. While both filtering and sorting can arrange data, filtering has the additional capability of hiding certain data that does not meet the specified criteria. Therefore, the answer correctly states that filtering can hide data as well as sort it.

Conditional formatting is most useful when we want to highlight cells if certain conditions are met. This feature allows us to apply formatting rules to cells based on their values or the values of other cells. By using conditional formatting, we can easily identify and emphasize specific data that meets certain criteria, making it easier to analyze and interpret the information in a spreadsheet.

Page break preview is the correct answer because it is a view in which you can see how the pages of your document will be divided when printed. It shows a blue line around each page that would be printed, indicating where the page breaks will occur. This view is useful for adjusting page breaks and formatting to ensure that the document prints correctly. The other options, Print preview and Normal view, do not specifically show the page breaks in this manner.

The correct answer is =D4+(B1 + B2). This is the correct formula because it adds the value in cell D4 to the sum of the values in cells B1 and B2. The parentheses ensure that the addition of B1 and B2 is done before adding it to D4.

The pivot chart is showing only 1 for over 90 on all accounts because the Values box in the chart is set to count instead of sum. This means that instead of summing up the values over 90 for each account, it is counting the number of occurrences of the value over 90, which is always 1.

If a cell shows ##### it means that the column is too narrow to show all the digits of the number. This occurs when the number in the cell is too wide to fit within the column width. Increasing the column width will allow the full number to be displayed in the cell.

The correct answer is "a formula which will add values in the range excel guesses you want to add". This is because when you use the autosum button in Excel, it automatically creates a formula that adds up the values in the selected range of cells. Excel guesses the range based on the surrounding data and selects it for you.

The lookup value and table array should be switched. This means that the function arguments are not in the correct order. The lookup value should be the first argument, followed by the table array. Switching the order of these arguments will ensure that the function works correctly.