Excel pt.1 Flashcards
What is Flash Fill in Excel?
A tool that automatically fills in values based on a pattern.
What function calculates the average of a range?
The AVERAGE function.
What does the COUNTIF function do?
Counts the number of cells that meet a specific condition.
How do you freeze panes in Excel?
Use the “Freeze Panes” option to keep rows or columns visible.
What function returns the largest value in a range?
The MAX function.
How do you rename a worksheet in Excel?
Double-click the sheet tab and type a new name.
What does the IF function do?
It performs a logical test and returns different values based on the result.
What is conditional formatting used for?
It applies formatting to cells based on specific conditions.
What function returns the median value of a dataset?
The MEDIAN function.
How do you apply a filter to an Excel table?
Click the filter icon in the table headers.
What function finds the smallest number in a range?
The MIN function.
How can you move data within an Excel sheet?
Cut and paste or drag and drop.
What function returns the current date?
The TODAY function.
How do you sort data in Excel?
Use the “Sort” option under the Data tab.
What does a Summary Sheet do?
It consolidates data from multiple worksheets.
What tool helps visualize trends within a single cell?
Sparklines.
What function counts the total number of numeric values in a range?
The COUNT function.
How do you clear all formatting in a worksheet?
Use “Clear Formats” under the Home tab.
What does the “Print Area” setting do?
Defines a specific area to print.
How can you copy formatting in Excel?
Use the Format Painter tool.
