1/71
Looks like no tags are added yet.
What is the File tab used for?
Opening, saving, printing, and managing workbooks.
What is the Home tab used for?
Formatting text, cells, numbers, and alignment.
What is the Insert tab used for?
Adding charts, tables, pictures, and other objects.
What is the Page Layout tab used for?
Changing themes, margins, page orientation, and page setup.
What is the Formulas tab used for?
Finding and inserting formulas and functions.
What is the Data tab used for?
Sorting, filtering, and managing data.
What is the Review tab used for?
Checking spelling, adding comments, and protecting worksheets.
What is the View tab used for?
Changing worksheet views, zoom, and Freeze Panes.
What is the Name Box?
The box that shows the address of the selected cell.
What is the Formula Bar?
The area that shows or lets you edit the contents of a cell.
What is a workbook?
The entire Excel file.
What is a worksheet?
One spreadsheet inside a workbook.
rows vs columns
rows- horizontal and numbered. columns- vertical lines and lettered
What is a cell?
The box where a row and column meet.
What is a cell reference?
The address of a cell, such as A1.
How do text and numbers align by default?
Text aligns left, and numbers align right.
How do you use AutoSum?
Select the answer cell, click Home, click AutoSum (Σ), check the range, and press Enter.
What formula adds cells A1 through A5?
=SUM(A1:A5)
What is an Excel function?
A built-in formula that performs a calculation.
What symbol does every formula start with?
An equal sign (=).
What is the Fill Handle?
The tiny square in the bottom-right corner of a selected cell.
How do you use the Fill Handle?
Click a cell, drag the tiny square down or across, and release.
How do you apply a Cell Style?
Select the cells, click Home, choose Cell Styles, and pick a style.
What formatting tools are available in Excel?
Bold, italic, underline, font size, font color, fill color, borders, and alignment.
How do you create a pie chart?
Highlight your data, click Insert, select Pie Chart, and choose a chart style.
What is a pie chart used for?
Showing parts of a whole.
How do you change a worksheet tab color?
Right-click the sheet tab, select Tab Color, and choose a color.
How do you change document properties? What are examples of document properties?
Click File, select Info, find Properties, and edit the information. → Title, author, subject, and keywords.
What is the AutoCalculate area?
The bottom status bar that displays statistics about selected cells.
What does #DIV/0! mean?
You are dividing by zero.
What does #VALUE! mean?
The formula has an incorrect type of value.
What does #REF! mean?
The formula contains an invalid cell reference.
What does #NAME? mean?
Excel does not recognize something in the formula.
What does ##### mean?
The column is too narrow to show the information.
What is Flash Fill?
A tool that automatically fills information by recognizing a pattern.
How do you use Flash Fill?
Type an example, click Data, and select Flash Fill.
What is the Flash Fill shortcut?
Ctrl + E.
How do you enter a formula using the keyboard?
Type =, enter the cell references and math symbols, and press Enter.
What is Range Finder and how do you use it
A tool that helps identify which cells are used in a formula. Select the formula cell and press F2 to highlight the cells used in the formula.
How do you apply a theme to a workbook?
Click Page Layout, select Themes, and choose a theme.
How do you apply a date format?
Select the cells, click Home, open Number Format, and choose Short Date or Long Date.
What is an example of a Short Date? vs 72. What is an example of a Long Date?
11/17/2026. → Tuesday, November 17, 2026.
What is Conditional Formatting? and How do you apply Conditional Formatting?
A tool that changes cell colors or styles based on rules; Select cells, click Home, choose Conditional Formatting, select a rule, and click OK. An example of cond. form. is to highlight grades below 70 in red.
How do you change column width and height
Drag the line between column letters;Drag the line between row numbers.
What does AutoFit do?
Automatically adjusts the size of a column or row to fit the information.
How do you check spelling in Excel?
Click Review and select Spelling. (f7 is the shortcut)
How do you change worksheet margins?
Go to Page Layout, click Margins, and select Normal, Wide, or Narrow.
How do you add a header/footer?
Go to Page Layout view, click Add Header/footer, and type your information.
How do you print only part of a worksheet?
Highlight the cells, click Page Layout, select Print Area, and choose Set Print Area.
How do you rotate text in a cell?
Select the cell, click Home, click Orientation, and choose a rotation.
How do you create a series of month names?
Type January and drag the Fill Handle down.
How do you insert cells?→ 92. How do you delete cells?
Right-click a cell, select Insert, and choose how to shift the cells.→Right-click a cell, select Delete, and choose what to remove.
What is the difference between Delete and deleting cells?
The Delete key clears contents. Deleting cells removes cells and can shift other cells.
How do you enter today's date? and how to format it?
Press Ctrl + ; (semicolon). Select the cell, click Home, open Number Format, and choose a date format.
What is a relative cell reference?
A reference that changes when copied, such as A1.
What is an absolute cell reference?
A reference that stays the same when copied, such as $A$1.
What is a mixed cell reference?
A reference that locks either the column or the row, such as $A1 (collum a is locked, row can change) or A$1.( a can change, row cannot)
What shortcut changes cell references?
F4.
What is the IF function used for?
Checking whether something is true or false.
format of an IF formula
=IF(condition,value_if_true,value_if_false)
What is a Sparkline? and how do you insert it.
A tiny chart inside one cell. → Click Insert, select Line, Column, or Win/Loss, choose the data range, and click OK.
What is Format Painter?
A tool that copies formatting from one cell to another.
What is a clustered column chart?
A chart that displays vertical columns grouped side by side.
How do you move a chart to its own sheet?
Select the chart, click Chart Design, choose Move Chart, select New Sheet, and click OK.
How do you use Chart Filters and what are they?
Tools that let you show or hide certain data in a chart. Click the chart, select the funnel icon, choose the data to display, and click Apply.
How do you reorder worksheet tabs?
Click and hold a sheet tab, drag it left or right, and release.
What is Normal view?
The regular worksheet view used to work with spreadsheet information.
What is Page Layout view?
Shows how the worksheet will look when printed.
What is Page Break Preview?
Shows where pages will break when printing.
. What does Freeze Panes do? how would you freeze the top row.
Keeps rows or columns visible while scrolling. → Click View, Freeze Panes, and Freeze Top Row.
. What is What-If Analysis? and where is it located
A tool that lets you change numbers to see how the results change. Under the Data tab.
What are the three What-If Analysis tools?
SM→ save a copared sets of numbers/scenerios
Goal seak→ finds number needed to reach result
data table→ changing one or two numbers effect formula