Functions
What function in Excel is used to find the highest value in a range of cells?
What is MAX Function?
Which feature in Excel allows users to apply predefined styles to cells, making it easy to format data consistently?
What are Cell Styles?
What symbol is used to start a formula in Excel?
What is the equal sign (=)?
What type of chart in Excel is used to show the relationship between two variables and is represented by connected data points?
What is a line chart?
What is the term for a single grid square where a row and column intersect in Excel?
What is a cell?
Which function in Excel is used to calculate the average of a range of cells?
What is the AVERAGE function?
What does the merge and center feature in Excel do?
What is to combine multiple cells into one cell and center-align the content?
How can you quickly copy a formula across multiple adjacent cells in Excel?
What is using the fill handle (small square at the bottom-right corner of the cell)?
What type of chart in Excel is typically used to compare values across categories and is represented by vertical bars?
What is a column chart?
What is the direction of a column?
What is the direction of a row?
What is vertical?
What is horizontal?
In Excel, what function is used to look up a value in a table based on criteria?
What is the VLOOKUP function?
Which Excel feature allows users to adjust the width of columns and the height of rows to better fit the content?
What is the "AutoFit" feature?
What Excel function is used to calculate the sum of a range of cells that meet specific criteria?
What is the SUMIF function?
How can you resize a chart in Excel to fit it better within a worksheet?
What is clicking and dragging the sizing handles on the chart's border or by using the "Size" options under the "Format" tab?
In Excel, what is the term for a single spreadsheet document?
What is a workbook?
What function in Excel is used to determine whether a value meets a specified condition and returns one value if TRUE and another value if FALSE?
What is the IF function?
Which Excel feature allows users to quickly apply a specific format to a cell based on its value, such as highlighting cells that contain a certain number or text?
What are Conditional Formatting rules?
How can you use Excel to identify and analyze trends in a dataset over time?
What is using a line chart or trendline feature to visualize and analyze data over time?
What Excel feature allows users to customize the appearance and layout of a chart, such as adding titles, axes labels, and data labels?
What is the "Chart Elements" feature?
How can you quickly sum a range of cells in Excel?
What is by typing =SUM(, selecting the range, and closing the parentheses, or by using the AutoSum button?
In Excel, what function is used to find the largest value that is less than or equal to a given value in a sorted array of data?
What is the LOOKUP function?
What feature in Excel allows users to summarize and analyze large datasets by creating interactive tables?
What are PivotTables?
What Excel feature allows users to group and summarize data by certain categories, such as months or quarters?
What are PivotTables?
How do you add new data to an already existing graph or chart?
What is "click on the data set, drag the selection to include the new data, and then hit enter?"
What is the default file extension for Excel workbooks?
What is .xlsx?