The percent style button formats selected cells as a percentage with ________.

focusNode

Didn't know it?
click below

Knew it?
click below

The percent style button formats selected cells as a percentage with ________.

Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

Excel Worksheet

QuestionAnswer
Base starting point when you divide the amount of increase by it to calculate the rate of increase
Detail Worksheet details of the information is kept there
Drag and Drop Action of moving a selection by dragging it to a new location
Format as You Type a cell takes on the formatting of the number typed into the cell
Line Chart - displays trends over time
Navigate move within a document or worksheet
Office Clipboard temporary storage area maintained by your Windows OS
Order of Operations mathematical rules for performing multiple calculation within a formula
Paste action of placing cell contents that been copied or moved to the office clipboard to another location
Paste Area target destinat for data that has been cut or copied using the office clipboard to another location
Paste Options Button button that displays in the lower right corner of a pasted selection and that displays a list of options that lets you determine how the information is pasted into the worksheet
Paste Special dialog box that offers various options for the manner in which you can paste the contens of the office clipboard into one or more cells.
Percent for New Value equals base percent+ Percent of increase
Percentage Rate of Increase percent by which one number increases over another number
Rate equals amount of increase/base calculate the rate of intrest
Sheet Tabs id each worksheet in a workbook and are located along the lower left edge of the workbook window
Value after increase equal base x percent for new value formula for calculation the value after an increase by multiplying the original vale-the-base- by the percent for the new value
What-if Analysis - the process of changing the values in cells to see how those changes affect the outcome of formulas in your worksheet
You can create new folders to store files from the ________ dialog box. Save As
What Identify each worksheet in a workbook and are lacated along the lower left edge of the workbook window? Sheet Tabs
To change the name of a sheet tab what do you do on the tab before you type in the new name? right –click
When a worksheet is active, the tab color displays as an what? underline
Under Date category, if type 3/14 is selected, what will display in the Cell? only the month and day.
You can remove the contents of a cell by clicking the clear button and choosing what from the editing group on the window? clear contents button
The action of placing cell contents that have been moved to the office clipboard to another location is called? paste
When Cells are Selected and the cut or Copy command is preformed on them, the data is placed on the what? Office Clipboard
A what surronds the selected range to be copied? moving boarder
Pressing ________ pastes the text and removes it from the office Clipboard Paste Button
You can enter data on several worksheets at the same time by selecting and ______ multiple worksheets. grouping
To insert a line break in a cell, double click the cell and locate where you want the break, then press: [alt] + [enter]
The format Cells dialog box is displayed by: right clicking over selected cells and selecting format cells from the shortcut menu.
To group worksheets, right-click on the sheet tab and click: Select all sheets
The worksheet that contains the totals from other worksheets is called: summary sheet
Worksheets that contain the detail information that affects totals in another worksheet are called _______ worksheets. detail
When a worksheet is being moved, a caret will show on the top of the worksheet tab and a _____________ paper icon will attach to the mouse pointer. paper
From preview group, click the _________ button to view each page of the workbook. Next Page
In the print dialogue box under print what, select________ to print all the sheets in a workbook. Entire Workbook
The process of changing values in cells to see how the changes affect totals or formulas in the worksheet is called what? what if analysis.
You can use the Auto Fill feature to continue a series for any pattern that is est. with _______________ cells. two or more
______________ refers to a cell maintaining the formatting of the number typed in the cell even when you delete the number and replace it with another number. Format as you type
Excel follows a set of mathematical rules called what? Order of operation
Formulas depend on ____________ of a cell. value
What is the default setting for the number of work books three
You can navigate among worksheets by clicking what? the sheet tab
Excel assigns a ________ _________ to the data. serial value
How many formats can you apply to a cell? one or more
Detailed worksheets are also known as related worksheets
Each worksheet within a workbook can have ___________ formatting. diffrent

What are the two contextual tabs that display on the ribbon when a chart is selected?

Contextual ribbon tabs For example, if you select a chart, the Design and Format tabs will appear under Chart Tools.

Which of the following Excel features recognizes a pattern in the data of a worksheet?

Excel Flash Fill is a special tool that analyzes the information you are entering and automatically fills data when it identifies a pattern. The Flash Fill feature was introduced in Excel 2013 and is available in all later versions of Excel 2016, Excel 2019, Excel 2021, and Excel for Microsoft 365.

What key is the keyboard shortcut for the spelling command?

Keyboard shortcuts for formatting cells.

When a cell is part of an active formula it is surrounded with?

The active cell is the selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is the cell surrounded by a black border. Data can only be entered into the active cell.