Excel Questions and Answers 100% Verified

Excel Questions and Answers 100% Verified Spreadsheet A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns. Row Horizontal line of cells Cell A box that holds data Column ...

Excel Questions and Answers 100% Verified Spreadsheet A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns. Row Horizontal line of cells Cell A box that holds data Column A vertical line of cells Cell Address The column and the row number of a cell, e.g. C13; F27; Formula Bar the cell that one enters numbers, a formula or text : (the colon) Symbol used to designate a range (2 or more cells that are adjacent to each other) For Example: B3:B37 means b3,b4, b5,...to b37 , (the comma) Symbol used to designate the use of cells that are NON-ADJACENT in a formula or function =SUM(A12+A13) Adding two cells Sort Putting data in a certain order Filter Temporarily displays only certain data that meets a condition that you specify Max the largest number Average the sum of all numbers divided by the amount of numbers Min The lowest number ###### column is not wide enough to display contents #name? error in your formula #div/0! Need numbers in ur cells, cannot divide by zero AutoFill Completes previously typed words when you begin to repeat the typing Column Chart Displays vertical bars going across the chart, with the values axis being displayed on the left side of the chart. Pie Chart Displays a circle is divided into sectors which shows a percentage of a whole. Bar Chart Displays horizontal bars going down the chart with the values axis on the bottom of the chart. Doughnut Chart Like a pie chart, it displays data as parts of a whole, but with a hole. This allows you to display multiple series of a chart within each other, like the picture. Line Chart Displays information as a series of data points called 'markers' connected by straight line segments. Scatter Chart Displays data points for two variables on a coordinate plane. Active Cell The selected cell in Excel, marked by a thick border Count Calculates how many numbers are in the selected group Function Pre-defined calculations that are available Formula A custom calculation created by the user Columns are marked... ... by letters Rows are marked... ... by numbers $ Marks an absolute (as opposed to relative) cell in a formula The button used to highlight the entire spreadsheet (See picture) Series A row or column of data that is being used in a chart An INCORRECT Excel function example Function Example: sum(A3:A7)= A CORRECT Excel function example: Function example: =sum(A3:A7) Category Axis The horizontal or x-axis of a chart Value Axis The vertical or y-axis of a chart ` (grave accent) The key used to toggle your formulas to show the math instead of the result Lookup Function Retrieves values from a table of data that match a specified condition. Conditional Formatting Formatting that is applied to a cell when a specified condition is met. IF functions Performs a logical test and return one value for a TRUE result, and another for a FALSE result. For example, to "pass" scores above 70: =IF(A1>70,"Pass","Fail"). Cell Orientation Changing the direction of text within a cell Wrap Text Moves long text within a cell onto multiple lines to prevent overlap Merge & Center Joins selected cells into one larger cell and centers the contents =Sheet2!B2 - what does this do? Grabs B2 on Sheet 2 and inserts it into another sheet What can you do with comma separated values (CSV)? You can automatically split them into rows or columns Named range A human-friendly name given to a cell or range of cells so you can refer to it often. Could be used as an alternative to having to do an absolute cell reference. The Transpose feature Will quickly switch data from a column to a row or vice versa. The Subtotals feature Allows you to perform a function on preliminary groups of data before calculating a grand total Scale to Fit Reduces the size of a worksheet so it will better fit on a printed page