Excel Section 1
Excel Section 2
Excel Section 3
Misc. #1
Misc. #2
100
Is a pre-defined formula.
What is a Function?
100
Is the default numeric style format that cells are initially set to.
What is General?
100
Is the symbol to be placed next to a column letter or row number to create absolute reference.
What is a dollar sign $ ?
100
Is the feature used to remove everything from a cell, including text and formats.
What is the Clear All feature?
100
Is the formula that will divide the contents of cell C6 by the contents in cell C12.
What is =C6/C12?
200
Is the key you press to open the Excel Help window.
What is the F1 key?
200
Is the feature that stores predefined format options.
What are Cell Styles?
200
The Page Setup options such as custom margins can be changed using the PAGE LAYOUT tab or while viewing a preview of how the worksheet will print in this area.
What is the Print backstage area?
200
Is the term used to refer to the values identified within parentheses in the SUM function.
What is an argument?
200
Are the two additional tabs that appear when a chart is selected.
What are Chart Tools - Design and Format tabs?
300
Is what the cell pointer changes to when pointing at the small green square in the bottom right corner of the active cell.
What is a thin black cross?
300
Is the button you click on in the Clipboard group on the HOME tab to copy the formats of the active cell.
What is the Format Painter button?
300
Is the category that the IF function is found in, in the Function Library group.
What is the Logical category?
300
Is the button in the Illustrations group you click on to insert an image stored in a file.
What is the Pictures button?
300
Is the type of chart that illustrates each data point's size in proportion to the total of all items in the data source range.
What is Pie chart?
400
Is the area that contains commands and buttons for performing actions divided into tabs and groups.
What is the Ribbon?
400
Is the feature wherein Excel that shows the results of a format option while pointing to the option in a drop-down list or gallery.
What is the Live Preview feature?
400
AVERAGE and COUNT are two of the functions grouped in this function category.
What is the Statistical function category?
400
Is the feature that stores a set of colors, fonts, and effects that can be applied to the entire worksheet.
What are Themes?
400
Is the tab AND button you click on to search for art on Office Online.
What is the Insert tab and the Online Pictures button?
500
Is the keyboard shortcut for displaying formulas in a worksheet.
What is Ctrl + `?
500
Is the term for adjusting a column width to the length of the longest entry.
What is AutoFit Column Width?
500
Is the financial function that returns the payment for a loan based on a constant interest rate and period of time for repayment.
What is the PMT function?
500
Is the view you must be in to type header or footer text directly in the worksheet.
What is Page Layout view?
500
Is the Date and Time function that inserts the current date (without the time) in the active cell.
What is the TODAY function?