CTS-130 - Spreadsheets
Cell B2 contains the formula =SUME(A1:A100) with the name of the SUM function misspelled as SUME. What error value will appear in the cell?
#NAME?
What is the expression to reference the local scope defined name TotalSales from the Final Report worksheet?
'Final Report'!TotalSales
What is the external reference to cell C20 of the Final Report worksheet located in the Annual Statement.xlsx workbook?
'[Annual Report.xlsx]Final Report'!C20
What is the external reference to cell D10 of the Sunday worksheet located in the Weekly Report.xslx workbook that is stored in the C:\Documents\Reports folder?
'[C:\Documents\Reports\Weekly Report.xlsx]Sunday'!D10
How would the number 00514 appear in a cell?
514
If 4/30/2021 and 5/31/2021 are the initial values in a range, list the next two values that AutoFill will insert.
6/30/2021 and 7/31/2021
If cell R10 contains the formula =$R1+R$2 that is then copied to cell S20, what formula is entered in cell S20?
=$R11+S$2
What is the formula to add values in cells A1, B1, and C1? What function will achieve the same result?
=A1+B1+C1 =SUM(A1:C1)
What is the formula to calculate the average of the Income field from the Employees table?
=AVERAGE(Employees[Income])
Write a formula to convert the number of days entered in cell B10 to seconds.
=B10*24*60*60
What is the formula to count the number of numeric values in the range A1:A30?
=COUNT(A1:A30)
If cell Q3 is greater than cell Q4, you want to display the text "OK"; otherwise, display the text "RETRY". Write the formula that accomplishes this.
=IF(Q3 > Q4, "OK", "RETRY")
Write a formula that uses the MAX function to calculate the maximum value of cell C20 of the Monday through Friday worksheet group.
=MAX(Monday:Friday!C20)
Write a formula to return the single value that is repeated the most times in the range Y1:Y100.
=MODE.SNGL(Y1:Y100)
Write a formula to round the value in cell A5 to the nearest multiple of 1000.
=ROUND(A5, -3)
The range of values is defined as the maximum value minus the minimum value. Write a nested formula that calculates the range of values in the range Y1:Y100 and then rounds that value to the nearest integer.
=ROUND(MAX(Y1:Y100) - MIN(Y1:Y100), 0)
If cell R10 contains the formula =R1+R2 that is then copied to cell S20, what formula is entered in cell S20?
=S11+S12
Write a formula to calculate the average of the filtered values from the Sales Price field in the Sales_Result table.
=SUBTOTAL(1, Sales_Result[Sales Price])
Write a formula to calculate the sum of the filtered values from the Sales Price field in the Sales_Result table.
=SUBTOTAL(9, Sales_Result[Sales Price])
What is the formula to sum all the numeric values in Column C.
=SUM(C:C)
Cell E11 contains the formula =SUM(E1:E10). How is the formula adjusted when a new row is inserted above row 5?
=SUM(E1:E11)
Write a formula to retrieve the value from the third field in the Sales_Result table that exactly matches the lookup value in cell B10.
=VLOOKUP(B10, Sales_Result, 3, FALSE)
Write the formula to perform an exact match lookup with the lookup value from cell G5 using a vertical lookup table located in the range A1:F50. Return the value from the third column of the table.
=VLOOKUP(G5, A1:F50, 3, FALSE)
fill handle
A black square that appears in the lower-right corner of a selected cell or range; used to fill adjacent cells with duplicate or similar data.
Quick Analysis tool
A button that appears whenever you select a range of cells, providing access to the most common tools for data analysis and formatting of the selected range.
indirect referencing
A cell reference in which the reference itself is a calculated value.
column chart
A chart that displays data values as columns; the column height represents the value.
Hierarchy charts
A chart that show the relative contribution of groups to a whole.
waterfall chart
A chart used to track the addition and subtraction of values within a sum.
histogram
A column chart displaying the distribution of values from a single data series.
stacked column chart
A column chart or visualization that places data series values in combined columns that show how much is contributed by each series.
clustered column chart
A column chart that displays data values in side-by-side columns.
100% stacked column chart
A column chart that places the data series values in combined columns showing the percentage for each series.
bar chart
A column chart turned on its side so that the length of each bar is based on its value.
Pareto chart
A combination chart that combines a column chart a line chart with the categories sorted in order from largest contributors to the smallest.
What are data bars? How do data bars differ from sparklines?
A data bar is a conditional format in which a horizontal bar is added to a cell background with the length of the bar proportional to the cell's value. Unlike sparklines, the data source for the data bar is found within the cell itself and not from another cell range in the workbook.
Goal Seek
A feature that reverses the trial-and-error process by allowing you to specify an output value and then working backward to find the input value needed to reach that goal.
What is a field? What is a record?
A field is a single value that describes a person, place, or thing. A record is a group of related fields.
income statement
A financial statement that summarizes the income and expenses incurred during a specified interval. Also called a profit and loss statement.
profit and loss (P&L) statement
A financial statement that summarizes the income and expenses incurred during a specified interval. Also called an income statement.
theme font
A font associated with a particular theme and used for headings and body text; theme fonts change automatically when the theme is changed.
volatile functions
A function that automatically recalculates its values every time Excel does any calculation in the workbook
lookup function
A function that retrieves a value that matches a specified condition from a table of data.
logical function
A function that returns a different value depending on whether the given condition is true or false.
TODAY function
A function that returns only the current date, which updates each time a worksheet is opened.
IFERROR function
A function used to hide error values from appearing in cells.
charts
A graphic that represents data using bars, columns, dots, lines, or other symbols to make the data easier to understand and to make it easier to see the relationships among the data
sunburst chart
A hierarchy chart that groups categories within a series of concentric rings, with the upper levels of the hierarchy placed in the innermost rings.
trendline
A line that represents the general direction in a series of data.
criteria range
A location separate from the table used to list specific search specifications.
approximate match lookup
A lookup in which the lookup value falls within a range in a lookup table.
exact match lookup
A lookup in which the lookup value must exactly match one of the values in the lookup table.
What are major tick marks and minor tick marks?
A major tick mark matches each entry on the chart axis. Minor tick marks further divide the space between the major tick marks.
operators
A mathematical symbol used in a formula to combine different values, resulting in a single value that is displayed within the cell.
key performance indicator (KPI)
A measurement used by business to measure achievement of a specific goal.
error value
A message in a cell that indicates some part of a formula is preventing Excel from returning a calculated value.
Mouse Mode
A mode in which you use a computer mouse to interact with commands and tools.
What is the difference between a defined name with global scope and one with local scope?
A name with global scope can be referenced anywhere within the workbook; the scope of local name is limited to the worksheet in which its defined.
Theme colors
A named set of complementary colors for text, background, accents, and links in a document.
chart elements
A part of a chart, such as its title or legend, which you can add, remove, or modify.
exploded pie chart
A pie chart that moves one slice away from the others as if someone were taking the piece away from the pie.
A research firm wants to display the population of a state organized into five geographic locations. Which chart should it use? Explain why.
A pie chart would work well because the number of categories is not greater than 5 or 6. A column chart would also work with this data.
structural references
A reference that refers to a structural element of an Excel table.
chart sheet
A separate sheet in a workbook that contains only a chart, which is linked to the workbook data.
custom list
A sequence you specify to sort data.
syntax
A set of rules; used for functions in Excel, procedures in VBA, and queries and properties in Access.
Central tendency
A single measurement from a data series that returns the most typical or "central" data value.
Mini toolbar
A small toolbar that appears next to text you select using the mouse or when you right-click a document, worksheet, slide, or database cell.
wildcard
A special symbol that substitutes for unknown characters in search text; the most common are the question mark (?), which stands for any single character, and the asterisk (*), which represents any group of characters.
Excel
A spreadsheet program used to enter, analyze, and present quantitative data; also called Microsoft Excel 2019.
comparison operator
A symbol that indicates the relationship between two values.
Clipboard
A temporary Windows storage area that holds the selections you copy or cut so you can use them later.
point
A unit of measure used for font size and, in Excel, row height; one point is equal to 1/72nd of an inch.
Date data
A value in a recognized date format.
time data
A value in a recognized time format.
what-if analysis
A way to explore the impact that changing input values has on calculated values and output values
trial and error
A way to perform what-if analysis by changing one or more of the input values to see how they affect the other cells in the workbook.
What is the range reference for cells A1 through C5 and cells A8 through C12?
A1:C5, A8:C12
treemap chart
An Excel chart that provides a hierarchical, visual view of data, making it easy to spot patterns and trends.
AVERAGE function
An Excel function that calculates the average value of a collection of numbers.
path
An address that describes the exact location of a file in a file hierarchy showing the folder with the highest hierarchy level on the left and steps through each hierarchy level toward the right; locations are separated by small triangles or by backslashes.
Numeric data
Any number that can be used in a mathematical operation.
If the firm wants to display how the population of the geographic locations within the state changes over time as a percentage of the whole population, which chart type should it use? Explain why.
Because the chart needs to display the percentage of the population of each regional location to the population of the whole state, a 100% Stacked Column chart will work best.
If the firm wants to display the total population growth of a state over a 10-year period organized by those five geographic locations, which chart type best displays this information? Explain why.
Because the chart needs to display the total population of the state, a stacked column chart will work best to show how that total is divided into different regional locations and how that division changes over time.
If the firm wants to display both the average annual income and the total population of the state over the 10-year period, what chart should it use and why?
Because the two data series have such different ranges of values, use a combination chart with the average annual income value displayed against one vertical axis perhaps as a line chart and the population plotted against the other vertical axis perhaps using column chart.
A researcher wants to plot weight vs. blood pressure. Should the researcher use a line chart or a scatter chart? Explain why.
Because two data series are involved in the chart, the researcher should use a scatter chart and not a line chart.
What is the cell reference for the cell located in the third Column and fourth row of a worksheet?
C4
bins
Categories within a histogram into which data values are allocated.
How do you format text so that is is set vertically within the cell?
Click the Orientation button in the Alignment group on the Home tab, and then click Vertical Text.
How do you ungroup a worksheet group that consists of all the sheets in the workbook?
Click the sheet tab of any worksheet in the group.
criteria filters
Conditions you specify for a filter.
What is the range reference for the block of cells D3 through E10?
D3:E10
data series
Data from a column or row in a sheet; the set of values represented in a chart.
data callout
Data labels that appear in a chart as bubbles pointing to data markers.
descending order
Data sorted from highest to lowest, most recent to earliest, or alphabetically from Z to A.
If you want to sort employees by the value of the Hire Date field within each value of the Dept field, which field is the primary sort field? Which is the secondary sort field?
Dept is the primary sort field; Hire Date is the secondary sort field.
axis title
Descriptive text that appears next to a chart's horizontal or vertical axis.
data definition table
Documentation that lists the fields to be maintained for each record, a description of the information each field will include, and the type of data stored in each field.
What is displayed in the title bar for a workbook created from the EmployeeList.xltx template file?
EmployeeList1
What is the reference to the Income field from the Employees table?
Employees[Income]
What happens when you select a defined name in the Name box?
Excel selects the cell or cell range referenced by the defined name.
Stephen is entering hundreds of temperature values into a worksheet for a climate research project, and wants to speed up data entry by leaving freezing point values as blanks rather than typing zeroes. Explain why this will cause complications in the calculation of the average temperature.
Excel will ignore the blank cells and calculate the average based only on the cells that contain numeric values. So Stephen should enter zeroes instead of leaving blank cells.
Sans serif fonts
Font that does not include short decorative lines at the upper and lower ends of their characters.
If you split the worksheet into panes at cell E3, how many panes are created?
Four panes are created.
What are the three freeze pane options?
Freeze panes for panes placed at the top and left of the workbook window, Freeze Top Row to freeze the worksheet's top, and Freeze First Column to freeze the worksheet's first column.
When an ascending sort order is used, how is a date-time field sorted?
From the earliest date and time to the latest
If you insert cells into the range C1:D10, shifting the cells to the right, what is the new location of the data that was previously in cell F4?
H4
secondary sort field
In Access and Excel, a second field that determines the order of records in an object that are already sorted by a primary sort field.
WORKDAY function
In Excel, a function that displays the date of a weekday that is a specified number of weekdays past a starting date.
lookup table
In Excel, a table that stores the data you want to retrieve with a lookup function; also called a table array.
subtotals
In Excel, summary functions applied to part of a data range.
scale
In Excel, the range of values displayed on a chart axis, or to change the size of the worksheet on the printed page.
value axis
In a chart, the axis that contains numerical values; in a 2-dimensional chart, also known as the y-axis.
secondary axis
In a combination chart, an additional axis that supplies the scale for one of the chart types used.
Why is it not a good idea for a company to treat employee records with duplicate first and last names as duplicate records?
In a large enough company, there is a risk that two different employees will have the same name.
header row
In an Excel or Word table, the first row; it contains field (column) names.
Advanced filtering
In an Excel table or data range, a way of writing more complicated filter criteria that involves expression that combine fields using the AND and OR logical operators.
calculated field
In an Excel table, a field whose values are not entered but calcuated based on other fields.
In a chart's data source, where does Excel assume that category values are placed?
In the first column or the first row, depending on how the data values are laid out
By default, where does Excel store workbook templates?
In the user's Custom Office Templates folder
Why is Report-Date not a valid named range?
It contains a dash in the name.
What does Excel do when a hyperlink is clicked by the user?
It opens an application associated with the type of link.
Red is a standard color. What happens to red text when you change the workbook's them?
It remains red; a standard color is not changed when you change the workbook's theme.
A data series contains values grouped into 12 categories. Would this data be better displayed as a pie chart or a column chart? Explain why.
It would be better displayed as a column chart because as the number of slices in the pie chart increases, the harder it is to distinguish different slice values. Generally, you should not have more than 5 or 6 slices in the pie chart for readability.
KeyTips
Labels that appear over each tab and command on the ribbon when the ALT key is pressed.
Major tick marks
Lines that identify the main units on a chart axis.
minor tick marks
Lines that identify the smaller intervals between major tick marks on a chart axis.
What is the absolute 3-D cell reference to cell C20 in the Monday worksheet?
Monday!$C$20
What is the 3-D cell reference to cell C20 in the Monday worksheet?
Monday!C20
What is the 3-D cell reference to cell C20 in the Monday through Friday worksheet group?
Monday:Friday!C20
When highlighting duplicate values with a conditional format, do the duplicate values have to be adjacent to each other?
No, duplicate values located anywhere within the selected range will be highlighted by the conditional format rule.
Can slicers be moved to any worksheet or external workbook?
No, slicers can be moved to another worksheet but not to another workbook.
Can slicers be used with both data ranges and Excel tables?
No, slicers cannot be used with data ranges.
Can a workbook have only one window?
No; a single workbook can have multiple workbook windows.
How do you check the status of a link within the current workbook to determine whether the link's source file is accessible and up-to-date?
On the Data tab, in the Queries & Connections group, click the Edit Link button to open the Edit Links dialog box, and then view the link's status in the Status column.
How are page breaks indicated in Page Break Preview?
Page breaks are identified with blue dotted lines.
How do you create a worksheet group consisting of sheets that are not adjacent in a workbook?
Press and hold CTRL as you click each sheet tab that you want to add to the worksheet group.
What are print titles?
Print titles are the worksheet rows or columns that are repeated on every page of the printout.
How do you change the color of a worksheet tab?
Right-click the sheet tab, click Tab Color on the shortcut menu, and then select the color you want to use.
Explain how to use the Quick Analysis tool to calculate a running total of the values in the range D1:D10.
Select the D1:D10 range, click the Quick Analysis button that appears next to the selected range, select the Totals menu and then select the Running Totals for Column option (the last entry in the list).
How do you insert a manual page break in a worksheet?
Select the first cell below the row at which you want to insert the page break, click the Breaks button in the Page Setup group on the Page Layout tab, and then click Insert Break.
What is the difference between a serif font and a sans serif font?
Serif fonts have extra decorative strokes at the end of each character. Sans serif fonts do not include these decorative strokes.
pixel
Short for picture element, an individual point of color on a display screen or printout.
Before you can add subtotals to a data range, what must you first do with the data?
Sort the data range by order the field for which you want the subtotals calculated.
constants
Terms in an equation whose values don't change.
How is text aligned within a worksheet cell by default?
Text is left-aligned in a cell by default.
Describe the differences between the Accounting format and the Currency format.
The Accounting format places the currency symbol on the left edge of the cell, adds a thousands separator, shows values to two decimals places, displays negative values in parentheses, and displays zero values as dashes. The Currency format places the currency symbol to the left of the first digit of the monetary value, adds a thousands separator, shows values to two decimal places, and displays negative numbers with a negative sign.
ascending order
The arrangement of text alphabetically from A to Z, numbers from smallest to largest, and dates from oldest to newest.
mean
The average of a series of data values calculated by dividing the data sum by the number of data values in the series.
primary axis
The axis against which a chart's data series is plotted; usually appears along the left side of a chart.
range reference
The cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell, separated by a colon.
median
The central value of a data series.
cell reference
The column letter and row number location that identifies a cell within a worksheet or table, such as A1.
return values
The data values being retrieved by the lookup function from a lookup table.
What is the General format?
The default Excel number format that displays numbers just as they are entered.
Page orientation
The direction in which content is printed on the page.
Formatting
The enhancement of how content appears on the screen by changes to its font, size, color, or alignment.
primary sort field
The first sort field specified that determines the order of records in an object.
What happens to banded rows in an Excel table when you insert or delete a row?
The formatting adjusts to retain the banded row effect.
NETWORKDAYS function
The function that calculates the number of working days between two dates.
MODE.MULT function
The function that returns the single value that is repeated most often in the range.
ROUND function
The function that rounds a value to the nearest digit.
category axis
The horizontal axis in a chart, usually containing the names of data categories; also called the x-axis.
Describe the three types of sparklines.
The line sparkline displays data values in a line chart. The column sparkline displays values using a column chart. The win/loss sparkline displays positive and negative values.
Houses in a neighborhood usually sell for between $250,000 and $350,000 except for a large mansion that sold for $1,200,000. Which best expresses the typical home sales price: average or median? Why?
The median is the better measure because the average is more affected by the large extreme value, making the typical home price appear larger than it is.
Edit mode
The mode in which you can make changes to a cell's content directly in the cell.
significant digits
The number of digits that should be displayed for a calculation; they indicate the accuracy of the measured and calculated values.
portrait orientation
The position of a page, slide, or worksheet so that the page, slide, or worksheet is taller than it is wide.
You need to reference cell Q57 in a formula. What is its relative reference? What is its absolute reference? What are the two mixed references?
The relative reference is Q57. The absolute reference is $Q$57. The two mixed references are $Q57 and Q$57.
Microsoft Excel
The spreadsheet program in the Microsoft Office suite; used to enter, analyze, and present quantitative data; also called Excel.
average
The sum of the data values divided by the number of values in the data series; also called mean.
drag and drop
The technique of moving an item by selecting it and then dragging the selection to a new location; can be used to move an Excel cell or range, a PowerPoint thumbnail, or a Word text or graphic.
How does Excel indicate that a cell contains linked text?
The text is displayed in green and underlined.
What is the difference between a what-if analysis by trial and error and by Goal Seek?
The trial and error process involves changing the constant value that is the input cell for formulas in the worksheet trying to get a particular result in an output calculation. With Goal Seek, one supplies the desired value for the output cell and Excel calculates the required value for the input cell.
lookup values
The value that is being looked up in a lookup table.
mode
The value that is repeated most often in a data set.
Backstage view
The view that contains commands that let you manage the file and program settings.
What is the difference between theme colors and standard colors?
Theme colors are a set of 12 coordinated colors that belong to a theme. Standard colors are 10 colors that are always available regardless of the workbook's theme.
What happens to worksheet rows that do not match the filter criteria? What happens to the data they contain?
They are hidden in the worksheet, but the data is not removed.
When would you use an advanced filter in place of the filter buttons?
To join several fields with an OR logical operator
freeze
To keep rows and/or columns you select visible as you scroll a worksheet.
paste
To place an item stored in the Clipboard into a location in a file or window.
nested
To place one thing inside another, such as a function inside another function.
Hiding
To remove a row, column, or worksheet from view while still keeping it part of the worksheet.
Deleting
To remove both the data and the selected cells from the worksheet.
What are two reasons for using filter buttons rather than slicers to filter data?
Use filter buttons when you want to apply text filter, date filters, and numeric filters, and when you want to view all of the record in place as you filter the data.
What are two reasons for using slicers rather than filter buttons to filter data?
Use slicers when you want to filter the data into a few distinct categories that can be easily listed within the slicer and when you want to perform the filter on a separate worksheet from the data.
When would you create a template rather than just providing a coworker with the copy of your workbook?
When you don't want the coworker modifying the workbook itself, but only when you want the coworker to create a new workbook based on the workbook design
When would you paste a copied cell using the Paste Link option?
When you want to paste the reference to the cell and not the cell's value or format
When multiple filter buttons are used with a data range, how are criteria in different fields combined?
With an AND logical operator
How would you select multiple graphic objects within a worksheet?
You can select multiple graphic objects by clicking the Selection Pane button in the Arrange group on the Graphic Tools Format tab to open the Selection pane. In the Selection pane, hold down CTRL and click each graphic name to select it. You can also click the Find & Select button in the Editing group on the Home tab and then click the Select Objects command to put the insertion point into the mode where it selects objects instead of worksheet cells.
Describe two methods of applying the same format to different ranges.
You can use the Format Painter to copy and paste the format from one range into another, or you can apply the same cell style to both ranges.
Why would you not use a sparkline?
You would not use a sparkline if you need to show specific details in your chart or need to augment the informative chart elements.
When would you use a Pareto chart?
You would use a Pareto chart to quickly determine which category or categories contributed the most to an overall total.
When would you use a histogram?
You would use a histogram to view the distribution of data values over a specified range.
Under what circumstances would you use sparklines in a report?
You would use sparklines when you want to display several charts in a report but are only interested in showing general trends rather than specific details.
What is the structural reference to the table header row?
[#Headers]
What three chart elements are included in a pie chart?
chart title, chart legend, and data labels
argument In Excel
information necessary for a formula or function to calculate an answer
In the following function, which arguments are required an which arguments are optional: AVERAGE(number 1, (number2), (number3),...)
number1 is a required argument; number2, number3... are optional arguments
Scaling
the range of values displayed on a chart axis, or to change the size of the worksheet on the printed page.
Unhiding
to redisplay hidden rows, columns, or worksheets.
cell style
A collection of formatting options, such as a specified font, font size, font styles, font color, fill color, and borders, that is applied to a cell.
What is a conditional format?
A conditional format is a format that changes based on the value entered in the cell.
AutoComplete
A feature that automatically suggests text, numbers, or dates to insert.
template
A file with a theme applied and that may contain formatted placeholder text, headers and footers, and graphics that you replace with your own information for hundreds of purposes, including budgets, flyers, and resumes; template files have slightly different file extensions than standard application files, such as .xltx, .pptx., or .dotx.
standard font
A font that retains its appearance no matter what theme is used with the workbook
Long Date format
A format for dates that displays the day of the week and the full month in addition to the day of the month and the year.
RGB Color model
A format used to create custom colors by specifying varying intensities of red, green, and blue.
spreadsheet
A grid of cells that contain numbers and text; in Microsoft Excel, a spreadsheet is called a worksheet.
keyboard shortcut
A key or combination of keys that you press to access a feature or perform a command, instead of using a mouse or touch gestures.
ScreenTip
A label that appears when you point to a button or object, that may include the name, purpose, or keyboard shortcut for the object; may also include a link to associated help topics.
shortcut menu
A list of frequently used commands that relate to an object, typically displayed by right-clicking; the commands on a shortcut menu are related to the item you right-clicked.
theme
A predefined, coordinated set of colors, fonts, graphical effects, and other formats that can be applied to documents, spreadsheets, presentations, publications, and Access forms and reports to give them a consistent, professional look.
Flash Fill
An Excel feature that looks for patterns in the data you enter and automatically fills or formats data in remaining cells based on those patterns.
General format
An Excel number format that, for the most part, displays values exactly as they are typed.
Live Preview
An Office feature that shows the results that would occur in your file, such as the effects of formatting options on a document's appearance, if you clicked the option you are pointing to.
The range B3:B13 is merged into a single cell. What is the cell reference
B3
Describe how to add the workbook file name to the center section of the footer on every page of the printout?
Click the Page Layout tab, and then click the Dialog Box Launcher in the Page Setup group. Click the Header/Footer tab in the Page Setup dialog box. Click the Custom Footer button, and then click in the Center section box. Click the Insert File Name button. Click OK in each dialog box.
Cell B2 contains the entry May 3, 2021. Why doesn't Excel consider this a text entry?
Dates and times are stored as numbers not as text.
How do you autofit a column to match its longest cell entry?
Double-click the right border of the column heading or click the Format button in the Cells group on the Home tab and click AutoFit Column Width.
Serif fonts
Fonts that have short decorative lines at the upper and lower ends of their characters.
margin
In Excel and Word, the space between the page content and the edges of the page.
Short Date format
In Excel, an abbreviated date format in the format mm/dd/yyyy.
standard colors
In Excel, one of 10 colors—dark red, red, orange, yellow, light green, green, light blue, blue, dark blue, and purple—that is always available regardless of the workbook's theme.
footer
In Excel, text or graphics that print at the bottom of each page.
header
In Excel, text or graphics that print at the top of each page.
Currency format
In Excel, the number format that places a currency symbol directly to the left of the first digit of the monetary value, adds a thousands separator to the value, shows two decimal places, lines up numbers within a column by their decimal points, and displays negative numbers with a negative sign.
arithmetic operators
In a formula, a symbol that performs mathematical calculations, such as addition (+), subtraction (-), multiplication (*), division (/), or exponentiation (^).
AutoFit
In an Excel worksheet or a table in Word, PowerPoint, or Access a feature that automatically adjusts column width or row height to accommodate its widest or tallest entry.
Describe the four ways of viewing worksheet contents in Excel.
Normal view shows the columns and rows of the worksheet. Page Layout view shows the layout of the worksheet as it appears on a page. Page Break Preview shows the page breaks within the worksheet. Formula view shows formulas rather than the values returned by the formulas.
How would you highlight the top 10% values in the range A1:C20?
Select the range A1:C20. On the Home tab, in the Styles group, click the Conditional Formatting button. Point to Top/Bottom Rules, and then click Top 10%. In the dialog box, verify that 10 is entered for the percent of the items to show, and then click OK.
INT function
The function that always rounds a value down to the next lowest integer.
MROUND function
The function that rounds a value to the nearest multiple of a given number.
ROUNDDOWN function
The function that rounds a value to the next lowest digit.
Touch Mode
The interface that that makes it easier to interact with a computer touchscreen using your finger instead of a mouse pointer; the ribbon increases in height, the buttons are larger, and more space appears around buttons so you can more easily use your finger or stylus to tap screen elements.
Accounting format
The number format that places a currency symbol at the left edge of the cell, adds a thousands separator to the value, shows two decimal places, lines up numbers within a column by their currency symbols and decimal points, displays negative numbers within parentheses, and displays zero values with a dash
A cell containing a number displays #######. Why does this occur, and what can you do to fix it?
The number of digits could not fit within the width of the cell. To correct this problem, either increase the width of the cell column or reduce the number of digits to the right of the decimal point.
landscape orientation
The position of a page, slide, or worksheet so that the page, slide, or worksheet is wider than it is tall.
What is a print area?
The print area is the range within a worksheet that you specify to be printed.
Clearing
To remove data, formats, or filters from cells, leaving those cells blank but preserving the current worksheet structure.
How are chart sheets different from worksheets?
Worksheets contain a grid of cells in which text and formulas can be entered and can also contain graphical objects. Chart sheets contains charts and graphic objects but do not contain grids in which text and formulas can be entered.
text string In Excel
a series of text characters.
Text data in Excel
any combination of letters, numbers, and symbols.